首页 » ORACLE » Troubleshooting ora-07445 [smboCkaGetPivot]

Troubleshooting ora-07445 [smboCkaGetPivot]

Today I hit this error in a production DB,  db version is 10.2.0.5 rac on hpux, the alert show ORA-07445 [smboCkaGetPivot] ,Simply record it here .
# alert

Mon Dec 22 09:43:39 EAT 2014
Errors in file /opt/oracle/app/admin/anbob/udump/anbob1_ora_8183.trc:
ORA-07445: exception encountered: core dump [smboCkaGetPivot()+240] [SIGSEGV] [Invalid permissions for mapped object] [0x000000110] [] []
Mon Dec 22 09:43:42 EAT 2014
Trace dumping is performing id=[cdmp_20141222094342]

# trace
/opt/oracle/app/admin/anbob/udump/anbob1_ora_8183.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
ORACLE_HOME = /opt/oracle/app/product/10.2.0/db_1
System name:    HP-UX
Node name:      anbob1
Release:        B.11.31
Version:        U
Machine:        ia64
Instance name: anbob1
Redo thread mounted by this instance: 1
Oracle process number: 74
Unix process pid: 8183, image: oracle@anbob1

*** 2014-12-22 09:43:39.032
*** ACTION NAME:() 2014-12-22 09:43:39.031
*** MODULE NAME:(SQL*Plus) 2014-12-22 09:43:39.031
*** SERVICE NAME:(anbob) 2014-12-22 09:43:39.031
*** SESSION ID:(781.64) 2014-12-22 09:43:39.031
Exception signal: 11 (SIGSEGV), code: 2 (Invalid permissions for mapped object), addr: 0x110, PC: [0x4000000002cd98f0, smboCkaGetPivot()+2
40]
r1: 60000000000ba268       r20:               f8       br5:                0
r2: c000000100e03000       r21:               1f       br6: c000000000426870
r3:                0       r22:                0       br7: e000000001f41d20
r4:                0       r23: 9fffffffbf26efb0        ip: 4000000002cd98f0
r5: c000000000000408       r24: 9fffffffb691f0d9      iipa:                0
r6: c0000000000443e0       r25:                0       cfm:              794
r7: 9fffffffbf7f8de8       r26: 9fffffffbb840ad0        um:               1a
r8: 9fffffffb4364a20       r27: 9fffffffb691f0e8       rsc:               1f
r9:               33       r28:                0       bsp: 9fffffffbf802578
r10:              110       r29: 9fffffffbb840dd0  bspstore: 9fffffffbf802578
r11:                3       r30:                1      rnat:                0
r12: 9ffffffffffe1590       r31: 60000000000c6ed8       ccv:                0
r13: 9fffffffbf4554b0      NaTs:                0      unat:                0
r14: 9fffffffb43649b8       PRs:            2817f      fpsr:    9804c8a74433f
r15: 9fffffffb4364958       br0: 4000000002cda680       pfs: c0000000000012ab
r16:               1c       br1: c000000000291b20        lc:                0
r17:             3539       br2:                0        ec:                0
r18: 9fffffffb4363e71       br3:                0       isr: 9fffffffbf802578
r19: 9fffffffb691edd8       br4:                0       ifa:                0
Reason code: 0053
*** 2014-12-22 09:43:39.062
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [smboCkaGetPivot()+240] [SIGSEGV] [Invalid permissions for mapped object] [0x000000110] [] []
Current SQL statement for this session:
SELECT DISTINCT A.F_CUSTOM_NUM, A.PRODUCT_ID, B.PRODUCT_NBR FROM ORDER_RELATION_2012 A, PRODUCT B, xxxx_CUSTOM_INFO C WHERE A.F_PAR=LPAD(T
O_CHAR(:B2 ),2,’0′) AND A.STATE = ‘0’ AND A.PRODUCT_ID = B.PRODUCT_ID AND C.PROD_CUSTOM_NUM = A.F_CUSTOM_NUM AND TO_CHAR(A.F_SUBSCIBE_TIME
,’yyyymmdd’) < :B1
—– PL/SQL Call Stack —–
object      line  object
handle    number  name
c0000002fda0deb0        35  procedure VSOP_OWNER_USER.BB_VSOP_TO_GROUP_P
c0000002fda9fce8         1  anonymous block
—– Call Stack Trace —–
calling              call     entry                argument values in hex
location             type     point                (? means dubious value)
——————– ——– ——————– —————————-
ksedst()+64          call     ksedst1()            000000001 ? 000000001 ?
ksedmp()+2176        call     ksedst()             000000001 ?

