OraFAQ Forum: Networking and Gateways » ora-12170:TNS Connect TimeOut Error

Home » RDBMS Server » Networking and Gateways » ora-12170:TNS Connect TimeOut Error (Windows 7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ora-12170:TNS Connect TimeOut Error [message #538862]

Tue, 10 January 2012 01:25

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

Report message to a moderator

Re: ora-12170:TNS Connect TimeOut Error [message #538864 is a reply to message #538862]

Tue, 10 January 2012 01:28

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

1/ Does "ping" work? (most likely no)
2/ Does "tnsping" work?

Regards
Michel

Report message to a moderator

Re: ora-12170:TNS Connect TimeOut Error [message #538865 is a reply to message #538864]

Tue, 10 January 2012 01:30

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..

Report message to a moderator

Re: ora-12170:TNS Connect TimeOut Error [message #538866 is a reply to message #538865]

Tue, 10 January 2012 01:32

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

Report message to a moderator

Re: ora-12170:TNS Connect TimeOut Error [message #538868 is a reply to message #538865]

Tue, 10 January 2012 01:38

Michel Cadot
Messages: 68645
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

Report message to a moderator

Re: ora-12170:TNS Connect TimeOut Error [message #538872 is a reply to message #538868]

Tue, 10 January 2012 01:47

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...

Report message to a moderator

Re: ora-12170:TNS Connect TimeOut Error [message #538876 is a reply to message #538872]

Tue, 10 January 2012 02:20

Michel Cadot
Messages: 68645
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

Report message to a moderator

Re: ora-12170:TNS Connect TimeOut Error [message #538951 is a reply to message #538876]

Tue, 10 January 2012 08:49

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...

Report message to a moderator

Re: ora-12170:TNS Connect TimeOut Error [message #538960 is a reply to message #538951]

Tue, 10 January 2012 09:12

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: ora-12170:TNS Connect TimeOut Error [message #538981 is a reply to message #538960]

Tue, 10 January 2012 10:58

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

Report message to a moderator

Re: ora-12170:TNS Connect TimeOut Error [message #538984 is a reply to message #538981]

Tue, 10 January 2012 11:18

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: ora-12170:TNS Connect TimeOut Error [message #539287 is a reply to message #538984]

Fri, 13 January 2012 00:54

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...

Report message to a moderator

Previous Topic:	ORA-12560: TNS:protocol adapter error
Next Topic:	Remote query not working as expected.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 19:23:25 CDT 2024