Oracle数据库数据恢复、性能优化»论坛 › Oracle › Oracle数据库管理 › SR 3-6537524051 : oracle 11.2.0.1 rac reboot often a ...

40 积分	0 好友	14 主题

发消息

[常规总体性能调优] SR 3-6537524051 : oracle 11.2.0.1 rac reboot often and find ORA-00600

1^#

发表于 2012-12-9 16:47:57 | 查看: 6219| 回复: 10

本帖最后由 taoy_2008 于 2012-12-9 16:50 编辑

操作系统版本:aix 6.1
数据库版本: 11.2.0.1

在数据库运行的时候 alert日志提示下面错误.并且数据库自动重启.
Sun Dec 09 02:18:02 2012
Thread 2 advanced to log sequence 1019 (LGWR switch)
Current log# 18 seq# 1019 mem# 0: +DATA/sxappdb/onlinelog/group_18.322.801509351
Sun Dec 09 02:18:17 2012
Errors in file /u01/app/oracle/diag/rdbms/sxappdb/sxappdb2/trace/sxappdb2_ora_10027692.trc (incident=158169):
ORA-00600: 内部错误代码, 参数: [kcbo_switch_cq_1], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/sxappdb/sxappdb2/incident/incdir_158169/sxappdb2_ora_10027692_i158169.trc
ORA-00600: internal error code, arguments: [kcbo_switch_cq_1], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/sxappdb/sxappdb2/incident/incdir_156073/sxappdb2_pmon_5243752_i156073.trc
Errors in file /u01/app/oracle/diag/rdbms/sxappdb/sxappdb2/trace/sxappdb2_pmon_5243752.trc:
ORA-00600: internal error code, arguments: [kcbo_switch_cq_1], [], [], [], [], [], [], [], [], [], [], []
PMON (ospid: 5243752): terminating the instance due to error 472
Sun Dec 09 02:19:30 2012
ORA-1092 : opitsk aborting process
Sun Dec 09 02:19:30 2012
License high water mark = 195
System state dump is made for local instance
System State dumped to trace file /u01/app/oracle/diag/rdbms/sxappdb/sxappdb2/trace/sxappdb2_diag_4260732.trc
Instance terminated by PMON, pid = 5243752
USER (ospid: 9502742): terminating the instance
Instance terminated by USER, pid = 9502742
Sun Dec 09 02:19:48 2012
Adjusting the default value of parameter parallel_max_servers
from 1920 to 1485 due to the value of parameter processes (1500)
Starting ORACLE instance (normal)
sskgpgetexecname failed to get name

600.rar

559.27 KB, 下载次数: 1162

trace

分享0

收藏0 回复只看该作者道具举报

Liu Maclean(刘相兵

2^#

发表于 2012-12-11 12:32:22

AIX + 11.2.0.1.0 - 64bit Production

Dump continued from file: /u01/app/oracle/diag/rdbms/sxappdb/sxappdb2/trace/sxappdb2_pmon_9895952.trc
ORA-00600: internal error code, arguments: [kcbo_switch_cq_1], [], [], [], [], [], [], [], [], [], [], []
SO: 0x700000eb0bb6800, type: 4, owner: 0x700000e90a9d2d8, flag: INIT/-/-/0x00 if: 0x3 c: 0x3
proc=0x700000e90a9d2d8, name=session, file=ksu.h LINE:11467 ID:, pg=0
(session) sid: 49 ser: 1 trans: 0x0, creator: 0x700000e90a9d2d8
flags: (0x51) USR/- flags_idl: (0x1) BSY/-/-/-/-/-
flags2: (0x409) -/-/INC
DID: 0002-, short-term DID:
txn branch: 0x0
oct: 0, prv: 0, sql: 0x0, psql: 0x0, user: 0/SYS
ksuxds FALSE at location: 0
service name: SYS$BACKGROUND
Current Wait Stack:
Not in wait; last wait ended 1.585446 sec ago
Wait State:
fixed_waits=0 flags=0x21 boundary=0x0/-1
Session Wait History:
elapsed time of 1.585479 sec since last wait
0: waited for 'ges message buffer allocation'
pool=0x0, request=0x1, allocated=0x0
wait_id=408 seq_num=409 snap_id=1
wait times: snap=0.000006 sec, exc=0.000006 sec, total=0.000006 sec
wait times: max=infinite
wait counts: calls=0 os=0
occurred after 0.169666 sec of elapsed time
1: waited for 'pmon timer'
duration=0x12b, =0x0, =0x0
wait_id=407 seq_num=408 snap_id=1
wait times: snap=2.990037 sec, exc=2.990037 sec, total=2.990037 sec
wait times: max=2.990000 sec
wait counts: calls=1 os=1
occurred after 0.000650 sec of elapsed time