| ORA-12170: TNS:Connect timeout occurred [message #540477] |
Tue, 24 January 2012 00:46  |
 |
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 #540493 is a reply to message #540477] |
Tue, 24 January 2012 01:46  |
John Watson
Messages: 8963
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
