Chinaunix首页 | 论坛 | 博客

沧海拾贝brjl.blog.chinaunix.net

首页　| 　博文目录　| 　关于我

brjl

  • 博客访问： 3556367
  • 博文数量： 715
  • 博客积分： 1860
  • 博客等级： 上尉
  • 技术积分： 7745
  • 用 户 组： 普通用户
  • 注册时间： 2008-04-07 08:51
个人简介

偶尔有空上来看看

文章分类

全部博文（715）

文章存档

2023年（75）

2022年（134）

2021年（238）

2020年（115）

2019年（11）

2018年（9）

2017年（9）

2016年（17）

2015年（7）

2014年（4）

2013年（1）

2012年（11）

2011年（27）

2010年（35）

2009年（11）

2008年（11）

我的朋友
最近访客
推荐博文
相关博文
凑个数 windows异常宕机，与ora-7445 ABORT_PROCESS_TERMINATED

分类： Oracle

2021-12-30 12:22:02

windows 上oracle 19.10 异常宕机
告警日志部分：

  1. ALTER SYSTEM ARCHIVE LOG
  2. 2021-12-29T18:57:37.200070+08:00
  3. Thread 1 advanced to log sequence 33630 (LGWR switch), current SCN: 83213831
  4.   Current log# 3 seq# 33630 mem# 0: D:\APP\ADMINISTRATOR\ORADATA\orcl\REDO03.LOG
  5.   Current log# 3 seq# 33630 mem# 1: D:\APP\ADMINISTRATOR\ARCHIVELOG\REDO03_1.LOG
  6. 2021-12-29T18:57:37.246952+08:00
  7. NET (PID:6124): Archived Log entry 33629 added for T-1.S-33629 ID 0x4c8aeee4 LAD:1
  8. 2021-12-29T19:00:21.861584+08:00
  9. Oracle Clusterware infrastructure fatal error in ORACLE (OS PID 3760_3704): Internal error (ID (:CLSB00136:)) - Failed to load CORE LSF package
  10. 2021-12-29T19:00:22.158478+08:00
  11. Exception [type: ABORT_PROCESS_TERMINATED, ] [] [PC:0x7FFD235B4F38, 00007FFD235B4F38]
  12. Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_ora_3704.trc (incident=176001):
  13. ORA-07445: exception encountered: core dump [PC:0x7FFD235B4F38] [ABORT_PROCESS_TERMINATED] [] [PC:0x7FFD235B4F38] [] []
  14. Incident details in: D:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\incident\incdir_176001\orcl_ora_3704_i176001.trc
  15. Use ADRCI or Support Workbench to package the incident.
  16. See Note 411.1 at My Oracle Support for error and packaging details.
  17. 2021-12-29T19:49:57.543305+08:00
  18. Starting ORACLE instance (normal) (OS id: 9056)
  19. 2021-12-29T19:49:58.138491+08:00
  20. All SGA segments were allocated at startup
  21. 2021-12-29T19:50:01.566144+08:00
  22. LICENSE_MAX_SESSION = 0
  23. LICENSE_SESSIONS_WARNING = 0
  24. 2021-12-29T19:50:01.706768+08:00
  25. Initial number of CPU is 8
  26. Number of processor cores in the system is 8
  27. Number of processor sockets in the system is 2
  28. Capability Type : Network
  29. capabilities requested : 7 detected : 0 Simulated : 0
  30. Capability Type : Runtime Environment
  31. capabilities requested : 400000FF detected : 40000000 Simulated : 0
  32. Capability Type : Engineered Systems
  33. capabilities requested : F detected : 0 Simulated : 0
  34. Capability Type : Database Test
  35. capabilities requested : 3 detected : 0 Simulated : 0
  36. Capability Type : Database Editions
  37. capabilities requested : C detected : 8 Simulated : 0
  38. Autotune of undo retention is turned off.
  39. IMODE=BR
  40. ILAT =332
  41. 2021-12-29T19:50:02.693418+08:00
  42. LICENSE_MAX_USERS = 0
  43. SYS auditing is disabled
  44. 2021-12-29T19:50:02.865296+08:00
  45. NOTE: remote asm mode is local (mode 0x1; from cluster type)
  46. 2021-12-29T19:50:07.326487+08:00
  47. NOTE: Using default ASM root directory ASM
  48. NOTE: remote asm mode is local (mode 0x1; from cluster type)
  49. NOTE: Cluster configuration type = NONE [2]
  50. Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
  51. Version 19.10.0.0.0.
  52. Windows NT Version V6.2
  53. ORACLE_HOME = D:\app\administrator\product\19.3.0\dbhome_1
  54. Node name : db1
  55. CPU : 8 - type 86648 physical cores
  56. Process Affinity : 0x0000000000000000
  57. Memory (Avail/Total): Ph:8193M/16383M, Ph+PgF:4510M/35520M
  58. VM name : VMWare Version (6)
  59. Using parameter settings in server-side spfile D:\APP\ADMINISTRATOR\PRODUCT\19.3.0\DBHOME_1\DATABASE\SPFILEorcl.ORA
  60. System parameters with non-default values:
  61.   processes = 2000
  62.   event = "18199537 trace name context forever, level 100"
  63.   nls_language = "SIMPLIFIED CHINESE"
  64.   nls_territory = "CHINA"
  65.   filesystemio_options = "setall"
  66.   resource_manager_plan = ""
  67.   sga_target = 7456M
