ERROR : when sqlplus apps/apps

Problem :


ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-06553: PLS-801: internal error [56319]

assumtion :

when i clone apps 11g in Linux 32 bit but i forget to clone oracle_home, so i install oracle 10.2.0.1 and upgrade to 10.2.0.4.

when i already patch from 10.2.0.1 to 10.2.0.4
and i recreate controlfile


and i test connect using apps :

$ sqlplus apps/apps
 and result is

ERROR:

ORA-00604: error occurred at recursive SQL level 1

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

this how to solve :

$ sqlplus "/as sysdba"

SQL > startup upgrade pfile=<your path init.ora>

SQL > <your ORACLE_HOME>/rdbms/admin/utlirp.sql

SQL > shutdown

SQL > startup pfile=<your path init.ora>

SQL > <your ORACLE_HOME>/rdbms/admin/utlrp.sql

*if running utlrp.sql take a few minute depend invalid your object

Query returning the number of invalid objects remaining. This
number should decrease with time.
SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6);

and now you can connect using apps schema

thank's,

Mahardika Dwi Hananto

Read more »