2012年(101)
分类: Oracle
2012-06-12 16:11:55
解决办法:
processes达到上限,增加processes初始化参数值
SQL> select count(*) from v$process;
COUNT(*)
----------
99
SQL> show parameter process;
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
processes integer 100
SQL> alter system set processes=300 scope=spfile;
System altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.