Home » RDBMS Server » Networking and Gateways » ora-12170:TNS Connect TimeOut Error (Windows 7)
icon4.gif  ora-12170:TNS Connect TimeOut Error [message #538862] Tue, 10 January 2012 01:25 Go to next message
subani123
Messages: 11
Registered: January 2012
Location: pune
Junior Member
Hi EveryOne,
I am new to Oracle 10g DBA Administration,I installed my Oracle 10g R2 software in redhat linux installed in VMWare player in my laptop.

I am trying to connect to database from my laptop which has windows 7 installed

My goal is to connect to database installed in linux vmware from my laptop having windows7 OS..

I have installed Oracle instant client on windows 7,trying to make a connection to database but its giving me the following error when i tried...

sqlplus sqlplus scott/tiger@(description=(address_list=(
address=(protocol=TCP)(host=192.168.1.7)(port=1521)))(connect_data=(service_name=subhani)))..

ora-12170:TNS Connect TimeOut Error..

please help me on this,trying hard to resolve this..
Thanks



Re: ora-12170:TNS Connect TimeOut Error [message #538864 is a reply to message #538862] Tue, 10 January 2012 01:28 Go to previous messageGo to next message
Michel Cadot
Messages: 67455
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Does "ping" work? (most likely no)
2/ Does "tnsping" work?

Regards
Michel
Re: ora-12170:TNS Connect TimeOut Error [message #538865 is a reply to message #538864] Tue, 10 January 2012 01:30 Go to previous messageGo to next message
subani123
Messages: 11
Registered: January 2012
Location: pune
Junior Member
Hi Michel,

Ping to linux machine in vmware player works fine from windows 7...eg(ping 192.168.1.7)

tnsping dbname in linux works fine..
Re: ora-12170:TNS Connect TimeOut Error [message #538866 is a reply to message #538865] Tue, 10 January 2012 01:32 Go to previous messageGo to next message
subani123
Messages: 11
Registered: January 2012
Location: pune
Junior Member
I dont know how the connectivity between two machines established..very poor in networking issues ,please help
Re: ora-12170:TNS Connect TimeOut Error [message #538868 is a reply to message #538865] Tue, 10 January 2012 01:38 Go to previous messageGo to next message
Michel Cadot
Messages: 67455
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
subani123 wrote on Tue, 10 January 2012 08:30
Hi Michel,

Ping to linux machine in vmware player works fine from windows 7...eg(ping 192.168.1.7)

tnsping dbname in linux works fine..


Always post what you do and get. Do NOT just tell it.

Regards
Michel

Re: ora-12170:TNS Connect TimeOut Error [message #538872 is a reply to message #538868] Tue, 10 January 2012 01:47 Go to previous messageGo to next message
subani123
Messages: 11
Registered: January 2012
Location: pune
Junior Member
Thanks for your reply Michel

My Tnsname.ora file:
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.7)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = subhani)
)
)


When I tried this:
sqlplus scott/tiger@ORCL..getting the following error

ORA-12560:TNS:protocol adapter error

so den I tried without tnsnames.ora file like..
sqlplus sqlplus scott/tiger@(description=(address_list=(
address=(protocol=TCP)(host=192.168.1.7)(port=1521)))(connect_data=(service_name=subhani)))..

getting the following error

ora-12170:TNS Connect TimeOut Error..


please help...

Re: ora-12170:TNS Connect TimeOut Error [message #538876 is a reply to message #538872] Tue, 10 January 2012 02:20 Go to previous messageGo to next message
Michel Cadot
Messages: 67455
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post the ping and tnsping from the same window you tested sqlplus (the bold part is important and mandatory, the ping and tnsping MUST be done in the same window).

Regards
Michel
Re: ora-12170:TNS Connect TimeOut Error [message #538951 is a reply to message #538876] Tue, 10 January 2012 08:49 Go to previous messageGo to next message
subani123
Messages: 11
Registered: January 2012
Location: pune
Junior Member
Hi Michel,
Thanks for your quick reply..
tnsping ORCL gives me the error..
'tnsping' is not recognised as internal or external command,operable program or batch file..

I installed the Oracle Instant client files instantclient-basic-win32-10.2.0.5,instantclient-sqlplus-win32-10.2.0.5 from the oracle site for connecting to remote database...

Please help me where I am missing or tell me any other way to connect to my database installed in redhat linux on vmware player...
Re: ora-12170:TNS Connect TimeOut Error [message #538960 is a reply to message #538951] Tue, 10 January 2012 09:12 Go to previous messageGo to next message
BlackSwan
Messages: 26747
Registered: January 2009
Location: SoCal
Senior Member
>I am trying to connect to database from my laptop which has windows 7 installed

Which Windows Edition is installed on the laptop?
Which version (to 4 decimal places) of Oracle software is installed on the laptop?
What is hostname & IP# for laptop system?
What is hostname & IP# for VM system?

post results from 4 different "ping" commands; two ping from each system
From laptop do
ping VM_IP#
ping VM_Hostname
from VM System do
ping LAPTOP_IP#
ping LAPTOP_HOSTNAME
Re: ora-12170:TNS Connect TimeOut Error [message #538981 is a reply to message #538960] Tue, 10 January 2012 10:58 Go to previous messageGo to next message
subani123
Messages: 11
Registered: January 2012
Location: pune
Junior Member
64-bit windows 7 OS..Oracle 10g release 2 software installed on linux

ping 192.168.1.7(linux ip from windows)---Sucess
ping linux(linux hostname from windows)---Success

ping 192.168.1.9(windows 7 IP from Linux )--Failed----Destination Host Unreachable
ping PChostname(winows 7 hostname from Linux)--Failed..---Unknown Host

how to proceed den..please give me quick reply



Re: ora-12170:TNS Connect TimeOut Error [message #538984 is a reply to message #538981] Tue, 10 January 2012 11:18 Go to previous messageGo to next message
BlackSwan
Messages: 26747
Registered: January 2009
Location: SoCal
Senior Member
>how to proceed den..please give me quick reply

Consider resolving the networking configuration issues to allow Linux to initiate a successful network connection to Windows
Re: ora-12170:TNS Connect TimeOut Error [message #539287 is a reply to message #538984] Fri, 13 January 2012 00:54 Go to previous message
subani123
Messages: 11
Registered: January 2012
Location: pune
Junior Member
Hi BlackSwan,

I am able to ping both machines to and fro...
As Michel said ping and tnsping should be done from same machine,but tnsping gives me command not found error in my host OS windows7
How to proceed further please help...
Previous Topic: ORA-12560: TNS:protocol adapter error
Next Topic: Remote query not working as expected.
Goto Forum:
  


Current Time: Sat Oct 24 09:58:24 CDT 2020