[oracle-l] Re: ORA-03113 Error On One Server Not the Other

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Mon, 26 Jan 2004 15:18:54 -0600
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607AFFDED@EXCHMN3>

Ethan - If you haven't had the wonderful experience of tracking down an ORA-03113 error before, you have a great treat in store. Basically ORA-03113 is a "catch-all" error, very non-specific.

   Take note of Jacques suggestion.
   On Metalink see note 1020463.6 for background in diagnosing the 3113. Good luck.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
From: Post, Ethan [mailto:Ethan.Post_at_ps.net] Sent: Monday, January 26, 2004 3:02 PM
To: oracle-l_at_freelists.org
Subject: [oracle-l] ORA-03113 Error On One Server Not the Other

Both servers are Oracle 8.1.7.4 EE 64 bit on AIX 4.3.x, should be same patch and maintenance level. Anyone seen this type of behavior before? I connected to each database directly on the server using SQL*Plus.

SERVER1>/
select g1tax, count(*) from crpdta.f045143 where g1an8 in ('V','R','D') group by g1tax having count(*) > 1

                                                           *

ERROR at line 1:
ORA-01722: invalid number

SERVER2> select g1tax, count(*) from proddta.f045143 where g1an8 in ('V','R','D') group by g1tax having count(*) > 1; select g1tax, count(*) from proddta.f045143 where g1an8 in ('V','R','D') group by g1tax having count(*) > 1
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel Received on Mon Jan 26 2004 - 15:18:54 CST