ORA-00604，ORA-12663，ORA-36961，ORA-06512

libydwei2007

原文地址：http://hi.baidu.com/jadesuper6/blog/item/c93d79b1b529ecc236d3cabf.html

oracle10g启动和关闭的时候alert文件都有如下错误提示：

Errors in file /u01/app/oracle/admin/prod/udump/prod_ora_3936.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
Fri Apr 30 20:06:03 2010
Completed: ALTER DATABASE OPEN

查看trace文件：
[oracle@redhat ~]$ cat /u01/app/oracle/admin/prod/udump/prod_ora_3936.trc

/u01/app/oracle/admin/prod/udump/prod_ora_3936.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning and Data Mining options
ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1
System name:    Linux
Node name:      redhat
Release:        2.6.9-22.EL
Version:        #1 Mon Sep 19 18:20:28 EDT 2005
Machine:        i686
Instance name: prod
Redo thread mounted by this instance: 1
Oracle process number: 15
Unix process pid: 3936, image: oracle@redhat (TNS V1-V3)
*** SERVICE NAME:(SYS$USERS) 2010-04-30 20:06:02.326
*** SESSION ID:(159.3) 2010-04-30 20:06:02.326
Error in executing triggers on database startup
*** 2010-04-30 20:06:02.327
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
*** 2010-04-30 20:16:06.254
*** 2010-04-30 20:16:06.254 60679 kcrr.c
ARCH: Archival disabled due to shutdown: 1089
*** 2010-04-30 20:16:07.277 60679 kcrr.c
ARCH: Archival disabled due to shutdown: 1089

盖老师：可以通过禁用这两个Trigger，防止OLAP在数据库启动和关闭时的检验，即可屏蔽这个错误信息。 Metalink上有几个Bug和这个错误相关，Bug号4630695是其中之一，这个Bug在11g中被修正。
SQL> select trigger_name,status from dba_triggers where trigger_name like '%OLAP%';

TRIGGER_NAME                   STATUS
------------------------------ --------
OLAPISHUTDOWNTRIGGER           ENABLED
OLAPISTARTUPTRIGGER            ENABLED

SQL> alter trigger OLAPISHUTDOWNTRIGGER disable;

Trigger altered.

SQL> alter trigger OLAPISTARTUPTRIGGER disable;

Trigger altered.

SQL>shutdown immediate

SQL>startup

OK.