今天收到一个客户的问题，数据库中的alertlog中报错ORA-06553: PLS-801: internal error [56327]，
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
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进去的数据库版本不一致导致。如下即可修复：
|
1 2 3 4 5 |
SQL> startup upgrade; SQL> @?/rdbms/admin/utlirp SQL> shutdown immediate SQL> startup SQL> @?/rdbms/admin/utlrp |