ORA-00020: maximum number of processes (150) exceeded
错误原因:连接数超过150的限制
解决方法:
1) 连接数据库
[oracle@rhel ~]$ sqlplus /nolog
SQL> conn /as sysdba
2) 查看参数
SQL> show parameter process;
NAME TYPE VALUE
------------------------------------ ----------- ---------
aq_tm_processes integer 0
cell_offload_processing boolean TRUE
db_writer_processes integer 1
gcs_server_processes integer 0
global_txn_processes integer 1
job_queue_processes integer 1000
log_archive_max_processes integer 4
processes integer 150
3) 修改参数
SQL> alter system set processes=500 scope = spfile;
SQL> create pfile from spfile;
4) 重启数据库
SQL> shutdown immediate
SQL> startup
5) 检查结果
SQL> show parameter process;
NAME TYPE VALUE
------------------------------------ ----------- -------
aq_tm_processes integer 0
cell_offload_processing boolean TRUE
db_writer_processes integer 1
gcs_server_processes integer 0
global_txn_processes integer 1
job_queue_processes integer 1000
log_archive_max_processes integer 4
processes integer 500
除非注明,戊辰人博客文章均为原创,转载请以链接形式标明本文地址