Chinaunix首页 | 论坛 | 博客
  • 博客访问: 2669778
  • 博文数量: 570
  • 博客积分: 1860
  • 博客等级: 上尉
  • 技术积分: 6259
  • 用 户 组: 普通用户
  • 注册时间: 2008-04-07 08:51
个人简介

偶尔有空上来看看

文章分类

全部博文(570)

文章存档

2022年(63)

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)

分类: 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:


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

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

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

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

  45. ------------------- End of Registers ---------------------


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


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


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

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

阅读(248) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~