Tuesday 28 January 2014

ORA-06553: PLS-801: internal error [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;

2 comments:

  1. Thank you.
    I had this problem and the steps worked perfectly.
    Thanks, again

    ReplyDelete
  2. Almost 10 years later your post save too. Just migrate a Oracle 11.2 DB from windows 32 to 64 bits. Thank you.

    ReplyDelete