Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id g9BMjfn01966 for ; Fri, 11 Oct 2002 17:45:41 -0500 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id g9BMjeD01961 for ; Fri, 11 Oct 2002 17:45:40 -0500 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id NAA83990; Fri, 11 Oct 2002 13:27:27 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 004E749E; Fri, 11 Oct 2002 12:58:47 -0800 Message-ID: Date: Fri, 11 Oct 2002 12:58:47 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Johnson, Michael " Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Johnson, Michael " Subject: RE: Help on ORA-03113 error and 7445 in the trace file. Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C2715E.F117AB80" ------_=_NextPart_001_01C2715E.F117AB80 Content-Type: text/plain; charset="iso-8859-1" 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@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 ------_=_NextPart_001_01C2715E.F117AB80 Content-Type: text/html; charset="iso-8859-1" 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: 'ORACLE-L@fatcity.com'
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

------_=_NextPart_001_01C2715E.F117AB80-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: Michael.Johnson@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@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).