Home » RDBMS Server » Networking and Gateways » ORA-12170: TNS:Connect timeout occurred (Oracle 10.2.0.1.0,windows)
ORA-12170: TNS:Connect timeout occurred [message #540477] Tue, 24 January 2012 00:46 Go to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Hi,

I get below error when trying to connect to database server using

C:\Documents and Settings\Administrator>sqlplus jack/jack@DB_PROD

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jan 24 12:11:45 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ERROR:
ORA-12170: TNS:Connect timeout occurred

Enter user-name:


FYI,

The database i am trying to connect is 9.2.0.8.0 and the client that is installed in my machine is 10.2.0.1.0

Is problem with the database versions ?

Can somebody clarify the reason for the above error?



Re: ORA-12170: TNS:Connect timeout occurred [message #540480 is a reply to message #540477] Tue, 24 January 2012 00:52 Go to previous messageGo to next message
Michel Cadot
Messages: 67464
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Is problem with the database versions ?


No.

Firewall?

Regards
Michel
Re: ORA-12170: TNS:Connect timeout occurred [message #540482 is a reply to message #540480] Tue, 24 January 2012 01:05 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Thank you Michel,

I have one more connectivity issue (Unsupported oracle database version) .Can i ask the question
here or i need to open a new thread ?

Re: ORA-12170: TNS:Connect timeout occurred [message #540484 is a reply to message #540482] Tue, 24 January 2012 01:11 Go to previous messageGo to next message
Michel Cadot
Messages: 67464
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
New question, new topic unless it is the same error in the same kind of environment, do not mix up several questions.

Regards
Michel
Re: ORA-12170: TNS:Connect timeout occurred [message #540493 is a reply to message #540477] Tue, 24 January 2012 01:46 Go to previous messageGo to next message
John Watson
Messages: 8395
Registered: January 2010
Location: Global Village
Senior Member
Can be any incorrect hostname, check that with tnsping which will show you the connect sting being used:
c:\users\john\home>tnsping orcl

TNS Ping Utility for 32-bit Windows: Version 11.2.0.3.0 - Production on 24-JAN-2012 07:45:35

Copyright (c) 1997, 2011, Oracle.  All rights reserved.

Used parameter files:
c:\app\john\product\11.2.0\dbhome_1\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = jwdell.bplc.co.za)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE
_NAME = orcl)))
OK (20 msec)

c:\users\john\home>


update: tags

[Updated on: Tue, 24 January 2012 01:48]

Report message to a moderator

Re: ORA-12170: TNS:Connect timeout occurred [message #540495 is a reply to message #540477] Tue, 24 January 2012 02:04 Go to previous message
arunkumarsu
Messages: 6
Registered: September 2011
Location: Chennai
Junior Member
It will not be a Version problem, Please Check the Host name, Host connection, Listener status and TNS Entry.
Previous Topic: Remote query not working as expected.
Next Topic: one ip address..two listeners and two db instances
Goto Forum:
  


Current Time: Sun Oct 25 06:24:17 CDT 2020