| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> ORA-03113 during @utlrp
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 -- http://www.freelists.org/webpage/oracle-lReceived on Fri Aug 03 2007 - 08:54:08 CDT
 |
 |