Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
Oracle数据库数据恢复、性能优化»论坛 › Oracle › Oracle数据库管理 › ora-6000,ora-7445,ora-00039
发新帖
wengtf

11

积分

0

好友

14

主题

[常规总体性能调优] ora-6000,ora-7445,ora-00039

1#
发表于 2013-1-7 09:49:23 | 查看: 5674| 回复: 5
oracle 11.2.01 on sun solaris10 sparc 64bit
问题也没法清楚描述，感觉有点想绑定变量引起的内存问题。论坛附件上传有点小问题，只能一会发你邮箱，刘大抽空帮忙看看
  1. ORA-00600: internal error code, arguments: [17147], [0xFFFFFFFF7AA77FB0], [], [], [], [], [], [], [], [], [], []
  2. ORA-07445: exception encountered: core dump [kghstack_err()+684] [SIGSEGV] [ADDR:0x4F4C444154452210] [PC:0x106B7980C] [Address not mapped to object] []
  3. ORA-00039: error during periodic action
复制代码
2#
发表于 2013-1-7 14:24:50
压缩后上传 请用7z

回复 只看该作者 道具 举报

3#
发表于 2013-1-7 14:28:51
  1. Trace file /ora/u01/oracle/diag/rdbms/cpoln01/cpoln01/trace/cpoln01_j000_4618.trc
  2. Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  3. With the Partitioning and Real Application Testing options
  4. ORACLE_HOME = /ora/u01/oracle/product/11.2/db_1
  5. System name:        SunOS
  6. Node name:        shadcpsora03
  7. Release:        5.10
  8. Version:        Generic_142900-13
  9. Machine:        sun4u
  10. Instance name: cpoln01
  11. Redo thread mounted by this instance: 1
  12. Oracle process number: 73
  13. Unix process pid: 4618, image: oracle@shadcpsora03 (J000)


  16. *** 2013-01-05 22:00:51.192
  17. *** SESSION ID:(879.4395) 2013-01-05 22:00:51.192
  18. *** CLIENT ID:() 2013-01-05 22:00:51.192
  19. *** SERVICE NAME:(SYS$USERS) 2013-01-05 22:00:51.192
  20. *** MODULE NAME:(DBMS_SCHEDULER) 2013-01-05 22:00:51.192
  21. *** ACTION NAME:(ORA$AT_SQ_SQL_SW_10828) 2013-01-05 22:00:51.192

  23.   status=(pst=TIMEOUT)
  24. **************************************************************
  25. Execution Statistics
  26.   Exec count:         0
  27.   CR gets:            220675
  28.   CU gets:            0
  29.   Disk Reads:         27727
  30.   Disk Writes:        0
  31.   IO Read Requests:   27593
  32.   IO Write Requests:  0
  33.   Bytes Read:         227139584
  34.   Bytes Written:      0
  35.   Bytes Exchanged with Storage:  227139584
  36.   Bytes Exchanged with Disk:  227139584
  37.   Bytes Simulated Read:  0
  38.   Bytes Simulated Returned:  0
  39.   Elapsed Time: 15 (s)
  40.   CPU Time: 8790 (ms)
  41.   User I/O Time: 7834 (ms)
  42.   status=(pst=ERROR)
  43.   status=(pst=ERROR)
  44.     error: pos=0, message follows:
  45. kestsDumpMsg(): dump message
  46. msg=(@=0xffffffff79fb2220, fac=ORA, cod=1476, p1=ORA-01476: divisor is equal to zero
  47. )

  49. *** 2013-01-05 22:01:04.191
  50. Incident 103063 created, dump file: /ora/u01/oracle/diag/rdbms/cpoln01/cpoln01/incident/incdir_103063/cpoln01_j000_4618_i103063.trc
  51. ORA-00600: internal error code, arguments: [17114], [0xFFFFFFFF7AA77FB0], [], [], [], [], [], [], [], [], [], []

  53. Incident 103064 created, dump file: /ora/u01/oracle/diag/rdbms/cpoln01/cpoln01/incident/incdir_103064/cpoln01_j000_4618_i103064.trc
  54. ORA-00600: internal error code, arguments: [17114], [0xFFFFFFFF7AA77FB0], [], [], [], [], [], [], [], [], [], []
  55. ORA-00600: internal error code, arguments: [17114], [0xFFFFFFFF7AA77FB0], [], [], [], [], [], [], [], [], [], []
复制代码
简单用一句话 描述

