Oracle 10g RAC (10.2.0.3) : ORA-07445:[opidsa()+386] [SIGSEGV] [Address not mapped to object]

tolywang發表於2008-03-06

Oracle10g RAC 10.2.0.3

Linux AS4.0 64Bit .

--------------------------------------------------------------------

alert log :

--------------------------------------------------------------------


Thu Mar 6 08:48:18 2008
Thread 1 advanced to log sequence 16378
Current log# 6 seq# 16378 mem# 0: /ocfs_data/tpc/redo06a.log
Current log# 6 seq# 16378 mem# 1: /ocfs_data2/tpc/redo06b.log
Thu Mar 6 08:54:19 2008
Errors in file /u01/product/admin/tpc/udump/tpc1_ora_1829.trc:
ORA-07445: 鍑虹幇寮傚父閿欒?: 鏍稿績杞?偍 [opidsa()+386] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []
Thu Mar 6 08:54:21 2008
Trace dumping is performing id=[cdmp_20080306085421]

[@more@]


Thu Mar 6 08:55:07 2008
Errors in file /u01/product/admin/tpc/udump/tpc1_ora_23329.trc:
ORA-07445: 鍑虹幇寮傚父閿欒?: 鏍稿績杞?偍 [opidsa()+386] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []
Thu Mar 6 08:55:08 2008
Trace dumping is performing id=[cdmp_20080306085508]
Thu Mar 6 08:55:29 2008
Thread 1 advanced to log sequence 16379
Current log# 7 seq# 16379 mem# 0: /ocfs_data/tpc/redo07a.log
Current log# 7 seq# 16379 mem# 1: /ocfs_data2/tpc/redo07b.log
Thu Mar 6 09:02:13 2008
Thread 1 advanced to log sequence 16380
Current log# 8 seq# 16380 mem# 0: /ocfs_data/tpc/redo08a.log
Current log# 8 seq# 16380 mem# 1: /ocfs_data2/tpc/redo08b.log
Thu Mar 6 09:12:08 2008
Thread 1 advanced to log sequence 16381
Current log# 9 seq# 16381 mem# 0: /ocfs_data/tpc/redo09a.log
Current log# 9 seq# 16381 mem# 1: /ocfs_data2/tpc/redo09b.log
Thu Mar 6 09:22:31 2008
Thread 1 advanced to log sequence 16382
Current log# 10 seq# 16382 mem# 0: /ocfs_data/tpc/redo10a.log
Current log# 10 seq# 16382 mem# 1: /ocfs_data2/tpc/redo10b.log
Thu Mar 6 09:25:33 2008
Errors in file /u01/product/admin/tpc/udump/tpc1_ora_15505.trc:
ORA-07445: 鍑虹幇寮傚父閿欒?: 鏍稿績杞?偍 [opidsa()+386] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []
Thu Mar 6 09:25:34 2008
Trace dumping is performing id=[cdmp_20080306092534]
Thu Mar 6 09:33:42 2008
Thread 1 advanced to log sequence 16383
Current log# 5 seq# 16383 mem# 0: /ocfs_data/tpc/redo05a.log
Current log# 5 seq# 16383 mem# 1: /ocfs_data2/tpc/redo05b.log
Thu Mar 6 09:45:04 2008
Thread 1 advanced to log sequence 16384
Current log# 6 seq# 16384 mem# 0: /ocfs_data/tpc/redo06a.log


------------------------------------------------------------------------------------

trace file log :


/u01/product/admin/tpc/udump/tpc1_ora_15505.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
ORACLE_HOME = /u01/product/oracle
System name: Linux
Node name: gnd-rac01
Release: 2.6.9-42.ELlargesmp
Version: #1 SMP Wed Jul 12 23:46:39 EDT 2006
Machine: x86_64
Instance name: tpc1
Redo thread mounted by this instance: 1
Oracle process number: 67
Unix process pid: 15505, image:

*** ACTION NAME:() 2008-03-06 09:25:33.478
*** MODULE NAME:(TOAD 7.6.0.11) 2008-03-06 09:25:33.478
*** SERVICE NAME:(tpc) 2008-03-06 09:25:33.478
*** SESSION ID:(1218.65250) 2008-03-06 09:25:33.478
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x0, PC: [0x2395a0a, opidsa()+386]
*** 2008-03-06 09:25:33.490
ksedmp: internal or fatal error
ORA-07445: 鍑虹幇寮傚父閿欒?: 鏍稿績杞?偍 [opidsa()+386] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []
Current SQL statement for this session:
Select CREATED, LAST_DDL_TIME,
OBJECT_ID, STATUS, TIMESTAMP
from sys.DBA_OBJECTS
where object_name = :objname
and object_type = :objtype
and owner = :ownere
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
Cannot find symbol
Cannot find symbol
Cannot find symbol
ksedst()+31 call ksedst1() 000000000 ? 000000001 ?
2A97164D50 ? 2A97164DB0 ?
2A97164CF0 ? 000000000 ?
ksedmp()+610 call ksedst() 000000000 ? 000000001 ?
2A97164D50 ? 2A97164DB0 ?

查詢Metalink 上發現是一bug .

Subject: ORA-7445 (opidsa)
Doc ID: Note:435632.1Type: REFERENCE
Last Revision Date: 21-DEC-2007Status: PUBLISHED

Note: For additional ORA-7445 related information please read Note 211909.1

PURPOSE:

  This article provides information on one or more bugs that are 
  known to result in the given ORA-7445 error.

SUGGESTIONS:

  If the Known Issues section below does not help in terms of identifying
  a solution, please submit the trace files and alert.log to Oracle 
  Support Services for further analysis.

  Known Issues:
  Bug# 5648872 *  See Note 5648872.8
    * This bug is alerted in Note 418531.1
      Dump (opidsa) from DESCRIBE of a cursor
      Fixed: 11

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

相關文章