[盖国强]Oracle10gR2的ORA-06512 OLAP错误

LOGSTDBY: Validating controlfile with logical metadata

LOGSTDBY: Validation complete

Errors in file /data2/ora10g/admin/eygle/udump/eygle_ora_1372.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

Completed: ALTER DATABASE OPEN

在对应的跟踪文件中，输出的信息如下：

Error in executing triggers on database startup

*** 2007-08-09 11:22:15.869

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

提示显示，在数据库启动过程中，执行了一个和OLAP有关的Trigger，出现了错误。

检查数据库，得到以下两个相关Trigger：

SQL> select trigger_name,status from dba_triggers where trigger_name like '%OLAP%';

TRIGGER_NAME STATUS

OLAPISTARTUPTRIGGER ENABLED

OLAPISHUTDOWNTRIGGER ENABLED

可以通过禁用这两个Trigger，防止OLAP在数据库启动和关闭时的检验，即可屏蔽这个错误信息。

Metalink上有几个Bug和这个错误相关，Bug号4630695是其中之一，这个Bug在11g中被修正。

查看本文来源