Home » RDBMS Server » Networking and Gateways » Frequent Ora-12537 Errors (10.2.0.3.0,Sun 5.10 )
Frequent Ora-12537 Errors [message #476530] Thu, 23 September 2010 14:13 Go to next message
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 #476542 is a reply to message #476530] Thu, 23 September 2010 16:41 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
> sqlplus prt/******@prt@/home/nnn/test.sql
what is the two at signs all about on the command line?
Is COPY & PASTE really broken for you?

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: Frequent Ora-12537 Errors [message #476544 is a reply to message #476542] Thu, 23 September 2010 17:07 Go to previous messageGo to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Apologise , it was an Typo.
Re: Frequent Ora-12537 Errors [message #476546 is a reply to message #476544] Thu, 23 September 2010 18:03 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>We have an Java Application which connects to database
Does application utilize connection pooling?
I suspect it does not; which might contribute to the problem.

[Updated on: Thu, 23 September 2010 18:04]

Report message to a moderator

Re: Frequent Ora-12537 Errors [message #476547 is a reply to message #476546] Thu, 23 September 2010 19:24 Go to previous messageGo to next message
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 #476548 is a reply to message #476547] Thu, 23 September 2010 19:28 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
since you don't answer my question, I can't answer your question without having additional details

[Updated on: Thu, 23 September 2010 19:29]

Report message to a moderator

Re: Frequent Ora-12537 Errors [message #476549 is a reply to message #476548] Thu, 23 September 2010 19:38 Go to previous messageGo to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
The app users are using Documentum application and they are using connection pooling to get connected.
Re: Frequent Ora-12537 Errors [message #476550 is a reply to message #476549] Thu, 23 September 2010 19:47 Go to previous messageGo to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
And adding to this , they are facing this issue only recently and there has been no change in either database or application side.
Re: Frequent Ora-12537 Errors [message #476551 is a reply to message #476549] Thu, 23 September 2010 19:49 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>they are using connection pooling to get connected.
Then is it not the problem I was considering.
Re: Frequent Ora-12537 Errors [message #476552 is a reply to message #476551] Thu, 23 September 2010 19:56 Go to previous messageGo to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Then any idea , how we can approach to solve this.
Re: Frequent Ora-12537 Errors [message #476553 is a reply to message #476552] Thu, 23 September 2010 20:13 Go to previous message
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.
Previous Topic: Oracle Connection
Next Topic: tnsnames.ora file not present
Goto Forum:
  


Current Time: Wed May 25 04:54:57 CDT 2022