An error ORA-06553: PLS-801: internal error [56327] in alertlog in the database was received today
Errors in file/mydb/db/oradata01/dbsepus/diag/rdbms/dbsepus/trace/dbsepus_cjq0_11056.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-06544: PL/SQL: internal error, arguments: [56327], [], [], [], [], [], [], [], []
ORA-06553: PLS-801: internal error [56327]
Mon Nov 17 14:11:04 2014
Errors in file/mydb/db/oradata01/dbsepus/diag/rdbms/dbsepus/trace/dbsepus_cjq0_11056.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-06544: PL/SQL: internal error, arguments: [56327], [], [], [], [], [], [], [], []
ORA-06553: PLS-801: internal error [56327]
Errors in file/mydb/db/oradata01/dbsepus/diag/rdbms/dbsepus/trace/dbsepus_cjq0_11056.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-06544: PL/SQL: internal error, arguments: [56327], [], [], [], [], [], [], [], []
ORA-06553: PLS-801: internal error [56327]
The ORA-06553: PLS-801: internal error [56327] is reported when you test the export user or table or even query dba_segments
This error is reported because the Oracle software version is inconsistent with the database version in the previous restore. You can fix the problem as follows:
SQL> startup upgrade;
SQL> @? /Rdbms/admin/utlirp
SQL> shutdown immediate
SQL> startup
SQL> @? /Rdbms/admin/utlrp