ORA-00020和ORA-00603报错处理

GottdesKrieges

已于 2025-01-10 23:18:47 修改

阅读量517

点赞数

CC 4.0 BY-SA版权

分类专栏： Oracle实践篇（二）文章标签：数据库 SQL

于 2024-11-05 22:25:07 首次发布

本文链接：https://blog.youkuaiyun.com/Sebastien23/article/details/143530181

Oracle实践篇（二）专栏收录该内容

51 篇文章 ¥19.90 ¥99.00

订阅专栏

ORA-00020和ORA-00603报错处理

问题现象
解决办法

问题现象

现象：数据库进程仍在，但无法正常连接。

[oracle@dbhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Nov 1 09:51:30 2024
Version 19.8.0.0.0

Copyright (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 process unknown ospid (4730) as

了解本专栏