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

<<  December 2017  >>
MoTuWeThFrSaSu
27282930123
45678910
11121314151617
18192021222324
25262728293031
1234567

View posts in large calendar

TextBox