In alert log i found below error.
Error:
ORA-00604: error occurred at recursive SQL level 1
ORA-12663: Services required by client not available on the server
ORA-36961: Oracle OLAP is not available.
ORA-06512: at "SYS.OLAPIHISTORYRETENTION", line 1
ORA-06512: at line 15
Problem: This error occurs due to some trigger.We can see trigger name here in error.Here trigger name is OLAPIHISTORYRETENTION.
Resolution : First we need schema name of that trigger.For that try below query through sys/system user.
SQL> select OWNER,TRIGGER_NAME from DBA_TRIGGERS where TRIGGERING_EVENT like '%STARTUP%';
Or
SQL> select OWNER,TRIGGER_NAME from DBA_TRIGGERS where TRIGGER_NAME like 'OLAPIHISTORYRETENTION';
In my case Result is like that:
SYS,'AURORA$SERVER$STARTUP'’
Error:
ORA-00604: error occurred at recursive SQL level 1
ORA-12663: Services required by client not available on the server
ORA-36961: Oracle OLAP is not available.
ORA-06512: at "SYS.OLAPIHISTORYRETENTION", line 1
ORA-06512: at line 15
Resolution : First we need schema name of that trigger.For that try below query through sys/system user.
SQL> select OWNER,TRIGGER_NAME from DBA_TRIGGERS where TRIGGERING_EVENT like '%STARTUP%';
Or
SQL> select OWNER,TRIGGER_NAME from DBA_TRIGGERS where TRIGGER_NAME like 'OLAPIHISTORYRETENTION';
In my case Result is like that:
SYS,'AURORA$SERVER$STARTUP'’
SYS,‘OLAPISTARTUPTRIGGER’
Now we need to disable it.
SQL> alter trigger OLAPISTARTUPTRIGGER disable;
