Chinaunix首页 | 论坛 | 博客
  • 博客访问: 3214792
  • 博文数量: 710
  • 博客积分: 14546
  • 博客等级: 上将
  • 技术积分: 6738
  • 用 户 组: 普通用户
  • 注册时间: 2007-03-30 10:20
文章分类

全部博文(710)

文章存档

2016年(1)

2014年(7)

2013年(22)

2012年(227)

2011年(322)

2009年(119)

2008年(12)

分类: Oracle

2011-12-31 14:35:21

  1. #alter.log 抛出错误
  2. Fri Dec 30 11:08:53 2011
  3. Errors in file /u01/app/oracle/admin/fujidb/udump/fujidb1_ora_4337.trc:
  4. ORA-07445: exception encountered: core dump [kpoal8()+4702] [SIGSEGV] [Address not mapped to object] [0x000001130] [] []
  5. Fri Dec 30 11:08:54 2011
  6. Trace dumping is performing id=[cdmp_20111230110854]
  7. Fri Dec 30 11:13:37 2011
  8. Errors in file /u01/app/oracle/admin/fujidb/udump/fujidb1_ora_4339.trc:
  9. ORA-07445: exception encountered: core dump [kpoal8()+4702] [SIGSEGV] [Address not mapped to object] [0x000001130] [] []
  10. Fri Dec 30 11:13:38 2011
  11. Trace dumping is performing id=[cdmp_20111230111338]
kpoal8()看网上介绍这个位置应该是个内部函数,连metalink搜索的时候都是"ora-7445 kpoal8"
  1. #less /u01/app/oracle/admin/fujidb/udump/fujidb1_ora_28716.trc
  2. /u01/app/oracle/admin/fujidb/udump/fujidb1_ora_28716.trc
  3. Oracle Database 10g Release 10.2.0.1.0 - 64bit Production
  4. With the Real Application Clusters option
  5. ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1
  6. System name: Linux
  7. Node name: node1
  8. Release: 2.6.18-194.el5
  9. Version: #1 SMP Tue Mar 16 21:52:39 EDT 2010
  10. Machine: x86_64
  11. Instance name: fujidb1
  12. Redo thread mounted by this instance: 1
  13. Oracle process number: 38
  14. Unix process pid: 28716, image: oraclefujidb1@node1
  15. *** 2011-12-30 22:37:15.068
  16. *** SERVICE NAME:(fujidb) 2011-12-30 22:37:15.067
  17. *** SESSION ID:(515.14) 2011-12-30 22:37:15.067
  18. Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x1130, PC: [0x22526d2, kpoal8()+4702]
  19. *** 2011-12-30 22:37:15.090
  20. ksedmp: internal or fatal error
  21. ORA-07445: exception encountered: core dump [kpoal8()+4702] [SIGSEGV] [Address not mapped to object] [0x000001130] [] []
  22. Current SQL statement for this session:
  23. 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
  24. ----- Call Stack Trace -----
  25. calling call entry argument values in hex
  26. location type point (? means dubious value)
  27. -------------------- -------- -------------------- ----------------------------
  28. Cannot find symbol
  29. Cannot find symbol
  30. Cannot find symbol
  31. ksedst()+31 call ksedst1() 000000001 ? 000000001 ?
  32. 000000000 ? 000000000 ?
  33. 000000000 ? 000000001 ?
  34. ksedmp()+610 call ksedst() 000000001 ? 000000001 ?
  35. 000000000 ? 000000000 ?
  36. 000000000 ? 000000001 ?
  37. s***hd()+630 call ksedmp() 000000003 ? 000000001 ?
  38. 000000000 ? 000000000 ?
  39. 000000000 ? 000000001 ?
  40. <0x33c5e0eb10> call s***hd() 00000000B ? 2B59CA831D70 ?
  41. 2B59CA831C40 ? 000000000 ?
  42. 000000000 ? 000000001 ?
  43. --------------------- Binary Stack Dump ---------------------
google了很多,很多都是说SQL引起的,看到这句Current SQL statement for this session:我也真信了,
但是转换一下,发现:
  1. Trace file: /u01/app/oracle/admin/fujidb/udump/fujidb1_ora_28716.trc
  2. Sort options: default
  3. ********************************************************************************
  4. count = number of times OCI procedure was executed
  5. cpu = cpu time in seconds executing
  6. elapsed = elapsed time in seconds executing
  7. disk = number of physical reads of buffers from disk
  8. query = number of buffers gotten for consistent read
  9. current = number of buffers gotten in current mode (usually for update)
  10. rows = number of rows processed by the fetch or execute call
  11. ********************************************************************************
  12. Trace file: /u01/app/oracle/admin/fujidb/udump/fujidb1_ora_28716.trc
  13. Trace file compatibility: 10.01.00
  14. Sort options: default

  15. 1 session in tracefile.
  16. 0 user SQL statements in trace file.
  17. 0 internal SQL statements in trace file.
  18. 0 SQL statements in trace file.
  19. 0 unique SQL statements in trace file.
  20. 47163 lines in trace file.
  21. 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) |
给主人留下些什么吧!~~