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