Good Day,

Today I restored database from 32-bit Linux machine to 64-bit. after opening database , there were a lot of errors like that:

ORA-06544: PL/SQL: internal error, arguments: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: internal error [56327].

Solution of this problem is recompiles existing PL/SQL modules in the format required by the new database.

Step by step:

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

Good Day All,

Today we will discuss about error which appeared during import some data to oracle database release 11gR2 via impdp utility

when session try compile package we have got message like this

ORA-39083: Object type PACKAGE_BODY failed to create with error:
ORA-04052: error occurred when looking up remote object test_procedure@TESTDB.WORLD
ORA-00604: error occurred at recursive SQL level 3
ORA-06544: PL/SQL: internal error, arguments: [55916], [], [], [], [], [], [], []
ORA-06553: PLS-801: internal error [55916]
ORA-02063: preceding 2 lines from TESTDB.WORLD

As you see error appear when oracle 11gR2 compile package which contain remote object dependence

Database version where is located test_procedure is 10.2.0.1, after upgrading it to 10.2.0.2 problem resolved. I think it’s a bug of version 11.2.0.1.