ORA-03113 during @utlrp
- From: "Don Seiler" <don@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 3 Aug 2007 08:54:08 -0500
As part of the 32-bit-to-64-bit restore/recovery process, I'm running
utlirp.sql and utlrp.sql. However, the last few times I've done this
operation, the running of utlrp.sql will fail out with an ORA-03113:
end-of-file on communication channel. Sometimes I'll keep trying to
fit the square peg in the round hole and just re-run the utlrp or both
the ultirp and utlrp. Usually it would finally finish successfully
after 2-4 tries.
The alert log will have a number of messages like this:
Fri Aug 3 08:50:09 2007
Errors in file /u00/app/oracle/admin/dev2/bdump/dev2_j001_2045.trc:
ORA-00600: internal error code, arguments: [xschkmk:!dict], [], [],
[], [], [], [], []
That trace file will have a lot of stuff, obviously, here's the query part:
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [xschkmk:!dict], [], [], [], [], [],
[], []
Current SQL statement for this session:
declare
rc sys_refcursor;
begin
:1 := "SYS"."OLAPIMPL_T"."ODCITABLEDESCRIBE"(:2 ,'SYS.AWMD duration query',
'olapsys.ALL_OLAP2_AW_METADATA_T','ACTIVE_CATALOG ''ALL_DIMENSIONS'' ''MRAC_QUER
Y'' ''NO''','MEASURE AWOWNER FROM SYS.AWMD!OWNER
MEASURE AWNAME FROM SYS.AWMD!AWNAME
MEASURE AWOBJECT FROM SYS.AWMD!DIMENSION_NAME
MEASURE COL1 FROM SYS.AWMD!SOURCE_OWNER
MEASURE COL2 FROM SYS.AWMD!SOURCE_NAME
MEASURE COL3 from SYS.AWMD!AW_PHYSICAL_OBJECT
DIMENSION AWMDKEY FROM SYS.AWMD!AWMDKEY');
end;
The queries are different from trace file to trace file, but they all
seem to relate to OLAP stuffs, which we don't actually use.
--
Don Seiler
oracle: http://ora.seiler.us
ultimate: http://www.mufc.us
--
//www.freelists.org/webpage/oracle-l
Other related posts:
