Since it looks like Oracle (from the ORA error #) I would have your DBA check 
the maximum number of processes/sessions that have been configured in the 
database.   I think you are running out of connections (Each thread you tell 
ARS to use is a connection to the database).

You may also be running short on memory in the database (SGA and PGA), but I 
think that would generate a different error.

Fred

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Brian Goralczyk
Sent: Monday, October 27, 2014 3:24 PM
To: arslist@ARSLIST.ORG
Subject: One Server from Server Group getting SQL error

**
Any ideas or suggestions on what to look at would be GREATLY appreciated.

I have two servers in a server group.  When one is brought up we are fine.  
When we bring the second one up, it seems to steal the DB connection.  If we 
recycle the first one it will take back the connection.  And the server that 
was running the longest seems to lose the connection.

The error that we are getting is:

The SQL database operation failed. : ORA-01012: not logged on Process ID: 9404 
Session ID: 927 Serial number: 38337 (ARERR 552)

Again, any suggestions on what to look at would be GREATLY appreciated.

Thank you,

Brian Goralczyk
Phone 574-643-1144
Email bgoralc...@gmail.com<mailto:bgoralc...@gmail.com>



_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Reply via email to