oracle 12.2.0.1 登录实例时报错 ORA-1092 : opitsk aborting process_ora1092导致数据库崩溃

作者：Monodyee | 2024-04-13 09:51:23

踩

ora1092导致数据库崩溃

os: centos 7.4
db: oracle 12.1.0.2

$ sqlplus / as sysdba;

SQL*Plus: Release 12.1.0.2.0 Production on Tue Jan 29 14:30:10 2019

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected.
SQL> 

1
2
3
4
5
6
7
8
9

查看 alert 日志后发现

$ tail -f /u01/app/oracle/diag/rdbms/orclp/orcl/trace/alert_orcl.log

Tue Jan 29 14:03:03 2019
ORA-1092 : opitsk aborting process
Tue Jan 29 14:03:19 2019
ORA-1092 : opitsk aborting process
Tue Jan 29 14:28:17 2019
ORA-1092 : opitsk aborting process
Tue Jan 29 14:28:39 2019
ORA-1092 : opitsk aborting process
Tue Jan 29 14:29:25 2019
ORA-1092 : opitsk aborting process
Tue Jan 29 14:29:40 2019
ORA-1092 : opitsk aborting process
Tue Jan 29 14:30:10 2019
ORA-1092 : opitsk aborting process

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

在 mos 上没找到啥有用的信息,重启机器后就正常了.

有点犯二了,不应该重启机器,继续找找原因.

参考:

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/Monodyee/article/detail/415725