ORACLE OLAP錯誤ORA-06512: at "SYS.OLAPIHISTORYRETENTION"

剛剛安裝了ORACLE 10g R2後，啟動資料庫時發現告警日志有如下錯誤：

<a href="http://images.cnitblog.com/blog/73542/201504/242312064061945.png"></a>

[oracle@getlnx01 bdump]$ more /u01/app/oracle/admin/epps/udump/epps_ora_24778.trc

/u01/app/oracle/admin/epps/udump/epps_ora_24778.trc

Oracle Database 10g Release 10.2.0.1.0 - 64bit Production

ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1

System name:    Linux

Node name:      getlnx01.esquel.com

Release:        2.6.32-200.13.1.el5uek

Version:        #1 SMP Wed Jul 27 21:02:33 EDT 2011

Machine:        x86_64

Instance name: epps

Redo thread mounted by this instance: 1

Oracle process number: 14

Unix process pid: 24778, image: [email protected] (TNS V1-V3)

*** SERVICE NAME:(SYS$USERS) 2015-04-24 13:48:03.863

*** SESSION ID:(160.3) 2015-04-24 13:48:03.863

Error in executing triggers on database startup

*** 2015-04-24 13:48:03.863

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

ORA-06512: at line 15

<a href="http://images.cnitblog.com/blog/73542/201504/242312099844085.png"></a>

禁用了這兩個觸發器後，重新啟動資料庫檢查發現這個錯誤消失了。問題解決。

參考資料：

<a href="http://www.eygle.com/archives/2007/08/10gr2_olap_trigger.html" target="_blank">http://www.eygle.com/archives/2007/08/10gr2_olap_trigger.html</a>