10gR2启动时报错处理

Errors in file /opt/oracle/admin/dbtest/udump/dbtest_ora_14166.trc:
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
Wed Oct 25 12:34:50 2006
Completed: ALTER DATABASE OPEN

这种错误比较莫名其妙，查该跟踪文件可知
more /opt/oracle/admin/dbtest/udump/dbtest_ora_14166.trc
Error in executing triggers on database startup
*** 2006-10-25 12:34:50.289
ksedmp: internal or fatal 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
也就是说在实例启动时执行了一个触发器
SQL>select trigger_name,status from user_triggers where status='ENABLED';
TRIGGER_NAME STATUS
------------------------------ --------
AW_DROP_TRG ENABLED
OLAPISTARTUPTRIGGER ENABLED
OLAPISHUTDOWNTRIGGER ENABLED
LOG_TRIGGER ENABLED
禁止OLAPISTARTUPTRIGGER与OLAPISHUTDOWNTRIGGER触发器即可.