| Frequent Ora-12537 Errors [message #476530] |
Thu, 23 September 2010 14:13  |
rsreddy28
Messages: 295
Registered: May 2007
|
Senior Member |
|
|
Hi All,
We have an Java Application which connects to database but sometimes we are getting this error Ora-12537 .
We had the below event again yesterday, and we were able to get a pretty good look at it. Yesterday's occurrence happened when there was still about 2.5GB of RAM free, so we are now thinking maybe it isn't actually RAM related.
When it happened a moment ago, I ran some tests while the event was underway, and what I found was rather interesting. SQLPlus connections (on command line) fail to connect to the XXXX database, but at the same time, I can successfully connect to other databases on same DB server. Below is how it looks from a SQLPlus point of view.
*For the first connection, I think I used the wrong username, or perhaps the schema is actually in another DB instance , so I got invalid username/password back. But the important thing is that it did connect, and Oracle responded back. Why would one DB instance be reachable while the other DB instance is refusing connections?
abx@xyz:/abv/documentum/dba/log$ sqlplus helpwiki/******@bbprd@/home/nnn/test.sql
SQL*Plus: Release 10.2.0.3.0 - Production on Thu Sep 23 11:18:19 2010
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name: ^C
abc@xyz:/abv/documentum/dba/log$ sqlplus prt/******@prt@/home/nnn/test.sql
SQL*Plus: Release 10.2.0.3.0 - Production on Thu Sep 23 11:18:28 2010
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
ERROR:
ORA-12537: TNS:connection closed
I'm not able to figure out the root cause of this . Sometimes the user is able to connect to the database and sometimes he is not and getting ora-12537.
Looking forward for your reply.
Thanks,
Raj
|
|
|
|
|
|
|
|
|
|
| Re: Frequent Ora-12537 Errors [message #476547 is a reply to message #476546] |
Thu, 23 September 2010 19:24  |
rsreddy28
Messages: 295
Registered: May 2007
|
Senior Member |
|
|
Hi ,
The end user says this " The application is Java based, so it already has its heap space allocated to it, and thus we never saw any memory related issues within the application itself. The application uses Oracle OCI, so connections must have system resources outside of the JVM, and we think Oracle connections were failing to be created due to the lack of system resources during those moments. "
Can you guide me on this and let me know how to find the root cause of this.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Frequent Ora-12537 Errors [message #476553 is a reply to message #476552] |
Thu, 23 September 2010 20:13 |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
12537, 00000, "TNS:connection closed"
// *Cause: "End of file" condition has been reached; partner has disconnected.
// *Action: None needed; this is an information message.
Oracle is victim; not culprit.
Something external to Oracle affects packet exchange.
I have no good idea what is wrong, but I am SURE that if you create a SQL*Net connection to DB from DB Server that it will not report this error.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
