I wonder if rebooting simply cleared the DB connection locks. I guess time will tell, if the issue recurs.
Rick Cook On Wed, Oct 29, 2014 at 6:03 AM, Brian Goralczyk <bgoralc...@gmail.com> wrote: > ** > Just to update the list. > > We haven't found the smoking gun yet, however; rebooting the db server and > the application servers made the problem go away. If/when I get an actual > root cause I will gladly share it with the list. > > Brian Goralczyk > > Brian Goralczyk > Phone 574-643-1144 > Email bgoralc...@gmail.com > > On Mon, Oct 27, 2014 at 10:54 PM, William Rentfrow < > wrentf...@stratacominc.com> wrote: > >> ** >> >> Agreed - I've seen similar things happen when we didn't have enough >> connections configured. >> >> >> >> William Rentfrow >> >> wrentf...@stratacominc.com >> >> Office: 715-204-3061 or 701-232-5697x25 >> >> Cell: 715-498-5056 >> >> >> >> *From:* Action Request System discussion list(ARSList) [mailto: >> arslist@ARSLIST.ORG] *On Behalf Of *Terry Bootsma >> *Sent:* Monday, October 27, 2014 5:41 PM >> *To:* arslist@ARSLIST.ORG >> *Subject:* Re: One Server from Server Group getting SQL error >> >> >> >> ** >> >> Sounds definitely like an Oracle configuration issue. >> >> >> >> Would be interesting to open multiple sqlplus sessions using your Oracle >> Remedy-account, and see what happens... >> >> >> >> Terry >> >> >> >> >> ------------------------------ >> >> *From:* Action Request System discussion list(ARSList) [mailto: >> arslist@ARSLIST.ORG] *On Behalf Of *Brian Goralczyk >> *Sent:* October-27-14 4: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 >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> ------------------------------ >> >> No virus found in this message. >> Checked by AVG - www.avg.com >> Version: 2014.0.4765 / Virus Database: 4040/8433 - Release Date: 10/22/14 >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
