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>
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:
Post a Comment