11.2.0.1 +　SunOS　　5.10　　ORA$AT_SQ_SQL_SW_10828自动作业遇到ORA-600[17114] ORA-07445 [kghstack_err()+684]

回复 只看该作者 道具 举报

4#
发表于 2013-1-7 16:17:14
本帖最后由 wengtf 于 2013-1-7 16:20 编辑

目前不清楚是这个自动作业触发的600和7445，还是因为600 导致这个作业无法正常跑完....因为cpoln01_j000_4618_i103063.trc里面有很多类似如下信息跟绑定变量有关，没啥思路：
  1. Trace Bucket Dump Begin: default bucket for process 73 (osid: 4618, J000)
  2. TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA
  3. -------------------------------------------------------------------------------
  4. 2013-01-05 22:00:50.004755*:SQL_Analyze:qksan.c@1186:qksanBindSql(): binding missing bind at pos=7
  5. 2013-01-05 22:00:50.004755*:SQL_Analyze:qksan.c@1186:qksanBindSql(): binding missing bind at pos=8
  6. 2013-01-05 22:00:50.004755*:SQL_Analyze:qksan.c@1186:qksanBindSql(): binding missing bind at pos=9
  7. 2013-01-05 22:00:50.004755*:SQL_Analyze:qksan.c@1186:qksanBindSql(): binding missing bind at pos=10
  8. 2013-01-05 22:00:50.004755*:SQL_Analyze:qksan.c@1186:qksanBindSql(): binding missing bind at pos=11
  9. 2013-01-05 22:00:50.004755*:SQL_Analyze:qksan.c@1186:qksanBindSql(): binding missing bind at pos=12
  10. 2013-01-05 22:00:50.004755*:SQL_Analyze:qksan.c@1186:qksanBindSql(): binding missing bind at pos=13
  11. 2013-01-05 22:00:50.004755*:SQL_Analyze:qksan.c@1186:qksanBindSql(): binding missing bind at pos=14
  12. 2013-01-05 22:00:50.004755*:SQL_Analyze:qksan.c@1186:qksanBindSql(): binding missing bind at pos=15
  13. 2013-01-05 22:00:50.004755*:SQL_Analyze:qksan.c@1186:qksanBindSql(): binding missing bind at pos=16
  14. 2013-01-05 22:00:50.004755*:SQL_Analyze:qksan.c@1186:qksanBindSql(): binding missing bind at pos=17
  15. 2013-01-05 22:00:50.004755*:SQL_Analyze:qksan.c@1186:qksanBindSql(): binding missing bind at pos=18
  16. 2013-01-05 22:00:50.004755*:SQL_Analyze:qksan.c@1186:qksanBindSql(): binding missing bind at pos=19
  17. 2013-01-05 22:00:50.004755*:SQL_Analyze:qksan.c@1186:qksanBindSql(): binding missing bind at pos=20
  18. 2013-01-05 22:00:50.004755*:SQL_Analyze:qksan.c@1186:qksanBindSql(): binding missing bind at pos=21
  19. 2013-01-05 22:00:50.004755*:SQL_Analyze:qksan.c@1186:qksanBindSql(): binding missing bind at pos=22
  20. 2013-01-05 22:00:50.004755*:SQL_Analyze:qksan.c@1186:qksanBindSql(): binding missing bind at pos=23
  21. 2013-01-05 22:00:50.004755*:SQL_Analyze:qksan.c@1186:qksanBindSql(): binding missing bind at pos=24
  22. 2013-01-05 22:00:50.004755*:SQL_Analyze:qksan.c@1186:qksanBindSql(): binding missing bind at pos=25
  23. 2013-01-05 22:00:50.004755*:SQL_Analyze:qksan.c@1186:qksanBindSql(): binding missing bind at pos=26
  24. 2013-01-05 22:00:50.004755*:SQL_Analyze:qksan.c@1186:qksanBindSql(): binding missing bind at pos=27
  25. 2013-01-05 22:00:50.004755*:SQL_Analyze:qksan.c@1186:qksanBindSql(): binding missing bind at pos=28
  26. 2013-01-05 22:00:50.004755*:SQL_Analyze:qksan.c@1186:qksanBindSql(): binding missing bind at pos=29
  27. 2013-01-05 22:00:50.004755*:SQL_Analyze:qksan.c@1186:qksanBindSql(): binding missing bind at pos=30
  28. 2013-01-05 22:00:50.004755*:SQL_Analyze:qksan.c@1186:qksanBindSql(): binding missing bind at pos=31
  29. 2013-01-05 22:00:50.004755*:SQL_Analyze:qksan.c@1348:qksanBindSql(end): Done binding: status=0 ret=0 bind#=59 byPos=1 wasBoundP=0xffffffff79c71c30 bindIndP=0xffffffff7a2f4aa8
  30. 2013-01-05 22:00:50.014784*:SQL_DS:qksds.c@2189:qksdsExeStmt(): caught error=907 tac=0xffffffff7a532500 tac_active=1 timeout=0
  31. 2013-01-05 22:00:50.014784*:SQL_DS:qksds.c@2253:qksdsExeStmt(): UNKNOWN ERROR code=907
  32. 2013-01-05 22:00:50.165078*:SQL_DS:qksds.c@2189:qksdsExeStmt(): caught error=907 tac=0xffffffff7a532500 tac_active=1 timeout=0
  33. 2013-01-05 22:00:50.165078*:SQL_DS:qksds.c@2253:qksdsExeStmt(): UNKNOWN ERROR code=907
  34. 2013-01-05 22:00:50.195138*:SQL_DS:qksds.c@2189:qksdsExeStmt(): caught error=907 tac=0xffffffff7a532500 tac_active=1 timeout=0
  35. ..........(此处省略)
  36. 2013-01-05 22:00:50.556235*:SQL_DS:qksds.c@2253:qksdsExeStmt(): UNKNOWN ERROR code=907
  37. 2013-01-05 22:00:50.586309*:SQL_DS:qksds.c@2189:qksdsExeStmt(): caught error=907 tac=0xffffffff7a532500 tac_active=1 timeout=0
  38. 2013-01-05 22:00:50.586309*:SQL_DS:qksds.c@2253:qksdsExeStmt(): UNKNOWN ERROR code=907
  39. 2013-01-05 22:00:50.626409*:SQL_Analyze:qksan.c@6342:qksanAvgExecStats(): The number of total executions: 0 and execution count: 0
  40. 2013-01-05 22:00:50.626409*:SQL_Analyze:qksan.c@4780:qksanPostAnalyzeDump(begin):   qksanPostAnalyzeDump(): Dumping analyze context after compilation  qksanStatus=SUCCESS ecode=10980
  41. 2013-01-05 22:00:50.626409*:SQL_Analyze:qksan.c@4800:qksanPostAnalyzeDump(end): 2013-01-05 22:00:50.626409*:SQL_Analyze:qksan.c@3691:qksanAnalyzeSql(end): exit: ecode=0 status=0
  42. 2013-01-05 22:00:51.193464 :9278138D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:73:879] KSL POST SENT postee=12 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name=   type=0
  43. 2013-01-05 22:00:51.194085 :92781390:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:73:879] KSL POST SENT postee=12 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name=   type=0
  44. 2013-01-05 22:00:51.231924 :927813B9:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:73:879] KSL POST SENT postee=12 loc='ksa2
