ORA-04098: trigger 'SYS.OLAPISHUTDOWNTRIGGER' is invalid and failed re-validation



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