ORA-00020 on sqlplus / as sysdba - No Background Process Exist - Cannot Restart Db Because Cannot Connect
(Doc ID 1671383.1)
Last updated on JANUARY 07, 2025
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.1 and laterOracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
bash-3.2$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Mon May 12 19:42:40 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
ERROR:
ORA-00020: maximum number of processes (600) exceeded
Enter user-name:
NO PROCESSES
-bash-3.2$ ps -ef | grep oracle | grep -v orcl
root 12761 12342 0 19:38 pts/2 00:00:00 su - oracle
oracle 12762 12761 0 19:38 pts/2 00:00:00 -bash
oracle 13631 12762 0 19:43 pts/2 00:00:00 ps -ef
oracle 13632 12762 0 19:43 pts/2 00:00:00 grep oracle
-bash-3.2$
Changes
Database crashed, unable to connect through sqlplus
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |