连接数量满导致数据库连接不上问题

连接数据库报错ora-12514

检查数据库进程是正常的

查看alter日志

Process P007 died, see its trace file
Fri Mar 12 15:08:38 2010
Process P006 died, see its trace file
Fri Mar 12 15:30:24 2010
Process P005 died, see its trace file

 

查看trace文件

ORA-00020: maximum number of processes 150 exceeded
Died during process startup with error 20 (seq=2979)
OPIRIP: Uncaught error 20. Error stack:
ORA-00020: maximum number of processes (150) exceeded

发现是连接数满了

 

export oracle_sid=mytest

sqlplus / as sysdba

alter system set processes=500 scope=spfile;

shutdown immediate

startup

即ok了