ora 12535

Printable View

01-09-2002, 01:26 PM
Knarayan

HI all,

I am getting ora 12535: connection timed out error when I try connecting thru sqlplus from a client to the server.

I am able to establish connection thru tnsping and is quite fast also.
I tried putting connect_timeout_listener parameter to 0 and also to a very high value but didn't help.

WHat could be the issue, please help this is urgent!!
01-09-2002, 02:06 PM
Knarayan

Any clue,please help!!!
01-09-2002, 02:42 PM
gaegoori

connect _timeout_listener_name=0 right?.... with _name
01-09-2002, 02:45 PM
Knarayan

Yes that's what I have added to listner.ora
01-09-2002, 02:54 PM
gaegoori

on your tnsnames.ora file:

ALIAS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = 10.10.10.10)(Port = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME=HOSTNAME.DOMAINNAME.COM)
)
)

Try to specify Host with IP address and spell out the SERVICE_NAME= full hostname and domain name instead of
SID=SIDNAME...

Also, on your listener.ora file,

set your GLOBAL_DBNAME to full hostname and domain name as it appears in SERVICE_NAME in tnsname.ora

not sure if it's gonna work or not, but you can give it a try...
01-09-2002, 09:06 PM
sonofsita

please refer to doc id 119706.1 on metalink.