Home » RDBMS Server » Server Administration » Ora- 12535: operation timed out error. (oracle 10g,suse 9)
Ora- 12535: operation timed out error. [message #385610] Tue, 10 February 2009 04:33 Go to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
I can access the database from server though putty but from client toad it gives
Ora- 12535: operation timed out error.

Please tell me cause of the problem?

orclrepl =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 62.146.88.125)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

C:\Documents and Settings\test>ping 62.146.88.125

Pinging 62.146.88.125 with 32 bytes of data:

Reply from 62.146.88.125: bytes=32 time=171ms TTL=47
Reply from 62.146.88.125: bytes=32 time=173ms TTL=47
Reply from 62.146.88.125: bytes=32 time=177ms TTL=47
Reply from 62.146.88.125: bytes=32 time=184ms TTL=47

Ping statistics for 62.146.88.125:
    Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 171ms, Maximum = 184ms, Average = 176ms

C:\Documents and Settings\test>tnsping orclrepl

TNS Ping Utility for 32-bit Windows: Version 9.0.1.4.1 - Production on 10-FEB-20
09 15:53:43

Copyright (c) 1997 Oracle Corporation.  All rights reserved.

Message 3511 not found; No message file for product=NETWORK, facility=TNSMessage
 3512 not found; No message file for product=NETWORK, facility=TNSAttempting to
contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 62.146.88.125)(PORT =
1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
TNS-12535: Message 12535 not found; No message file for product=NETWORK, facilit
y=TNS


Thanks,
Re: Ora- 12535: operation timed out error. [message #385648 is a reply to message #385610] Tue, 10 February 2009 06:39 Go to previous messageGo to next message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Can you just show your listener.ora file,sqlnet.ora file. & Did you check your CONNECT_TIMEOUT parameter.and also check if any firewall enabled

[Updated on: Tue, 10 February 2009 06:54]

Report message to a moderator

Re: Ora- 12535: operation timed out error. [message #385710 is a reply to message #385610] Tue, 10 February 2009 13:45 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
This has to do with your environment.
Try setting TNS_ADMIN.
Re: Ora- 12535: operation timed out error. [message #385740 is a reply to message #385710] Tue, 10 February 2009 22:38 Go to previous message
Eddblack
Messages: 2
Registered: February 2009
Location: San Francisco
Junior Member
Error Cause:
The requested connection could not be completed within the timeout period specified by the CONNECT_TIMEOUT parameter in LISTENER.ORA. This error arises from the TNSLSNR.

Action:
Either reconfigure CONNECT_TIMEOUT to be 0, which means wait indefinitely, or reconfigure CONNECT_TIMEOUT to be some higher value. Or, if the timeout is unacceptably long, turn on tracing for further information. 30-100 Oracle9i Database Error Messages

http://www.errorpro.com/oracleerrors/oraerror.php?level1=Oracle&send=Send&ecode=ORA-12535


[Updated on: Wed, 11 February 2009 00:48] by Moderator

Report message to a moderator

Previous Topic: Migrating and upgrade DB to new server
Next Topic: NEED SUGGESTION
Goto Forum:
  


Current Time: Fri Nov 29 15:39:47 CST 2024