TNS-12535: TNS:operation timed out Oracle

TNS-12535:  TNS: operation timed out

‘nt secondary err code: 60’ , which indicates that from the Windows OS TCP/IP layer has been raised a timeout , which has been translated under Oracle in these informational messages.

Operating system level:

Check that there is no firewall blocking the traffic on port 1521

The TNS-12535 or ORA-12535 error is commonly a timeout error associated with Firewalls or slow Networks.

Oracle Level:
Check  incorrect “timeout” parameter setting for the following files:

listener.ora -->
INBOUND_CONNECT_TIMEOUT_ =

sqlnet.ora -->
SQLNET.INBOUND_CONNECT_TIMEOUT
sqlnet.expiry_time = 0 (indefinite time)
sqlnet.expiry_time increase the time limit for the connectivity.

Note: TNS-12170/ ORA-12170 at connection time

Least chance is that slow connections to the database

You can used parameter PRE_PAGE_SGA for increased the process startup duration. not recommended to set.

Every process when starts must access page in the SGA. Solution for TNS-12170/ ORA-12170 at connection time

 

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s