看起来好像是和ora-7445有关，看相关trc文件：
  1. Dump file D:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\incident\incdir_176001\orcl_ora_3704_i176001.trc
  2. Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
  3. Version 19.10.0.0.0
  4. Build label: RDBMS_19.10.0.0.0DBRU_WINDOWS.X64_210115
  5. Windows NT Version V6.2
  6. ORACLE_HOME = D:\app\administrator\product\19.3.0\dbhome_1
  7. Node name : db1
  8. CPU : 8 - type 86648 physical cores
  9. Process Affinity : 0x0000000000000000
  10. Memory (Avail/Total): Ph:997M/16383M, Ph+PgF:158M/35520M
  11. VM name : VMWare Version (6)
  12. Storage:    ?
  13. Instance name: orcl
  14. Redo thread mounted by this instance: 0 <none>
  15. Oracle process number: 0
  16. Windows thread id: 3704, image:


  19. *** 2021-12-29T19:00:22.692125+08:00
  20. [TOC00000]
  21. Jump to table of contents
  22. Dump continued from file: D:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_ora_3704.trc
  23. [TOC00001]
  24. ORA-07445: exception encountered: core dump [PC:0x7FFD235B4F38] [ABORT_PROCESS_TERMINATED] [] [PC:0x7FFD235B4F38] [] []

  26. [TOC00001-END]
  27. [TOC00002]
  28. ========= Dump for incident 176001 (ORA 7445 [PC:0x7FFD235B4F38]) ========
  29. [TOC00003]
  30. ----- Beginning of Customized Incident Dump(s) -----
  31. Exception [type: ABORT_PROCESS_TERMINATED, ] [] [PC:0x7FFD235B4F38, 00007FFD235B4F38]

  33. Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
  34. Process Id: 0x00000eb0 Thread Id : 0x00000e78 Time : Wed Dec 29 19:00:22
  35. Excp. Code: 0xebf00bab Excp. Type: ABORT_PROC Flags: 0x00000000

  37. ------------------- Registers ----------------------------
  38. Rip=00007FFD235B4F38
  39. Rax=0047004600450044 Rcx=004B004A00490048 Rdx=004F004E004D004C
  40. Rbx=0000000000000016 Rsp=000001B648089890 Rbp=000001B648089990
  41. Rsi=0000000000000000 Rdi=0000000000070001 R8=0020002000200020
  42. R9=0020002000200020 R10=0020002000200020 R11=0020002000200020
  43. R12=00007FFD24065F60 R13=0000000000000000 R14=0000000000000910
  44. R15=00007FF7D56A3470
  45. SegCs = 00000033 SegDs = 0000002b SegEs = 0000002b
  46. SegFs = 00000053 SegGs = 0000002b SegSs = 0000002b
  47. EFlags = 00000206
  48. Register Rip=00007FFD235B4F38 Dump of bytes
  49. 省略看不懂部分。。。

  51. ------------------- End of Registers ---------------------


  54. *** 2021-12-29T19:00:22.754629+08:00
  55. dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)
  56. [TOC00004]
  57. ----- SQL Statement (None) -----
  58. Current SQL information unavailable - no SGA.
  59. [TOC00004-END]
  60. ----------- messages from pre-loading .sym files:
  61. Symbol file D:\app\administrator\product\19.3.0\dbhome_1\RDBMS\ADMIN\orasql19.SYM does not match binary.
  62.  Symbol TimeStamp=5cef5a1d, Module TimeStamp=600bacab are different
  63. ----------- end of messages from pre-loading .sym files
  64. [TOC00005]
  65. ----- Call Stack Trace -----
  66. calling call entry argument values in hex
  67. location type point (? means dubious value)
  68. -------------------- -------- -------------------- ----------------------------
  69. Symbol file D:\app\administrator\product\19.3.0\dbhome_1\BIN\orasql19.SYM does not match binary.
  70.  Symbol TimeStamp=5cef5a1d, Module TimeStamp=600bacab are different
  71. 00007FFD235B4F38 0000000000000000 000000101 ? 7FFD100801D0 ?
  72.                                                    1B64806B0E8 ? 1B64806B1B0 ?
  73. OraSigabrtHandler() CALL??? 00007FFD235B4ED0 FFFFFFFFEBF00BAB 000000000
  74. +45 000000000 ? 000000000 ?
  75. 00007FFD23FECFA7 CALL??? OraSigabrtHandler() 000000016 000000000 ?
  76.                                                    000000000 ? 000000000 ?
  77. 00007FFD23FEDE31 CALL??? 00007FFD23FECDC0 000000000 ? 000000000 ?
  78.                                                    000000000 ? 000000000 ?
  79. clsbAbort()+208 CALL??? 00007FFD23FEDE00 000000000 ? 000000000 ?
  80.                                                    000000000 ? 000000000 ?
  81. clsbProcessInit()+2 CALL??? clsbAbort() 000000000 065746E49 072726520
  82. 419 028204449
  83. clsbCInit()+420 CALL??? clsbProcessInit() 000000006 000000007
  84.                                                    000000000 ? 000000000 ?
  85. opiinit()+417 CALL??? clsbCInit() 005D7E850 03A2896B0
  86.                                                    FFFFFFFFD553E7B0 000000000
  87. opimai_real()+255 CALL??? opiinit() 000000000 ? 000000000 ?
  88.                                                    000000000 ? 000000000 ?
  89. opimai()+268 CALL??? opimai_real() 04808FD2D FFFFFFFFFFFFFFFF
  90.                                                    000000000 ? 000000000 ?
  91. OracleThreadStart() CALL??? opimai() 000000002 04808FE60 05C149C10
  92. +643 000000000 ?
  93. 00007FFD249784D4 CALL??? OracleThreadStart() 000000000 000000000 ?
  94.                                                    000000000 ? 000000000 ?
  95. 00007FFD27071791 CALL??? 00007FFD249784C0 000000000 ? 000000000 ?
  96.                                                    000000000 ? 000000000 ?
  97. [TOC00005-END]
