OCP Blog
Super DBA
ORA-06544: PL/SQL: internal error, arguments: [56327], [], [], [], [], [], [], [] ORA-06553: PLS-801: internal error [56327]
by Vazha Mantua Friday, October 4, 2013 1:24 PM

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;

Tags: , , , , , ,

ORA-06544: PL/SQL: internal error, arguments: [55916]
by Vazha Mantua Saturday, December 17, 2011 12:10 PM

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.

Tags: , ,

Filter by APML

Calendar

<<  October 2017  >>
MoTuWeThFrSaSu
2526272829301
2345678
9101112131415
16171819202122
23242526272829
303112345

View posts in large calendar

TextBox