【故障处理】ORA-31600和ORA-04063错误

【故障处理】ORA-31600和ORA-04063错误

有朋友在执行drop操作时，报了如下的错误，经过查询mos文档和远程协助最后终于处理了，记录下。

ORA-00604: error occurred at recursive SQL level 1

ORA-31600: invalid input value COMPATIBLE for parameter VERSION in function GET_DDL

ORA-06512: at "SYS.DBMS_METADATA", line 5805

ORA-06512: at "SYS.DBMS_METADATA", line 8344

ORA-06512: at line 1

ORA-06512: at line 10

ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 2

ORA-04063: package body "SYS.DBMS_METADATA" has errors

ORA-06512: at line 10

解决办法：

SQL> shutdown immediate

SQL> spool /tmp/spool.txt

SQL> startup upgrade

SQL>@?/rdbms/admin/catupgrd.sql

SQL> shutdown immediate

SQL> spool off

--检查日志有没有特殊的报错

SQL> Startup

SQL>@?/rdbms/admin/utlrp.sql

参考：ORA-31600 While Running DBMS_METADATA.GET_DDL (文档 ID 1567572.1)

注意：本文内容太多，公众号有字数限制，全文可点击文末的阅读原文，谢谢大家的理解。Oracle培训和认证记得找小麦苗哟。