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 .
微信扫一扫，打赏作者吧～
对不起，这篇文章暂时关闭评论。