ssexhd()+1264        call     ksedmp()             000000003 ?

<kernel>             call     ssexhd()             C0000002FF6101D8 ?
60000000000C9570 ?
C000000100E0A8C8 ?
60000000000BA268 ?
smboCkaGetPivot()+2  call     <kernel>             6000000000235200 ?
40                                                 20000000B ?
6000000000235010 ?
000000000 ? 000000000 ?
smboCkaQS()+144      call     smboCkaGetPivot()    9FFFFFFFB4364820 ?
00000001C ? 000000034 ?
00000000A ?
9FFFFFFFB4364ABC ?
C0000000000012AB ?
smboAQSdoRS()+1536   call     smboCkaQS()          9FFFFFFFB4364820 ?
00000001B ? 000000034 ?
00000000A ?
9FFFFFFFBF26EC78 ?
smboAQSdoQS()+1360   call     smboAQSdoRS()        9FFFFFFFBF26EDB8 ?

smboAQSdoQS()+1360   call     smboAQSdoRS()        9FFFFFFFBF26EDB8 ?
000000000 ? 0000000FF ?
000000002 ?
C0000000000010A7 ?
4000000002CDB410 ?
smboSort()+608       call     smboAQSdoQS()        9FFFFFFFBF26EDB8 ?
9FFFFFFFAC121140 ?

smboAQSdoQS()+1360   call     smboAQSdoRS()        9FFFFFFFBF26EDB8 ?
000000000 ? 0000000FF ?
000000002 ?
C0000000000010A7 ?
4000000002CDB410 ?
smboSort()+608       call     smboAQSdoQS()        9FFFFFFFBF26EDB8 ?

smbeod()+112         call     smboSort()           9FFFFFFFBF26EDB8 ?

9FFFFFFFBF26ED48 ?
soreod()+112         call     smbeod()             9FFFFFFFBF26EDB8 ?

9FFFFFFFBF26EE00 ?
qersoFetch()+2160    call     soreod()             9FFFFFFFBF26EDB8 ?

9FFFFFFFBF26EF28 ?
qerjotFetch()+416    call     qersoFetch()         C0000002DA371558 ?
4000000001CA48B0 ?
9FFFFFFFFFFEDA80 ?
000007FFF ?
rwsfcd()+256         call     qerjotFetch()        C0000002DA3713C8 ?

qerhjFetch()+912     call     rwsfcd()             9FFFFFFFBF3EB608 ?
4000000001CA48B0 ?
qerghFetch()+544     call     qerhjFetch()         C0000002DA371290 ?

opifch2()+6176       call     qerghFetch()         C0000002DA3710E0 ?

000028263 ?
opifch()+112         call     opifch2()            9FFFFFFFFFFEED00 ?
4000000002FBFE70 ?
00002EC33 ?
opipls()+7600        call     opifch()             C00000000000224C ?

000000002 ?
opiodr()+2144        call     opipls()             9FFFFFFFFFFEF630 ?

rpidrus()+368        call     opiodr()             000000066 ? 000000006 ?

skgmstack()+288      call     rpidrus()            9FFFFFFFFFFF1D80 ?

rpidru()+240         call     skgmstack()          9FFFFFFFFFFF1DA0 ?

9FFFFFFFFFFF1D80 ?
rpiswu2()+976        call     rpidru()             00000057B ?

rpidrv()+2352        call     rpiswu2()            9FFFFFFFFFFF2AB0 ?

60000000000C6CA0 ?
psddr0()+864         call     rpidrv()             000000001 ? 000000066 ?
9FFFFFFFFFFF36C0 ?
000000038 ?
9FFFFFFFFFFF2AE0 ?
60000000000BA268 ?
psdnal()+736         call     psddr0()             000000001 ? 000000066 ?

