ORA-31114: XDB configuration has been deleted or is corrupted ORACLE 报错 故障修复 远程处理

文档解释

ORA-31114: XDB configuration has been deleted or is corrupted

Cause: The XDB configuration resource has been deleted or corrupted.

Action: Reinstall XDB, or reinsert a valid configuration document.

ORA-31114 错误是一个XDB错误。官方解释如下:

ORA-31114: XDB configuration has been deleted or is corrupted

Cause: The XDB configuration has been removed from the database or is corrupted.

Action: Re-create the XDB configuration.

常见案例

除非数据库在被捣毁时,ORA-31114通常是另一个错误所引起,并且这些错误有时可能是由于一次出错的DBA操作导致的。

一般处理方法及步骤

1)检查实例跟踪文件,比如alert_SID.log,以查看是什么错误引起了ORA-31114;

2)如果没有任何可获得的有效信息,则可能需要重新创建XDB配置。

要重新创建XDB配置,您需要运行以下SQL脚本:

@$ORACLE_HOME/rdbms/admin/catalog.sql

@$ORACLE_HOME/rdbms/admin/catproc.sql

@$ORACLE_HOME/xdbs/initXDB.sql

上面的SQL脚本通常仅要几秒钟时间就可以运行完毕。 ——————— 作者:Andy_Cui 来源:CSDN 原文:https://blog.csdn.net/micky042/article/details/104446818 版权声明:本文为博主原创文章,转载请附上博文链接!


数据运维技术 » ORA-31114: XDB configuration has been deleted or is corrupted ORACLE 报错 故障修复 远程处理