Tuesday 28 January 2014

ORA-06544: PL/SQL: internal error, arguments: [56327], [], [], [], [], [], [], []

You relocated a database to another server and receive the following errors in the alert log:

Errors in file d:\oracle\product\10.2.0\admin\maxnips1\bdump\maxnips1_cjq0_5812.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-06544: PL/SQL: internal error, arguments: [56319], [], [], [], [], [], [], []
ORA-06553: PLS-801: internal error [56319]


Cause:-

The database on the new location was built using datafiles from a different word-size database. For example, you used the datafiles from a 64-bit database for your new 32-bit database OR you used the datafiles from a 32-bit database for your new 64-bit database. Either of these scenarios results in PL/SQL objects that are inconsistent with the Oracle executable.

Solution:-


SQL> shutdown immediate; 
SQL> startup upgrade; 
SQL> @$ORACLE_HOME/rdbms/admin/utlirp; 
SQL> shutdown immediate; 
SQL> startup; 
SQL> @@$ORACLE_HOME/rdbms/admin/utlrp;

No comments:

Post a Comment