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

2002-10-11 Thread 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 AMTo: 
  '[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


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

2002-10-11 Thread Johnson, Michael
Title: RE: Win2000/8.1.7.3.0/SQL





  
  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