ORA-06553: PLS-801: internal error [56319]


When i have finish update oracle 32-bit to 64-bit, then i try to compile procs and I got this message,

Error accessing package DBMS_APPLICATION_INFO
ERROR:
ORA-06553: PLS-801: internal error [56319]

—————————————————

ORA-00604: error occurred at recursive SQL level 2
ORA-06544: PL/SQL: internal error, arguments: [56319],[], [], [], [], [], [],[]
ORA-06553: PLS-801: internal error [56319]

i have tried steps to fix this problem
– run STANDARD.SQL to reinstall DBMS_APPLICATON_INFO
– run the DBMSUTL.SQL to create DBMS_APPLICATON_INFO
– run CATALOG.SQL,CATPPROC.SQL AND UTLPR.SQL
(sql file usually located in ORACLE_HOME/rdbms/admin)

but while running those script i got the same error.

the other steps i found on http://seilerwerks.wordpress.com/2007/03/06/fixing-a-32-to-64-bit-migration-with-utlirpsql/,

SQL> shutdown immediate;
SQL> startup upgrade;
SQL> @utlirp;

SQL> shutdown immediate;
SQL> startup;
SQL> @utlrp;

but it’s not VOILA! and errors still there laughing at me, >.<

I have search through internet and ended with answer from forum
that utlirp.sql to convert from 32 bit to 64 bit should be run when database is in migration mode.
This error is due to the 32 bit datafiles being running on a 64 bit version of oracle.

If anyone have other solution, please leave message for me. >.<

One Response

  1. we are creating 64-bit oracle9i primary database & creating physical standby on 32-bit oracle9i database, While exporting on standby database error following error occurs,
    Exp – 0008 Oracle Error 6544 encountered
    ora – 06544: PL/SQL internal error; argument [56319]
    ora – 06553 PLS-801 internal error.
    Pl. Help me

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: