日期:2014-05-16  浏览次数:21349 次

紧急求助 oracle建索引失败后 RAC宕机!
系统 AIX 6.1 oracle 10.2.0.4

 昨天下午添加一个索引,建了2个小时还没有成功就手动取消了!
之后查看别人smon会做善后工作 就没有处理。一直观察也没有什么问题
突然在刚才23:45开始 出现大量的 ora 600错误。
同事 OS也报错
alert .log



ORA-00600: internal error code, arguments: [15764], [], [], [], [], [], [], []
Wed Sep 7 00:26:42 2011
Errors in file /apps/oracle/admin/sfc3db/udump/sfc3db2_ora_5054706.trc:
ORA-00600: internal error code, arguments: [15764], [], [], [], [], [], [], []
Wed Sep 7 00:26:44 2011
Trace dumping is performing id=[cdmp_20110907002644]
Wed Sep 7 00:27:10 2011
Errors in file /apps/oracle/admin/sfc3db/udump/sfc3db2_ora_2756730.trc:
ORA-00600: internal error code, arguments: [15764], [], [], [], [], [], [], []
Wed Sep 7 00:28:11 2011
Errors in file /apps/oracle/admin/sfc3db/udump/sfc3db2_ora_2756730.trc:
ORA-00600: internal error code, arguments: [15764], [], [], [], [], [], [], []



erppt 


LABEL: CORE_DUMP
IDENTIFIER: A924A5FC

Date/Time: Wed Sep 7 00:13:35 GMT+08:00 2011
Sequence Number: 2190
Machine Id: 00C8B9724C00
Node Id: sfc3rac2
Class: S
Type: PERM
WPAR: Global
Resource Name: SYSPROC

Description
SOFTWARE PROGRAM ABNORMALLY TERMINATED

Probable Causes
SOFTWARE PROGRAM

User Causes
USER GENERATED SIGNAL

  Recommended Actions
  CORRECT THEN RETRY

Failure Causes
SOFTWARE PROGRAM

  Recommended Actions
  RERUN THE APPLICATION PROGRAM
  IF PROBLEM PERSISTS THEN DO THE FOLLOWING
  CONTACT APPROPRIATE SERVICE REPRESENTATIVE

Detail Data
SIGNAL NUMBER
  6
USER'S PROCESS ID:
  5452002
FILE SYSTEM SERIAL NUMBER
  14
INODE NUMBER
  931776
CORE FILE NAME
/apps/oracle/admin/sfc3db/cdump/core_5452002/core
PROGRAM NAME
oracle
STACK EXECUTION DISABLED
  0
COME FROM ADDRESS REGISTER
splay 0

PROCESSOR ID
  hw_fru_id: 0
  hw_cpu_id: 1

ADDITIONAL INFORMATION
slcra 3EC
??
ksedmp 330
ksfdmp 1C
kgeriv 10C
kgesiv 84
ksesic0 64
kxfprigdb 2F0
kxfpssg 3D4
kxfpqsod_ 610
kxfpqsod 31C
kxfrdel 1D0
kxsffir 244
kxsFreeWo 100
kxsFreeEx 2C
kksumc 8D8
opifch2 1C9C
opiefn0 3E4
opiefn E0
opiodr AE4
ttcpip 1024
opitsk 1128
opiino 994
opiodr AE4
opidrv 488
sou2o 94
opimai_re 1C0
main 9C
__start 74

Symptom Data
REPORTABLE
1
INTERNAL ERROR
0
SYMPTOM CODE
PCSS/SPI2 FLDS/oracle SIG/6 FLDS/slcra VALU/3ec



根本连接不上 随便执行一个查询就报ORA 600错误
没有办法只有关掉这个节点!

和我取消掉这个在建的索引有关吗?
紧急求助 最高只能给100分

------解决方案--------------------

------解决方案--------------------
等高手,帮顶。
------解决方案--------------------
不是生产库的话重新启动下,再看看错误信息
------解决方案--------------------
看看cluster的几个LOG。

------解决方案--------------------

------解决方案--------------------

------解决方案--------------------

Errors in file /apps/oracle/admin/sfc3db/udump/sfc3db2_ora_5054706.trc: