29 March 2012

ORA-06553: PLS-801: internal error

I am Doing EBS database 10.2.0.4 32bit to 10.2.0.4 64bit Migration Work That time i faced below Issue .

Error:-   In alert log entry
Errors in file /oracle/MUT/mutdb/10.2.0/admin/MUT_test/bdump/mut_mmon_3862.trc:
ORA-06553: PLS-801: internal error [56319]
Wed Mar 28 18:52:19 2012
Errors in file /oracle/MUT/mutdb/10.2.0/admin/MUT_test/udump/mut_ora_4058.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-06553: PLS-801: internal error [56319]
Wed Mar 28 18:52:25 2012
SQL> startup upgrade
ORACLE instance started.

Total System Global Area 1145044992 bytes
Fixed Size                  2089888 bytes
Variable Size             964693088 bytes
Database Buffers          163577856 bytes
Redo Buffers               14684160 bytes
Database mounted.
Database opened.
SQL>
Solution :-
We need to run utlirp.sql because i received lot of invalid objects.

SQL>@$ORACLE_HOME/rdbms/admin/utlirp.sql
System altered.

SQL>
SQL> Rem Continue even if there are SQL errors
SQL> WHENEVER SQLERROR CONTINUE;
SQL>
SQL> Rem ===========================================================================
SQL> Rem END utlip.sql
SQL> Rem ===========================================================================
SQL>
SQL> DOC
DOC>#######################################################################
DOC>#######################################################################
DOC>   utlirp.sql completed successfully. All PL/SQL objects in the
DOC>   database have been invalidated.
DOC>
DOC>   Shut down and restart the database in normal mode and run utlrp.sql to
DOC>   recompile invalid objects.
DOC>#######################################################################
DOC>#######################################################################
DOC>#
SQL> shut   
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1145044992 bytes
Fixed Size                  2089888 bytes
Variable Size             964693088 bytes
Database Buffers          163577856 bytes
Redo Buffers               14684160 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@test admin]$ sqlplus system/manager@MUT

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Mar 28 19:22:05 2012

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

No comments: