oracle宕了,ORACLE自动宕机一次经历

OS:redhat 5 64 bit

ORACLE:10.2.0.4

現象：一般一天宕机一次，５０個用戶同時操作，有兩三個用戶始終無法連接到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自动宕机