小白今天在登录数据库的时候,悲剧了,被挡在门外了:
oracle@wu101:~> !sql
sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 15 17:02:06 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ERROR:
ORA-00020: maximum number of processes (150) exceeded
Enter user-name: sys
Enter password:
ERROR:
ORA-00020: maximum number of processes (150) exceeded
Enter user-name: sys
Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
小白抓耳挠腮了一会,果断让同事把相关进程给杀了,小白终于可以进去了,在网上搜了一圈,解决办法如下:
oracle@wu101:~> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 15 17:07:40 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show parameter processes;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 1
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
SQL> alter system set processes=1500 scope = spfile;
System altered.
SQL> commit;
Commit complete.
SQL> shutdown abort # 这个命令慎重执行,若是在生产环境下,还是用"shutdown immediate"比较好,小白是自己的环境,才如此暴力强制下线的。
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1603411968 bytes
Fixed Size 2228784 bytes
Variable Size 1073745360 bytes
Database Buffers 520093696 bytes
Redo Buffers 7344128 bytes
Database mounted.
Database opened.
SQL> show parameter processes;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 1
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 1500
SQL> OK