天天看點

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

剛剛安裝了oracle 10g r2後,啟動資料庫時發現告警日志有如下錯誤:

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

[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

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

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