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

[Johnson, Michael]

Title: RE: Win2000/8.1.7.3.0/SQL

Update ... we dont see this problem if we rlogin to

the server via a Sun Solaris client box.

-----Original Message-----
From: Johnson, Michael
Sent: Friday, October 11, 2002 10:38 AM
To: '[EMAIL PROTECTED]'
Subject: Help on ORA-03113 error and 7445 in the trace file.

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