ORA-07445 [kkoipt()+3881] [SIGSEGV] [Address not mapped to object]
ORA-07445: exception encountered: core dump [kkoipt()+3881] [SIGSEGV] [Address not mapped to object] [0x000000028] [] []
[root@ora udump]# more orclsid_ora_13842.trc
/data/oracle/admin/orclsid/udump/orclsid_ora_13842.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /data/oracle/product/10.2.0.1
System name: Linux
Node name: ora.orclsid.com.cn
Release: 2.6.18-194.32.1.el5
Version: #1 SMP Wed Jan 5 17:52:25 EST 2011
Machine: x86_64
Instance name: orclsid
Redo thread mounted by this instance: 1
Oracle process number: 28
Unix process pid: 13842, image: oracle@ora.orclsid.com.cn
*** 2011-02-15 14:40:28.387
*** ACTION NAME:() 2011-02-15 14:40:28.386
*** MODULE NAME:(JDBC Thin Client) 2011-02-15 14:40:28.386
*** SERVICE NAME:(SYS$USERS) 2011-02-15 14:40:28.386
*** SESSION ID:(537.2724) 2011-02-15 14:40:28.386
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x
28, PC: [0x3028817, kkoipt()+3881]
*** 2011-02-15 14:40:28.394
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [kkoipt()+3881] [SIGSEGV] [Address n
ot mapped to object] [0x000000028] [] []
Current SQL statement for this session:
SELECT * FROM (SELECT ROWNUM PAGE_RN, PAGE_A.* FROM( SELECT
MB.tab1_AUTOID ,MC.VA
LUE ,MB.tab1_TIMESTAMP
,MB.tab1_SUBJECT ,MB.tab1_URL
,MB.tab1_URL_ENABLED
,SUM(1) OVER() TOTALCOUNT FROM
ora_tab1 MB ,(
SELECT SUBCLASS, VALUE FROM ora_tab WHERE MAINCLASS = 'MENU' ) M
C WHERE MB.tab1_
ENABLED = 1 AND MC.SUBCLASS (+)= MB.tab1_CLASS
ORDER BY MB.tab1_AUTOID DESC ) PAGE_A WHERE ROWNUM <=
20) PAGE_B WHERE PAGE_B.PAGE_RN>0
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ssd_unwind_bp: unhandled instruction at 0x2fb3962 instr=f
ksedst()+31 call ksedst1() 000000000 ? 000000001 ?
2AFAF78DFD50 ? 2AFAF78DFDB0 ?
2AFAF78DFCF0 ? 000000000 ?
[root@ora udump]# more /data/oracle/admin/orclsid/udump/orclsid_ora_15483.trc
/data/oracle/admin/orclsid/udump/orclsid_ora_15483.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /data/oracle/product/10.2.0.1
System name: Linux
Node name: ora.orclsid.com.cn
Release: 2.6.18-194.32.1.el5
Version: #1 SMP Wed Jan 5 17:52:25 EST 2011
Machine: x86_64
Instance name: orclsid
Redo thread mounted by this instance: 1
Oracle process number: 19
Unix process pid: 15483, image: oracle@ora.orclsid.com.cn (TNS V1-V3)
*** 2011-02-15 14:46:02.648
*** ACTION NAME:() 2011-02-15 14:46:02.647
*** MODULE NAME:(SQL*Plus) 2011-02-15 14:46:02.647
*** SERVICE NAME:(SYS$USERS) 2011-02-15 14:46:02.647
*** SESSION ID:(517.2366) 2011-02-15 14:46:02.647
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x28, PC: [0x3028817, kkoipt()+3881]
*** 2011-02-15 14:46:02.655
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [kkoipt()+3881] [SIGSEGV] [Address not mapped to object] [0x000000028] [] []
Current SQL statement for this session:
SELECT *
FROM (SELECT ROWNUM PAGE_RN, PAGE_A.*
FROM (SELECT MB.tab1_AUTOID,
MC.VALUE,
MB.tab1_TIMESTAMP,
MB.tab1_SUBJECT,
MB.tab1_URL,
MB.tab1_URL_ENABLED,
SUM(1) OVER() TOTALCOUNT
FROM ora_tab1 MB,
(SELECT SUBCLASS, VALUE
FROM ora_tab
WHERE MAINCLASS = 'MENU') MC
WHERE MB.tab1_ENABLED = 1
AND MC.SUBCLASS(+) = MB.tab1_CLASS
ORDER BY MB.tab1_AUTOID DESC) PAGE_A
WHERE ROWNUM <= 20) PAGE_B
WHERE pAGE_B.PAGE_RN > 0
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ssd_unwind_bp: unhandled instruction at 0x2fb3962 instr=f
ksedst()+31 call ksedst1() 000000000 ? 000000001 ?
2B9F9FAC6D50 ? 2B9F9FAC6DB0 ?
2B9F9FAC6CF0 ? 000000000 ?
ksedmp()+610 call ksedst() 000000000 ? 000000001 ?
2B9F9FAC6D50 ? 2B9F9FAC6DB0 ?
2B9F9FAC6CF0 ? 000000000 ?
ssexhd()+629 call ksedmp() 000000003 ? 000000001 ?
2B9F9FAC6D50 ? 2B9F9FAC6DB0 ?
2B9F9FAC6CF0 ? 000000000 ?
__restore_rt()+0 call ssexhd() 00000000B ? 2B9F9FAC7D70 ?
2B9F9FAC7C40 ? 2B9F9FAC6DB0 ?
2B9F9FAC6CF0 ? 000000000 ?
kkoipt()+3881 signal __restore_rt() 000000000 ? 000000000 ?
000000232 ? 000000000 ?
2B9F9FD0CFE8 ? 2B9F9FD87F38 ?
kkoqbc()+3552 call kkoipt() 2B9F9FDACA98 ? 000000000 ?
000000002 ? 000000000 ?
7FFF00000001 ? 2B9F9FD80000 ?
apakkoqb()+167 call kkoqbc() 000000000 ? 2B9F9FD0DE28 ?
000000002 ? 000000000 ?
000000001 ? 000000001 ?
apaqbdDescendents() call apakkoqb() 7FFF0C4D8350 ? 2B9F9FD0DE28 ?
+414 1F2621D20 ? 000000000 ?
000000001 ? 000000001 ?
apaqbdListReverse() call apaqbdDescendents() 7FFF0C4D8350 ? 2B9F9FD0DE28 ?
+68 1F2621D20 ? 000000000 ?
000000001 ? 000000001 ?
apaqbdDescendents() call apaqbdListReverse() 7FFF0C4D8350 ? 2B9F9FD0DE28 ?
+226 1F2621D20 ? 000000000 ?
000000001 ? 000000001 ?
apaqbdListReverse() call apaqbdDescendents() 7FFF0C4D8350 ? 2B9F9FD0F2D0 ?
+68 1F2621D20 ? 000000000 ?
000000001 ? 000000001 ?
-----------------
oracle 官方給了個不一定能解決問題的方法
修改隱含引數
預設值是true，改成false，無效
alter system set "_complex_view_merging"=true;
之後分析sql，分段執行，當去掉ROWNUM <= 20時語句正常
rownum<=6,5,4,3,2,1都可以，再更大報錯
檢查表ora_tab1
發現多個欄位重複建立聯合索引
由於表資料量較小，將索引全部刪除後系統恢復正常
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/13177610/viewspace-687265/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- ORA-07445:oracle_[type: SIGSEGV, Address not mapped to object]OracleGseAPPObject
- ORA-07445 [opidsa()+386] [SIGSEGV] [Address not mapped to object]GseAPPObject
- ORA-07445: [opitca()+4618] [SIGSEGV] [Address not mapped to object]GseAPPObject
- Oracle 10g RAC (10.2.0.3) ： ORA-07445:[opidsa()+386] [SIGSEGV] [Address not mapped to object]Oracle 10gGseAPPObject
- ORA-07445: exception encountered: core dump [kksIsNLSEqual()+72] [SIGSEGV] [Address not mapped to obExceptionGseAPP
- ORA-07445:出現異常錯誤:核心轉儲[kkqfppDrv1()+101]Address not mapped to objectAPPObject
- 記一次ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Address not maExceptionIntelASTmemcpyGse
- ORA-07445: exception encountered: core dump [qertbStart()+327] [SIGSEGV]ExceptionGse
- ORA-07445: exception encountered: core dump [ksxpunmap()+2742] [SIGSEGV]ExceptionGse
- ORA-07445: exception encountered: core dump [qkaqkn()+5390] [SIGSEGV]ExceptionGse
- ORA-07445: exception encountered: core dump [kgghstfel()+15] [SIGSEGV] ...ExceptionGse
- ORA-07445: exception encountered: core dump [kglpnp()+119] [SIGSEGV]ExceptionGse
- ORA-07445: exception encountered: core dump [CommonClientExit()+101] [SIGSEGV]ExceptionclientGse
- 報錯：ORA-07445: exception encountered: core dump [kkqtnloCbk()+111] [SIGSEGV]ExceptionQTGse
- Oracle內部錯誤:ORA-07445[_memcpy()+52] [SIGSEGV]一例OraclememcpyGse
- ORA-07445: 出現異常錯誤: 核心轉儲 [plcurClose()+40] [SIGSEGV]Gse
- ORA-07445: 出現異常錯誤: 核心轉儲 [ldxsnf()+625] [SIGSEGVGse
- 記一次ORA-07445: exception encountered: core dump [sdbgrfcvp_convert_pathinfo()+35] [SIGSEGV] [ADDR:0xFExceptionGse
- NHibernate提示表is not mappedAPP
- ORA-600(kkoipt:invalid join method)錯誤
- ORA-07445: [kkqtutlSetViewCols()+250]QTTLSView
- ORACLE ORA-00600之[kkoipt:incorrect pwj], [0], [0], [0], [2], [1], [1]Oracle
- Golang cannot take the address ofGolang
- 搞懂 TypeScript 中的對映型別（Mapped Types）TypeScript型別APP
- 13.there is no action mapped for namespace and action name associated with contAPPnamespace
- ORA-07445: exception encountered: (一)Exception
- ORA-07445錯誤分析
- Uncaught TypeError: Object [object Object] has no method 'xxx'ErrorObject
- Java Get local IP addressJava
- 組播地址Multicase address
- Mac address setting For RedhatMacRedhat
- struts2的異常There is no Action mapped for namespace / and action nameAPPnamespace
- objectObject
- java.lang.IllegalArgumentException: Mapped Statements collection does not contain value forJavaExceptionAPPAI
- oracle block phisical address to block#OracleBloC
- How to update the IP address of the SCAN VIP
- 介面返回[object,Object]解決方法Object
- Effective Object C 2.0 『熟悉Object C』Object