10.2.0.4的静默安装使用起来倒是比较简单,安装一切顺利,搭建standby后,发现有些错误。安装的时候没有选择安装olap,结果在standby open read only的时候,报出了下面的错误:
Errors in file /opt/oracle/admin/itildb/udump/itildb_ora_19678.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 11
Completed: alter database open read only
后来多方查找,发现是有两个trigger,
sys@DB>select trigger_name from dba_triggers where trigger_name like '%OLAP%';
TRIGGER_NAME
------------------------------
OLAPISHUTDOWNTRIGGER
OLAPISTARTUPTRIGGER
sys@DB>
把这两个trigger disable掉后,standby 就没有再出现这样的问题。当然前提是你没有安装olap,也许是静默安装的时候一点点问题。
把standby 从恢复模式切换到open read only几次之后,又出现下面的问题,metalink上查了一下,是个bug,不过在这个版本也可以通过其他方式解决,restart instance或者是disable 掉addm也就是数据库自动诊断监视程序(Automatic Database Diagnostic Monitor,ADDM)
ksvcreate: Process(m000) creation failed
Thu Jul 16 22:08:33 2009
ksvcreate: Process(m000) creation failed
Thu Jul 16 22:09:33 2009
ksvcreate: Process(m000) creation failed
Thu Jul 16 22:10:33 2009
在主库sys用户下执行:
sys@DB>execute dbms_scheduler. disable ('GATHER_STATS_JOB');
PL/SQL procedure successfully completed.
sys@DB>commit;
Commit complete.
sys@DB>alter system switch logfile;
System altered.
sys@DB>/
System altered.
然后在将主备的
alter system set statistics_level=basic scope =both;
这样这个问题就解决,不过这样是会屏蔽到10g的一些新特性,干脆上11g,用起来还比较稳定。
[@more@]来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7312700/viewspace-1024208/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7312700/viewspace-1024208/