ORA-08103

问题

环境：RAC3节点 12.1.0.2 备库

实例3查询分区表报错。

oerr ora 08103
08103, 00000, "object no longer exists"
// *Cause: The object has been deleted by another user since the operation
// began, or a prior incomplete recovery restored the database to
// a point in time during the deletion of the object.
// *Action: Delete the object if this is the result of an incomplete
// recovery.

ORA-08103: Object No Longer Exists (Doc ID 1465978.1)

解决过程

询问是否有变更操作：有。
alter table x drop partiton p_x;

查看预警日志

oerr ora 01013
01013, 00000, "user requested cancel of current operation"
// *Cause:
// *Action:

查看相应trc文件中，有ORA-8103
ORA-8103故障处理

Bug 19689979 - ORA-8103 or ORA-600 [ktecgsc:kcbz_objdchk] or Wrong Results on PARTITION table after TRUNCATE in 11.2.0.4 or above (Doc ID 19689979.8)

解决方案

alter system flush shared_pool;

SQL会硬解析。

慎用