Hi friends,
I have a 3rd party application that is running on Oracle 10g DB (Aix 5L). It has been running smoothly for 1 month now.
But suddenly today it hit this ORA-12537?
Which of the following is near to this scenario? or do you have other ideas?
What to do with ORA-12537: TNS: connection closed error
The ORA-12537 is an information message and means that the connection has been closed. This can be caused by a number of reasons:
1. Database is shut down (maybe for nightly backup), but connection to database was kept by client.
2. A time-out occurred on the client-connection.
3. When firewall closes idle connections.
3. A configuration problem in sqlnet.ora or listener.ora.
4. You have a path name that is too long for the Oracle TNS client on windows. (MetaLink Note:263489.1 )
This issue is due to the connection string being large enough that the connection packet is being split into two packets and then sent to the listener. There are several workarounds for the issue.
a. Install the exe in a shorter named directory.
b. Modify the TNS Names entry so that it is shorter.
c. Replace domain names with IP Addresses if that shortens and vice versa.
d. Remove any parameters from the entry that are not needed.
e. Patch the Database Listener to the most recent version.
5. Oracle security is enables (for example in Oracle Apps). Solution either:
a) Edit sqlnet.ora file and add your client-ip to tcp.invited_nodes.
b) Remove secutity by editing sqlnet.ora and comment out parameter tcp.validnode_checking = yes by adding # at the beginning of the line.
***Courtesy of Oradev.Com
What do you mean by #1 "kept silent"?
All of the above will fail at first day of implem, but its been running for 1 month now :(
Thanks a lot
Ms K
Edited by: ytterp2009 on Jun 4, 2010 6:44 PM
Edited by: ytterp2009 on Jun 4, 2010 6:50 PM changing "dear" to "friend"