Oracle-L: RE: Help on ORA-03113 error and 7445 in the trace file.

From: Johnson, Michael <Michael.Johnson_at_oln-afmc.af.mil>
Date: Fri, 11 Oct 2002 12:58:47 -0800
Message-ID: <F001.004E749E.20021011125847@fatcity.com>

Update ... we dont see this problem if we rlogin to the server via a Sun Solaris client box.

-----Original Message-----
Sent: Friday, October 11, 2002 10:38 AM
To: 'ORACLE-L_at_fatcity.com'

We are getting a intermittent problem that happens

both from a SQL prompt or if we execute off of a

package. We can telnet in or go through the TNS

side of things. It doesnt seem to matter.

Sun Solaris 2.8

Oracle 8.1.7.4

Here is the scenario .......

SQL> Create user blah identified by blah

default ts blah temporary ts blah;

SQL> Drop user blah;

ORA-03113 end of file blah blah blah

The server thread process is disconnected and we have to reconnect.

ORA-07445 shows up in the trace file.

After reconnecting we do indeed see that the BLAH user was dropped

before we disconnected.

Note that all DML seems to work on this connection , only DDL

type stuff causes a problem.

The only thing we can figure is some type of network

issue, but what ??

Thanks for your time in advance.

Mike

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Johnson, Michael
INET: Michael.Johnson_at_oln-afmc.af.mil

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Oct 11 2002 - 15:58:47 CDT