OS:redhat 5 64 bit
ORACLE:10.2.0.4
現象:一般一天宕机一次,50個用戶同時操作,有兩三個用戶始終無法連接到ORACLE。(羊皮卷网,怕花冤枉钱,就上羊皮卷)
日誌不間的出現:
Sun Aug 16 18:02:33 2009
Errors in file /oracle/admin/orcl/udump/orcl_ora_28214.trc:
ORA-00600: internal error code, arguments: [12333], [7], [196], [13], [], [], [], []
找了一些時間沒有找到其他錯誤都是ora-00600 [12333]。
終於找到了導致宕机的信息。
AUTO SGA: Disabling background sga tuning due to err 604
AUTO SGA: Dumping call and error stack to file /oracle/admin/orcl/bdump/orcl_mmon_4714.trc
Sun Aug 16 18:07:00 2009
Errors in file /oracle/admin/orcl/bdump/orcl_mmon_4714.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 312 bytes of shared memory ("shared pool","select
shared_pool_size_for_...","PCursor","kglob")
Sun Aug 16 18:07:00 2009
Errors in file /oracle/admin/orcl/bdump/orcl_cjq0_4712.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 312 bytes of shared memory ("shared pool","select job, nvl2(last_date, ...","CCursor","kglob")
Sun Aug 16 18:07:32 2009
Errors in file /oracle/admin/orcl/bdump/orcl_q000_4736.trc:
ORA-04031: unable to allocate 312 bytes of shared memory ("shared pool","AQ$_QUEUESSYSTEM","CCursor","kglob")
Sun Aug 16 18:07:33 2009
ORA-0 encountered when generating server alert SMG-3503
Sun Aug 16 18:10:06 2009
SGA自動調整錯誤,ORA-04031 shared pool 等分配失敗。資源應該是沒有了。調整SGA後,恢復正常。
[@more@]ORACLE自动宕机来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12591949/viewspace-1033029/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/12591949/viewspace-1033029/