Re: ORA-03113 Error On One Server Not the Other 2004-01-26 - By DENNIS WILLIAMS
Ethan - If you haven 't had the wonderful experience of tracking down an
ORA-03113 (See ORA-03113.ora-code.com) error before, you have a great treat in store. Basically ORA-03113 (See ORA-03113.ora-code.com)
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@(protected)
-- --Original Message-- --
From: Post, Ethan [mailto:Ethan.Post@(protected)]
Sent: Monday, January 26, 2004 3:02 PM
To: oracle-l@(protected)
Subject: [oracle-l] ORA-03113 (See ORA-03113.ora-code.com) 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 (See ORA-01722.ora-code.com): 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 (See ORA-03113.ora-code.com): end-of-file on communication channel
|
|
