- #alter.log 抛出错误
-
Fri Dec 30 11:08:53 2011
-
Errors in file /u01/app/oracle/admin/fujidb/udump/fujidb1_ora_4337.trc:
-
ORA-07445: exception encountered: core dump [kpoal8()+4702] [SIGSEGV] [Address not mapped to object] [0x000001130] [] []
-
Fri Dec 30 11:08:54 2011
-
Trace dumping is performing id=[cdmp_20111230110854]
-
Fri Dec 30 11:13:37 2011
-
Errors in file /u01/app/oracle/admin/fujidb/udump/fujidb1_ora_4339.trc:
-
ORA-07445: exception encountered: core dump [kpoal8()+4702] [SIGSEGV] [Address not mapped to object] [0x000001130] [] []
-
Fri Dec 30 11:13:38 2011
-
Trace dumping is performing id=[cdmp_20111230111338]
kpoal8()看网上介绍这个位置应该是个内部函数,连metalink搜索的时候都是"ora-7445 kpoal8"
- #less /u01/app/oracle/admin/fujidb/udump/fujidb1_ora_28716.trc
-
/u01/app/oracle/admin/fujidb/udump/fujidb1_ora_28716.trc
-
Oracle Database 10g Release 10.2.0.1.0 - 64bit Production
-
With the Real Application Clusters option
-
ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1
-
System name: Linux
-
Node name: node1
-
Release: 2.6.18-194.el5
-
Version: #1 SMP Tue Mar 16 21:52:39 EDT 2010
-
Machine: x86_64
-
Instance name: fujidb1
-
Redo thread mounted by this instance: 1
-
Oracle process number: 38
-
Unix process pid: 28716, image: oraclefujidb1@node1
-
*** 2011-12-30 22:37:15.068
-
*** SERVICE NAME:(fujidb) 2011-12-30 22:37:15.067
-
*** SESSION ID:(515.14) 2011-12-30 22:37:15.067
-
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x1130, PC: [0x22526d2, kpoal8()+4702]
-
*** 2011-12-30 22:37:15.090
-
ksedmp: internal or fatal error
-
ORA-07445: exception encountered: core dump [kpoal8()+4702] [SIGSEGV] [Address not mapped to object] [0x000001130] [] []
-
Current SQL statement for this session:
-
update T_NZL set NZLNAME=:b0:b1,NZLUSR=:b2:b3,NZLMDF=SYSDATE,NZLMID=:b4:b5,NZLMODULENO=:b6:b7,NZLSTNAME=:b8:b9,NZLSTID=:b10:b11,NZLSTNO=:b12:b13,NZLPITNO=:b14:b15 where NZLID=:b16:b17
-
----- 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() 000000001 ? 000000001 ?
-
000000000 ? 000000000 ?
-
000000000 ? 000000001 ?
-
ksedmp()+610 call ksedst() 000000001 ? 000000001 ?
-
000000000 ? 000000000 ?
-
000000000 ? 000000001 ?
-
s***hd()+630 call ksedmp() 000000003 ? 000000001 ?
-
000000000 ? 000000000 ?
-
000000000 ? 000000001 ?
-
<0x33c5e0eb10> call s***hd() 00000000B ? 2B59CA831D70 ?
-
2B59CA831C40 ? 000000000 ?
-
000000000 ? 000000001 ?
-
--------------------- Binary Stack Dump ---------------------
google了很多,很多都是说SQL引起的,看到这句Current SQL statement for this session:我也真信了,
但是转换一下,发现:
- Trace file: /u01/app/oracle/admin/fujidb/udump/fujidb1_ora_28716.trc
-
Sort options: default
-
********************************************************************************
-
count = number of times OCI procedure was executed
-
cpu = cpu time in seconds executing
-
elapsed = elapsed time in seconds executing
-
disk = number of physical reads of buffers from disk
-
query = number of buffers gotten for consistent read
-
current = number of buffers gotten in current mode (usually for update)
-
rows = number of rows processed by the fetch or execute call
-
********************************************************************************
-
Trace file: /u01/app/oracle/admin/fujidb/udump/fujidb1_ora_28716.trc
-
Trace file compatibility: 10.01.00
-
Sort options: default
-
-
1 session in tracefile.
-
0 user SQL statements in trace file.
-
0 internal SQL statements in trace file.
-
0 SQL statements in trace file.
-
0 unique SQL statements in trace file.
-
47163 lines in trace file.
-
0 elapsed seconds in trace file.
The stack from the ORA-7445 trace file looks similar to:"kpoal8 opiodr ttcpip opitsk opiino opiodr opidrv sou2o opimai_real main"
Solution is to upgrade the 9.2.x client to at least 9.2.0.4.0.
阅读(2000) | 评论(0) | 转发(0) |