oracle数据库ORA-06553: PLS-801: internal error [56327]

今天收到一个客户的问题，数据库中的alertlog中报错ORA-06553: PLS-801: internal error [56327]，

Errors in file /mydb/db/oradata01/dbsepus/diag/rdbms/dbsepus/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/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/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]

测试export用户或者表，甚至查询dba_segments都会报错ORA-06553: PLS-801: internal error [56327]

这个报错是因为Oracle的软件版本和之前restore进去的数据库版本不一致导致。如下即可修复：

SQL> startup upgrade;
SQL> @?/rdbms/admin/utlirp
SQL> shutdown immediate
SQL> startup
SQL> @?/rdbms/admin/utlrp