Tuesday, April 29, 2008

ORA-06512: on 9i SE

Hi,


When an Oracle 10G Standard Edition database has been installed, I have got the following error in the alert log file of this database:

ORA-00604: error occurred at recursive SQL level 1
ORA-06521: PL/SQL: Error mapping function
ORA-06512: at "SYS.OLAPIHISTORYRETENTION", line 1
ORA-06512: at line 13

I have found that for fixing that error we need to shut down the Oracle OLAP functionality using the following commands.

ALTER TRIGGER SYS.OLAPISTARTUPTRIGGER DISABLE;
ALTER TRIGGER SYS.OLAPISHUTDOWNTRIGGER DISABLE;


Thanks,
Sergey.


No comments: