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...

Read more »