SQL*Plus: Release 11.2.0.4.0 Production on Tue Jun 16 15:22:07 2020
Copyright (c) 1982, 2013, Oracle. All rights reserved.
此时就可以正常关闭和开启数据库,按照如下命令操作解决问题:
1 2 3 4 5 6 7
SQL> shutdown immediate; SQL> startup; SQL> show parameter processes; SQL> alter system set processes=1000 scope=spfile; SQL> startup force; SQL> show parameter processes; SQL> exit;
2.启动实例
1 2 3 4 5 6 7 8 9
SQL> startup ORACLE instance started. ORA-01012: not logged on Process ID: 0 Session ID: 0 Serial number: 0
SQL*Plus: Release 11.2.0.4.0 Production on Tue Jun 16 15:22:35 2020
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show parameter process
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ aq_tm_processes integer 1 cell_offload_processing boolean TRUE db_writer_processes integer 2 gcs_server_processes integer 0 global_txn_processes integer 1 job_queue_processes integer 1000 log_archive_max_processes integer 4 processes integer 150 processor_group_name string SQL> select status from v$instance;
STATUS ------------ STARTED
SQL> alter system set processes=1000 scope=spfile;
System altered.
SQL> shutdown immediate; ORA-01507: database not mounted
ORACLE instance shut down. SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-00020: maximum number of processes (150) exceeded
[oracle@db ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Tue Jun 16 15:16:06 2020Copyright (c) 1982, 2013, Oracle. All rights reserved.ERROR:ORA-00020: maximum number of processes (150) exceeded方法1:更改processes参数解决 ORA-00020 错误,.