This is the same error that I get when using database links to connect to a remote database. The error only comes up when the remote database has been shutdown. Because of the way that oracle handles database links the calling database does not know that the remote link was taken down. So the Remedy thread that called the remote database will get this error the first time that it tries to connect after the remote was down. Unfortunately all of the Remedy threads have to get this error and reconnect one thread at a time. So this error can pop up long after the remote was brought back up if there are long periods of time between calls to it.
Scott Lodge Remedy System Administrator / Developer MadisonRiver Communications 919-563-8377 [EMAIL PROTECTED] 'A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila.' -Mitch Ratcliffe, "Technology Review" (1992) -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Linda Blomberg Sent: Tuesday, October 03, 2006 9:25 AM To: [email protected] Subject: Re: ORACLE Error (UNCLASSIFIED) We have seen this error intermittently on our development server and were told the oracle database ran out of processes. Linda Blomberg Fermi National Accelerator Laboratory [EMAIL PROTECTED] -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank, Gordon M Mr NISO/Lockheed Martin Sent: Tuesday, October 03, 2006 7:07 AM To: [email protected] Subject: ORACLE Error (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: NONE Hello all, Does anyone know what causes this error? ARERR [552] Failure during SQL operation to the database : ORA-02068: following severe error from DTS3.WORLD ORA-03113: end-of-file on communication channel It happens while searching VIEW form. It is intermittent. Thanks up front Gordon Frank Classification: UNCLASSIFIED Caveats: NONE ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