pevm_BFTCHC()+1152   call     psdnal()             9FFFFFFFFFFF54A0 ?

pfrinstr_FTCHC()+32  call     pevm_BFTCHC()        9FFFFFFFBF3EF160 ?
0                                                  9FFFFFFFBF3E1124 ?
9FFFFFFFBF3E0DF8 ?
pfrrun_no_tool()+19  call     pfrinstr_FTCHC()     9FFFFFFFBF3EF160 ?

pfrrun()+1376        call     pfrrun_no_tool()     9FFFFFFFBF3EF160 ?

plsql_run()+1328     call     pfrrun()             9FFFFFFFFFFF3758 ?

4000000002C2EDB0 ?
peicnt()+560         call     plsql_run()          9FFFFFFFFFFF4350 ?

kkxexe()+1008        call     peicnt()             9FFFFFFFFFFF54A0 ?

9FFFFFFFFFFF4ED0 ?
opiexe()+8016        call     kkxexe()             0000051F0 ?

kpoal8()+3808        call     opiexe()             9FFFFFFFFFFF72D0 ?

opiodr()+2144        call     kpoal8()             9FFFFFFFFFFF7A00 ?

ttcpip()+1680        call     opiodr()             00000005E ? 000000017 ?

opitsk()+2368        call     ttcpip()             600000000003DF40 ?

opiino()+1664        call     opitsk()             000000000 ? 000000000 ?

4000000001BF4008 ?
opiodr()+2144        call     opiino()             00000003C ?

opidrv()+1248        call     opiodr()             00000003C ? 000000004 ?

sou2o()+240          call     opidrv()             00000003C ?
60000000000C6C98 ?
9FFFFFFFFFFFF240 ?
opimai_real()+496    call     sou2o()              9FFFFFFFFFFFF260 ?
00000003C ? 000000004 ?
9FFFFFFFFFFFF240 ?
main()+240           call     opimai_real()        000000000 ?
9FFFFFFFFFFFF290 ?
main_opd_entry()+80  call     main()               000000002 ?

Search in MOS
ORA-07445 [smboCkaGetPivot()+176] ERROR HIT FROM VARIOUS SELECT BASED SQL (文档 ID 1624100.1)  
Applies to:
Oracle Database – Standard Edition – Version 10.2.0.5 to 10.2.0.5 [Release 10.2]
Information in this document applies to any platform.
Symptoms

The following symptoms are known to be directly atrributed to this issue :-

a) Database is 10gR2
b) Error of following nature is seen in the alert log :-
ORA-07445: exception encountered: core dump [smboCkaGetPivot()+240] [SIGSEGV] [Invalid permissions for mapped object] [0x000000110] [] []
c) Stack trace will be similar to :-

Function List   (to Full stack)   (to Summary stack)

smboCkaGetPivot <- smboCkaQS <- smboAQSdoQS <- smboAQSdoRS <- smboAQSdoQS
<- smboSort <- smbeod <- soreod <- qersoFetch <- opifch2
<- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino
<- opiodr <- opidrv <- sou2o <- opimai_real <- main
<- main_opd_entry

d) The ORA-07445 trace file will show that the EXPLAIN PLAN can be generated so this is not an EXPLAIN PLAN issue
Cause

No known BUG is identifed based on 7445 stack trace.
Solution

The functions represent sort based operations so the following workaround was tested and was seen to resolve the error :-

_newsort_enabled=FALSE

This parameter can be set dynamically :-

alter system set “_newsort_enabled”=FALSE;

If using an SPFILE you can use :-

alter system set “_newsort_enabled”=TRUE scope=BOTH; — note this wrong in MOS note.

I used the following command:
ALTER SYSTEM SET “_newsort_enabled”=FALSE SCOPE=BOTH SID=’*’;

If not using an SPFILE we need to edit the PFILE to include this hidden parameter and to ensure if a future stop/start is made it is kept in place.

Tip:

if you hit  ORA-07445: exception encountered: core dump [smboKb2Qb()+1057] [SIGSEGV] [Address not mapped to object] [0x8010FFFFBF3EB530] [] [], the Solutions  same as above .

打赏

,

对不起,这篇文章暂时关闭评论。