复制代码

回复 只看该作者 道具 举报

5#
发表于 2013-1-7 19:34:58
17114 => libcache

17000        dict/libcache        this is the main library Cache manager. This Layer maintains the in memory representation of cached sql statements together will all the necessary support that this demands;



kghstack_err  kernel generic stack error

考虑禁用自动作业 automatic tuning advisor



BEGIN
dbms_auto_task_admin.disable(
    client_name => 'sql tuning advisor',
    operation   => NULL,
    window_name => NULL);
END;
/
select client_name,status from DBA_AUTOTASK_CLIENT where client_name='sql tuning advisor';

回复 只看该作者 道具 举报

6#
发表于 2013-1-9 09:52:50
本帖最后由 wengtf 于 2013-1-9 16:47 编辑

嗯。mos上一个欧美的工程师也是说 ：
ORA-00600[17114]/07445[KGHFREMPTY:DS]/07445[KGHALF] While Gathering Database Stats, After Upgrade From 11.1 To 11.2 (Doc ID 1195204.1)
Note: This is INTERNAL ONLY research. No action should be taken by the customer on this information. This is research only, and may NOT be applicable to your specific situation.

PS:
但是后面补充一句话说 disable Automatic Tuning Advisor until the upgrade is done to 11.2.0.3



回复 只看该作者 道具 举报

返回列表
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-26 14:28 , Processed in 0.047956 second(s), 20 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569