oracle连接数设置过大,导致oracle启动不了

做项目的时候一直报ORA-12520的错误,故更改oracle的连接数:

sqlplus sys/manager as sysdba

select COUNT(*) from v$process

select value from v$parameter where name = 'processes';

alter system set processes = 500 scope = spfile;

结果oracle启动不了了

启动oracle时:
SQL> startup
ORA-27154: post/wait create failed
ORA-27300: OS system dependent operation:semids_per_proc failed with status: 0
ORA-27301: OS failure message: Error 0
ORA-27302: failure occurred at: sskgpwcr2
ORA-27303: additional information: semids = 132, maxprocs = 20000

以下步骤即可。
1) sqlplus / as sysdba
2) create pfile='d:\pfile.ora' from spfile;
3) 修改d:\pfile.ora中的*.processes参数,比如改成*.processes=500
4)create spfile from pfile='d:\pfile.ora';
5)startup

参考:http://bbs.csdn.net/topics/390237436


以下是重启数据库:

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup;
ORACLE instance started.
Total System Global Area  269554828 bytes
                         Fixed Size   451724 bytes
                        Variable Size   234881024 bytes
                        Database Buffers  33554432 bytes
                        Redo Buffers   667648 bytes
Database mounted.
Database opened.


阅读更多
想对作者说点什么?

博主推荐

换一批

没有更多推荐了,返回首页