本文解决在Oracle数据库12.1.0.2版本升级或应用PSU后出现的OLAP相关触发器无效问题。文中详细介绍了触发器及包体无效的症状，并提供了删除无效对象的解决方案。
Invalid OLAP Triggers after Upgrade to 12.1.0.2 and/or Application of PSU on 12.1.0.2 (Doc ID 2056217.1)
Symptoms
After upgrading to 12.1.0.2 or applying a PSU on 12.1.0.2 you get the following errors when you start/stop the database:
ORA-04098: trigger 'SYS.OLAPISTARTUPTRIGGER' is invalid and failed re-validation
ORA-04098: trigger 'SYS.OLAPISHUTDOWNTRIGGER' is invalid and failed re-validation
The following objects are invalid:
OBJECT OBJECT_TYPE STATUS
SYS.OLAPISTARTUPTRIGGER TRIGGER INVALID
SYS.OLAPISHUTDOWNTRIGGER TRIGGER INVALID
SYS.DBMS_XSOQ PACKAGE BODY INVALID
SYS.DBMS_XSOQ_UTIL PACKAGE BODY INVALID
Changes
Upgrade to 12.1.0.2 or application of a PSU on 12.1.0.2.
Cause
These four objects reference Olapi_History, which no longer exists.
Solution
Drop these objects:
SYS.OLAPISTARTUPTRIGGER
SYS.OLAPISHUTDOWNTRIGGER
SYS.DBMS_XSOQ
SYS.DBMS_XSOQ
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
