windows 上oracle 19.10 异常宕机
告警日志部分:
-
alter system archive log
-
2021-12-29t18:57:37.20007008:00
-
thread 1 advanced to log sequence 33630 (lgwr switch), current scn: 83213831
-
current log# 3 seq# 33630 mem# 0: d:\app\administrator\oradata\orcl\redo03.log
-
current log# 3 seq# 33630 mem# 1: d:\app\administrator\archivelog\redo03_1.log
-
2021-12-29t18:57:37.24695208:00
-
net (pid:6124): archived log entry 33629 added for t-1.s-33629 id 0x4c8aeee4 lad:1
-
2021-12-29t19:00:21.86158408:00
-
oracle clusterware infrastructure fatal error in oracle (os pid 3760_3704): internal error (id (:clsb00136:)) - failed to load core lsf package
-
2021-12-29t19:00:22.15847808:00
-
exception [type: abort_process_terminated, ] [] [pc:0x7ffd235b4f38, 00007ffd235b4f38]
-
errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_3704.trc (incident=176001):
-
ora-07445: exception encountered: core dump [pc:0x7ffd235b4f38] [abort_process_terminated] [] [pc:0x7ffd235b4f38] [] []
-
incident details in: d:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_176001\orcl_ora_3704_i176001.trc
-
use adrci or support workbench to package the incident.
-
see note 411.1 at my oracle support for error and packaging details.
-
2021-12-29t19:49:57.54330508:00
-
starting oracle instance (normal) (os id: 9056)
-
2021-12-29t19:49:58.13849108:00
-
all sga segments were allocated at startup
-
2021-12-29t19:50:01.56614408:00
-
license_max_session = 0
-
license_sessions_warning = 0
-
2021-12-29t19:50:01.70676808:00
-
initial number of cpu is 8
-
number of processor cores in the system is 8
-
number of processor sockets in the system is 2
-
capability type : network
-
capabilities requested : 7 detected : 0 simulated : 0
-
capability type : runtime environment
-
capabilities requested : 400000ff detected : 40000000 simulated : 0
-
capability type : engineered systems
-
capabilities requested : f detected : 0 simulated : 0
-
capability type : database test
-
capabilities requested : 3 detected : 0 simulated : 0
-
capability type : database editions
-
capabilities requested : c detected : 8 simulated : 0
-
autotune of undo retention is turned off.
-
imode=br
-
ilat =332
-
2021-12-29t19:50:02.69341808:00
-
license_max_users = 0
-
sys auditing is disabled
-
2021-12-29t19:50:02.86529608:00
-
note: remote asm mode is local (mode 0x1; from cluster type)
-
2021-12-29t19:50:07.32648708:00
-
note: using default asm root directory asm
-
note: remote asm mode is local (mode 0x1; from cluster type)
-
note: cluster configuration type = none [2]
-
oracle database 19c enterprise edition release 19.0.0.0.0 - production
-
version 19.10.0.0.0.
-
windows nt version v6.2
-
oracle_home = d:\app\administrator\product\19.3.0\dbhome_1
-
node name : db1
-
cpu : 8 - type 86648 physical cores
-
process affinity : 0x0000000000000000
-
memory (avail/total): ph:8193m/16383m, phpgf:4510m/35520m
-
vm name : vmware version (6)
-
using parameter settings in server-side spfile d:\app\administrator\product\19.3.0\dbhome_1\database\spfileorcl.ora
-
system parameters with non-default values:
-
processes = 2000
-
event = "18199537 trace name context forever, level 100"
-
nls_language = "simplified chinese"
-
nls_territory = "china"
-
filesystemio_options = "setall"
-
resource_manager_plan = ""
-
sga_target = 7456m
看起来好像是和ora-7445有关,看相关trc文件:
-
dump file d:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_176001\orcl_ora_3704_i176001.trc
-
oracle database 19c enterprise edition release 19.0.0.0.0 - production
-
version 19.10.0.0.0
-
build label: rdbms_19.10.0.0.0dbru_windows.x64_210115
-
windows nt version v6.2
-
oracle_home = d:\app\administrator\product\19.3.0\dbhome_1
-
node name : db1
-
cpu : 8 - type 86648 physical cores
-
process affinity : 0x0000000000000000
-
memory (avail/total): ph:997m/16383m, phpgf:158m/35520m
-
vm name : vmware version (6)
-
storage: ?
-
instance name: orcl
-
redo thread mounted by this instance: 0 <none>
-
oracle process number: 0
-
windows thread id: 3704, image:
-
-
-
*** 2021-12-29t19:00:22.69212508:00
-
[toc00000]
-
jump to table of contents
-
dump continued from file: d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_3704.trc
-
[toc00001]
-
ora-07445: exception encountered: core dump [pc:0x7ffd235b4f38] [abort_process_terminated] [] [pc:0x7ffd235b4f38] [] []
-
-
[toc00001-end]
-
[toc00002]
-
========= dump for incident 176001 (ora 7445 [pc:0x7ffd235b4f38]) ========
-
[toc00003]
-
----- beginning of customized incident dump(s) -----
-
exception [type: abort_process_terminated, ] [] [pc:0x7ffd235b4f38, 00007ffd235b4f38]
-
-
oracle database 19c enterprise edition release 19.0.0.0.0 - production
-
process id: 0x00000eb0 thread id : 0x00000e78 time : wed dec 29 19:00:22
-
excp. code: 0xebf00bab excp. type: abort_proc flags: 0x00000000
-
-
------------------- registers ----------------------------
-
rip=00007ffd235b4f38
-
rax=0047004600450044 rcx=004b004a00490048 rdx=004f004e004d004c
-
rbx=0000000000000016 rsp=000001b648089890 rbp=000001b648089990
-
rsi=0000000000000000 rdi=0000000000070001 r8=0020002000200020
-
r9=0020002000200020 r10=0020002000200020 r11=0020002000200020
-
r12=00007ffd24065f60 r13=0000000000000000 r14=0000000000000910
-
r15=00007ff7d56a3470
-
segcs = 00000033 segds = 0000002b seges = 0000002b
-
segfs = 00000053 seggs = 0000002b segss = 0000002b
-
eflags = 00000206
-
register rip=00007ffd235b4f38 dump of bytes
-
省略看不懂部分。。。
-
-
------------------- end of registers ---------------------
-
-
-
*** 2021-12-29t19:00:22.75462908:00
-
dbkeddefdump(): starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)
-
[toc00004]
-
----- sql statement (none) -----
-
current sql information unavailable - no sga.
-
[toc00004-end]
-
----------- messages from pre-loading .sym files:
-
symbol file d:\app\administrator\product\19.3.0\dbhome_1\rdbms\admin\orasql19.sym does not match binary.
-
symbol timestamp=5cef5a1d, module timestamp=600bacab are different
-
----------- end of messages from pre-loading .sym files
-
[toc00005]
-
----- call stack trace -----
-
calling call entry argument values in hex
-
location type point (? means dubious value)
-
-------------------- -------- -------------------- ----------------------------
-
symbol file d:\app\administrator\product\19.3.0\dbhome_1\bin\orasql19.sym does not match binary.
-
symbol timestamp=5cef5a1d, module timestamp=600bacab are different
-
00007ffd235b4f38 0000000000000000 000000101 ? 7ffd100801d0 ?
-
1b64806b0e8 ? 1b64806b1b0 ?
-
orasigabrthandler() call??? 00007ffd235b4ed0 ffffffffebf00bab 000000000
-
45 000000000 ? 000000000 ?
-
00007ffd23fecfa7 call??? orasigabrthandler() 000000016 000000000 ?
-
000000000 ? 000000000 ?
-
00007ffd23fede31 call??? 00007ffd23fecdc0 000000000 ? 000000000 ?
-
000000000 ? 000000000 ?
-
clsbabort()208 call??? 00007ffd23fede00 000000000 ? 000000000 ?
-
000000000 ? 000000000 ?
-
clsbprocessinit()2 call??? clsbabort() 000000000 065746e49 072726520
-
419 028204449
-
clsbcinit()420 call??? clsbprocessinit() 000000006 000000007
-
000000000 ? 000000000 ?
-
opiinit()417 call??? clsbcinit() 005d7e850 03a2896b0
-
ffffffffd553e7b0 000000000
-
opimai_real()255 call??? opiinit() 000000000 ? 000000000 ?
-
000000000 ? 000000000 ?
-
opimai()268 call??? opimai_real() 04808fd2d ffffffffffffffff
-
000000000 ? 000000000 ?
-
oraclethreadstart() call??? opimai() 000000002 04808fe60 05c149c10
-
643 000000000 ?
-
00007ffd249784d4 call??? oraclethreadstart() 000000000 000000000 ?
-
000000000 ? 000000000 ?
-
00007ffd27071791 call??? 00007ffd249784c0 000000000 ? 000000000 ?
-
000000000 ? 000000000 ?
-
[toc00005-end]
还是不明确原因啊,看看具体trc
-
trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_3704.trc
-
oracle database 19c enterprise edition release 19.0.0.0.0 - production
-
version 19.10.0.0.0
-
build label: rdbms_19.10.0.0.0dbru_windows.x64_210115
-
windows nt version v6.2
-
oracle_home = d:\app\administrator\product\19.3.0\dbhome_1
-
node name : db1
-
cpu : 8 - type 86648 physical cores
-
process affinity : 0x0000000000000000
-
memory (avail/total): ph:1061m/16383m, phpgf:339m/35520m
-
vm name : vmware version (6)
-
instance name: orcl
-
redo thread mounted by this instance: 1
-
oracle process number: 0
-
windows thread id: 3704, image:
-
-
-
*** 2021-12-29t08:25:28.36208308:00
-
required ipc rdmav_fork_safe environment not set
-
required ipc rdmav_hugepages_safe environment not set
-
trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_3704.trc
-
oracle database 19c enterprise edition release 19.0.0.0.0 - production
-
version 19.10.0.0.0
-
build label: rdbms_19.10.0.0.0dbru_windows.x64_210115
-
windows nt version v6.2
-
oracle_home = d:\app\administrator\product\19.3.0\dbhome_1
-
node name : db1
-
cpu : 8 - type 86648 physical cores
-
process affinity : 0x0000000000000000
-
memory (avail/total): ph:1005m/16383m, phpgf:168m/35520m
-
vm name : vmware version (6)
-
storage: ?
-
instance name: orcl
-
redo thread mounted by this instance: 0 <none>
-
oracle process number: 0
-
windows thread id: 3704, image:
-
-
-
*** 2021-12-29t19:00:21.97097408:00
-
symbol file d:\app\administrator\product\19.3.0\dbhome_1\bin\orasql19.sym does not match binary.
-
symbol timestamp=5cef5a1d, module timestamp=600bacab are different
-
exception [type: abort_process_terminated, ] [] [pc:0x7ffd235b4f38, 00007ffd235b4f38]
-
-
symbol file d:\app\administrator\product\19.3.0\dbhome_1\bin\orasql19.sym does not match binary.
-
symbol timestamp=5cef5a1d, module timestamp=600bacab are different
-
dde: flood control is not active
-
2021-12-29t19:00:22.67650208:00
-
incident 176001 created, dump file: d:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_176001\orcl_ora_3704_i176001.trc
-
ora-07445: exception encountered: core dump [pc:0x7ffd235b4f38] [abort_process_terminated] [] [pc:0x7ffd235b4f38] [] []
符号文件找不到,也没多大关系,不影响数据库运行,看来这些都是现象。
阅读(1239) | 评论(0) | 转发(0) |