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 [email protected] On Mon, Oct 27, 2014 at 10:54 PM, William Rentfrow < [email protected]> wrote: > ** > > Agreed - I've seen similar things happen when we didn't have enough > connections configured. > > > > William Rentfrow > > [email protected] > > Office: 715-204-3061 or 701-232-5697x25 > > Cell: 715-498-5056 > > > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Terry Bootsma > *Sent:* Monday, October 27, 2014 5:41 PM > *To:* [email protected] > *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: > [email protected]] *On Behalf Of *Brian Goralczyk > *Sent:* October-27-14 4:24 PM > *To:* [email protected] > *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 [email protected] > > _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_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
