Oracle ORA-07445 [0000000000000000] 错误分析

根据trace 文件中的信息，我们这里的是insert时触发的ORA-7445。所以对应bug：3628622。该bug不会对数据库产生影响，Oracle 对该

1. OS 和DB 版本

DB Version： 9.2.0.6

OS Version：HP-UXiasd5_pb B.11.23 U ia64 0515426764 unlimited-user license

2.alert log

Thu Oct11 18:14:17 2012

Errors infile /Oracle/product/9.2.0/rdbms/log/ingwdb_ora_17366.trc:

ORA-07445: exception encountered: core dump [0000000000000000][SIGSEGV] [Invalid permissions for mapped object] [0x000000000] [] []

Thu Oct11 18:15:10 2012

Errors infile /oracle/product/9.2.0/rdbms/log/ingwdb_ora_17665.trc:

ORA-07445:exception encountered: core dump [0000000000000000] [SIGSEGV] [Invalidpermissions for mapped object] [0x000000000] [] []

Thu Oct11 18:15:33 2012

Errors infile /oracle/product/9.2.0/rdbms/log/ingwdb_ora_18405.trc:

ORA-07445:exception encountered: core dump [9fffffff7f79e8b0] [SIGILL] [Illegal opcode][0x9FFFFFFF7F79E8B0] [] []

Fri Oct12 10:08:25 2012

Errors infile /oracle/product/9.2.0/rdbms/log/ingwdb_ora_6934.trc:

ORA-07445:exception encountered: core dump [0000000000000000] [SIGSEGV] [Invalidpermissions for mapped object] [0x000000000] [] []

Fri Oct12 10:08:53 2012

Errors infile /oracle/product/9.2.0/rdbms/log/ingwdb_ora_7134.trc:

ORA-07445:exception encountered: core dump [0000000000000000] [SIGSEGV] [Invalidpermissions for mapped object] [0x000000000] [] []

Fri Oct12 10:10:42 2012

Errors infile /oracle/product/9.2.0/rdbms/log/ingwdb_ora_8290.trc:

ORA-07445:exception encountered: core dump [9fffffff7f79e8b0] [SIGILL] [Illegal opcode][0x9FFFFFFF7F79E8B0] [] []

Fri Oct12 10:11:46 2012

Errors infile /oracle/product/9.2.0/rdbms/log/ingwdb_ora_9434.trc:

ORA-07445:exception encountered: core dump [0000000000000000] [SIGSEGV] [Invalidpermissions for mapped object] [0x000000000] [] []

Fri Oct12 10:45:00 2012

Errors infile /oracle/product/9.2.0/rdbms/log/ingwdb_ora_23859.trc:

ORA-07445:exception encountered: core dump [0000000000000000] [SIGSEGV] [Invalidpermissions for mapped object] [0x000000000] [] []

Fri Oct12 10:45:26 2012

Errors infile /oracle/product/9.2.0/rdbms/log/ingwdb_ora_25087.trc:

ORA-07445:exception encountered: core dump [0000000000000000] [SIGSEGV] [Invalidpermissions for mapped object] [0x000000000] [] []

Fri Oct12 10:47:14 2012

Errors infile /oracle/product/9.2.0/rdbms/log/ingwdb_ora_25149.trc:

ORA-07445:exception encountered: core dump [0000000000000000] [SIGSEGV] [Invalidpermissions for mapped object] [0x000000000] [] []

Fri Oct12 11:04:11 2012

Errors infile /oracle/product/9.2.0/rdbms/log/ingwdb_ora_4122.trc:

ORA-07445:exception encountered: core dump [0000000000000000] [SIGSEGV] [Invalidpermissions for mapped object] [0x000000000] [] []

3.Trace file

*** 2012-10-12 11:04:11.922

*** SESSION ID:(14.6203) 2012-10-1211:04:11.922

Exception signal: 11 (SIGSEGV), code: 2(Invalid permissions for mapped object), addr: 0x0, PC: [0x0, Cannot findsymbol in ?锜?

0000000000000000]

  r1:9fffffff7f79f668      r20:40000000008d5170      br5:                0

  r2:c0000000cb643000      r21:9fffffff7f5082a0      br6:                0

 r3:            851b      r22:                8      br7: e0000000015917e0

  r4:9fffffff7f508d68      r23:656e71756575655f        ip:                0

  r5:9fffffffffff1dd8      r24:                8     iipa:                0

  r6:9fffffffffff1dd4      r25:                8      cfm:                3

  r7:9fffffffffff1de4      r26:40000000008d5178        um:              3a

 r8:                0      r27: 9fffffff7f5082a8      rsc:              1f

  r9:9fffffff7f740600      r28:40000000008d5170      bsp:9fffffff7f801938

 r10:                0      r29: 9fffffff7f5082a0  bspstore: 9fffffff7f801938

 r11:60000000003fdc30      r30:                0      rnat:                0

 r12:9fffffffffff1150      r31:                0      ccv:                1

 r13:9fffffff7f7cd420      NaTs:                0      unat:                0

 r14:7265736f75726365      PRs:            cc5b      fpsr:   9804c8a74433f

 r15:656e71756575655f      br0:4000000002835ec0      pfs:c00000000000060f