ORA-03113 And ORA-03114 While Running Utlrp.sql

APPLIES TO:

Oracle Database - Enterprise Edition - Version 10.1.0.4 and later
Information in this document applies to any platform.

SYMPTOMS

Receiving ORA-03113 while running utlrp.sql to validate invalid objects.

SQL> @utlrp 

DECLARE 
* 
ERROR at line 1: 
ORA-03113: end-of-file on communication channel 

ERROR: 
ORA-03114: not connected to ORACLE

 

In the alert.log ORA-07445 is reported.

ORA-07445: exception encountered: core dump [__GI_memcpy()+162] [SIGSEGV] [Address not mapped to object] [0x2B98F408D7] [] []

CHANGES

Database was changed from 32-bit word size to 64-bit word Size.

NOTE:
A word size change requires to run the utlirp.sql script as a necessary step for making sure to recompile compiled PL/SQL code to the new word size.

 

CAUSE

Bug 6619899 was raised for the issue but the bug was closed as "not a bug" with below reason. 

Running the olap.sql prior to running the utlirp.sql resolved the problem of receiving the ORA-7445 error when running utlrp.sql.
When migrating from 32 bit to 64 bit all aw's need to be exported/imported or re-created.
The olap.sql script recreates the system aw's.

SOLUTION

Running olap.sql before running utlirp.sql will resolve the issue.

sqlplus /as sysdba 
SQL> @?/olap/admin/olap.sql SYSAUX TEMP;