Oracle ORA-07445 [0000000000000000] Error Analysis

 

 

1. OS and DB versions

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_220..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

 

 

* ** 11:04:11. 922

* ** Session ID: (14.6203) 2012-10-. 922

Exception signal: 11 (SIGSEGV), Code: 2 (invalid permissions for mapped object), ADDR: 0x0, PC: [0x0, cannot findsymbol in? Why?

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: 20175736f75369365 PRS: cc5b fpsr: 9804c8a74433f

R15: 656e71756575655f br0: 4000000002835ec0 PFS: c0000000060f

R16: 2 br1: 0 LC: 0

R17: c0000000919d2800 Br2: 0 EC: 0

R18: 60000000003ec990 Br3: 0 ISR: 9fffffff7f801938

R19: 73 br4: 0 IFA: 0

Redis code: 0052

* ** 11:04:11. 923

Ksedmp: internal or fatal error

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

Current SQL statement for this session:

Insert into stats $ resource_limit (snap_id, dbid, instance_number, resource_name, current_utilization, clerk, initial_allocation, limit_value) Select: B3,: B2,: B1, resource_name, clerk, clerk, initial_allocation, limit_value from V $ resource_limit where limit_value! = 'Limited' and max_utilization> 0

----- PL/SQL call stack -----

Object line Object

Handle number name

C00000009284ced8 2235 package body perfstat. statspack

C00000009284ced8 91 package body perfstat. statspack

C000000093a2f120 1 anonymous Block

 

 

4. Locate Problems and Solutions

This error is caused by a bug 3628622 in Oracle 9.2.0.6. There are two bugs related to select and insert for V $ resource_limit:

Bug 4171822: Select * from V $ resource_limit fails with ORA-07445:

ORA-7445 [qerfxfetch] On insert into stats $ resource_limit [ID 742723.1] (bug 3628622)

 

According to the information in the trace file, here we are the ORA-7445 triggered during insert. So the corresponding BUG: 3628622.

 

This bug does not affect the database. Oracle does not provide one-off patches for this bug. To solve this bug, you must upgrade the database to a higher version.Upgrade to 11.2.0.3.4.

 

5. underlying causes of the problem

The underlying cause of this bug is described in another article on MOS:

ORA-7445 errors on itanium platforms due toitanium symbol preemption [ID 302172.1]

Cause

Due to Intel's elf Abi architecture onitanium platforms code constructs like:

(* Function_pointer) (<list ofparameters>)

I. e. dereferencing a function pointervariable allows for symbol preemption.

On itanium global variables are adressedindirectly through a global offset process table. The offsets are relative tothe global pointer address (GP ).

At runtime due to symbol preemption thefunction pointer address may end up at a location where it cannot be directlyaddressed from the GP value.

This was seen to happen with oraclefunction pointer variables which were stored in and later reread from the SGA.

As a result the process cocould not find theexecutable Code address and terminated with SIGSEGV.

 

 

 

 

 

 

 

 

 

All rights reserved. reprinted articles are allowed, but source addresses must be indicated by links. Otherwise, the documents will be held legally responsible!

Skype: tianlesoftware

QQ: tianlesoftware@gmail.com

Email: tianlesoftware@gmail.com

Blog: http://blog.csdn.net/tianlesoftware

WEAVER: http://weibo.com/tianlesoftware

Twitter: http://twitter.com/tianlesoftware

Facebook: http://www.facebook.com/tianlesoftware

LinkedIn: http://cn.linkedin.com/in/tianlesoftware