ORA-00020和ORA-00603报错处理
ORA-00020和ORA-00603报错处理
- 问题现象
- 解决办法
问题现象
现象:数据库进程仍在,但无法正常连接。
[oracle@dbhost ~]$ sqlplus / as sysdbaSQL*Plus: Release 19.0.0.0.0 - Production on Fri Nov 1 09:51:30 2024
Version 19.8.0.0.0Copyright (c) 1982, 2020, Oracle. All rights reserved.Connected.
ERROR:
ORA-01012: not logged on
Process ID: 0
Session ID: 0 Serial number: 0
检查告警日志:
Errors in file /oracle/app/diag/rdbms/ora19c/ora19c/trace/ora19c_ora_4730.trc (incident=44006):
ORA-00603: ORACLE server session terminated by fatal error
ORA-00020: maximum number of processes () exceeded
Incident details in: /oracle/app/diag/rdbms/ora19c/ora19c/incident/incdir_44006/ora19c_ora_4730_i44006.trc
2024-11-01T09:51:12.995863+08:00
opiodr aborting