还是不明确原因啊，看看具体trc

  1. Trace file D:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_ora_3704.trc
  2. Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
  3. Version 19.10.0.0.0
  4. Build label: RDBMS_19.10.0.0.0DBRU_WINDOWS.X64_210115
  5. Windows NT Version V6.2
  6. ORACLE_HOME = D:\app\administrator\product\19.3.0\dbhome_1
  7. Node name : db1
  8. CPU : 8 - type 86648 physical cores
  9. Process Affinity : 0x0000000000000000
  10. Memory (Avail/Total): Ph:1061M/16383M, Ph+PgF:339M/35520M
  11. VM name : VMWare Version (6)
  12. Instance name: orcl
  13. Redo thread mounted by this instance: 1
  14. Oracle process number: 0
  15. Windows thread id: 3704, image:


  18. *** 2021-12-29T08:25:28.362083+08:00
  19. Required IPC RDMAV_FORK_SAFE environment not set
  20. Required IPC RDMAV_HUGEPAGES_SAFE environment not set
  21. Trace file D:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_ora_3704.trc
  22. Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
  23. Version 19.10.0.0.0
  24. Build label: RDBMS_19.10.0.0.0DBRU_WINDOWS.X64_210115
  25. Windows NT Version V6.2
  26. ORACLE_HOME = D:\app\administrator\product\19.3.0\dbhome_1
  27. Node name : db1
  28. CPU : 8 - type 86648 physical cores
  29. Process Affinity : 0x0000000000000000
  30. Memory (Avail/Total): Ph:1005M/16383M, Ph+PgF:168M/35520M
  31. VM name : VMWare Version (6)
  32. Storage:    ?
  33. Instance name: orcl
  34. Redo thread mounted by this instance: 0 <none>
  35. Oracle process number: 0
  36. Windows thread id: 3704, image:


  39. *** 2021-12-29T19:00:21.970974+08:00
  40. Symbol file D:\app\administrator\product\19.3.0\dbhome_1\BIN\orasql19.SYM does not match binary.
  41.  Symbol TimeStamp=5cef5a1d, Module TimeStamp=600bacab are different
  42. Exception [type: ABORT_PROCESS_TERMINATED, ] [] [PC:0x7FFD235B4F38, 00007FFD235B4F38]

  44. Symbol file D:\app\administrator\product\19.3.0\dbhome_1\BIN\orasql19.SYM does not match binary.
  45.  Symbol TimeStamp=5cef5a1d, Module TimeStamp=600bacab are different
  46. DDE: Flood control is not active
  47. 2021-12-29T19:00:22.676502+08:00
  48. Incident 176001 created, dump file: D:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\incident\incdir_176001\orcl_ora_3704_i176001.trc
  49. ORA-07445: exception encountered: core dump [PC:0x7FFD235B4F38] [ABORT_PROCESS_TERMINATED] [] [PC:0x7FFD235B4F38] [] []
符号文件找不到，也没多大关系，不影响数据库运行，看来这些都是现象。

阅读(1406) | 评论(0) | 转发(0) |
0

上一篇：来吧，cursor: pin S wait on X

下一篇：年底了，分区扩了吗，ORA-14074 如何拆分

给主人留下些什么吧！~~
关于我们 | 关于IT168 | 联系方式 | 广告合作 | 法律声明 | 免费注册

Copyright 2001-2010 ChinaUnix.net All Rights Reserved 北京皓辰网域网络信息技术有限公司. 版权所有

感谢所有关心和支持过ChinaUnix的朋友们

16024965号-6