ORA-07445:oracle_[type: SIGSEGV, Address not mapped to object]

xingfei80發表於2017-03-22
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x113E2AA20] [PC:0x1022E64AC, pfrinstr_CALL()+300] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/epms/EPMS1/trace/EPMS1_ora_31392036.trc (incident=142208):ORA-07445: [pfrinstr_CALL()+300] [SIGSEGV] [ADDR:0x113E2AA20] [PC:0x1022E64AC] [Address not mapped to object] []
Incident details in: /u01/app/oracle/diag/rdbms/epms/EPMS1/incident/incdir_142208/EPMS1_ora_31392036_i142208.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x113E2AA20] [PC:0x10220D02C, pfrtra()+140] [flags: 0x0, count: 2]
Errors in file /u01/app/oracle/diag/rdbms/epms/EPMS1/trace/EPMS1_ora_31392036.trc (incident=142209):
ORA-07445: [pfrtra()+140] [SIGSEGV] [ADDR:0x113E2AA20] [PC:0x10220D02C] [Address notmapped to object] []
ORA-07445: [pfrinstr_CALL()+300] [SIGSEGV] [ADDR:0x113E2AA20] [PC:0x1022E64AC] [Address not mapped to object] []
Incident details in: /u01/app/oracle/diag/rdbms/epms/EPMS1/incident/incdir_142209/EPMS1_ora_31392036_i142209.trc


*** 2013-02-25 10:00:16.309
*** SESSION ID:(1057.24601) 2013-02-25 10:00:16.309
*** CLIENT ID:() 2013-02-25 10:00:16.309
*** SERVICE NAME:(EPMS) 2013-02-25 10:00:16.309
*** MODULE NAME:(PL/SQL Developer) 2013-02-25 10:00:16.309
*** ACTION NAME:(Secondary Session) 2013-02-25 10:00:16.309

when attempting to commit a transaction that deletes from an Oracle table with a Text index, or that updates a column which is used in a Text index definition.
The Alert log of the Oracle Server shows errors of the following form:

Changes

Uprade of the Oracle Server to 11.2.

Cause

Bug 13340182 has been encountered. Coded added to fix bug 8880326 (included in 11.2) has introduced this problem.

Solution

Apply patch 13340182 to the Oracle Server.

看到是由於使用PL/DEVELOPER發出的命令導致的錯誤,(共享記憶體錯誤,oracle process 接受到OS的錯誤異常)可能也是由於oracle的BUG導致,前面也提到對於這種BUG,能繞過去就繞過去,實在不行再打補丁。

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/14663377/viewspace-2135805/,如需轉載,請註明出處,否則將追究法律責任。

相關文章