| ORA: 12535 TNS operation timed out error [message #66392] |
Wed, 15 May 2002 23:51  |
Navin
Messages: 31
Registered: May 2002
|
Member |
|
|
Hi,
Whenever I try to connect to Oracle using a connect string (scott/tiger@string) or from SQL Server Enterprise Manager to Oracle, I get this error:
Ora 12535: TNS operation timed out.
Could someone help me find solution to this.
Thanks so much,
Navin
The Listener.ora file contents are :
# LISTENER.ORA Network Configuration File: C:orant_9inetworkadminlistener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Perseus)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:orant_9i)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl9i1)
(ORACLE_HOME = C:orant_9i)
(SID_NAME = orcl9i1)
)
)
|
|
|
|
| Re: ORA: 12535 TNS operation timed out error [message #66395 is a reply to message #66392] |
Thu, 16 May 2002 06:03  |
Alan
Messages: 68
Registered: October 1999
|
Member |
|
|
Navin,
ORA-12535 is a Timing issue.
To resolve this problem, try to speed up the connection.
1. Try to use the exact IP address instead of name to decrease lookup time.
2. In file 'listener.ora', increase the value of parameter 'CONNECT_TIMEOUT_listener_name'. The initial value is 10.
Hope this helps.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
