process设置过小,用sqlplus执行startup时提示:ORA-03113: 通信通道的文件结束.再执行任意命令,提示:oracle not aviable.其实就是oracle实例没启动起来.打开alert_orcl.log,可以看到ORA-00020: maximum number of processes (150) exceeded.
既然知道了问题,就开始解决.
1.重新用sqlplus登录一次,关闭数据 shutdown abort
2.修改initorcl.ora文件,将process改为300,保存.
3.用initorcl.ora启动数据库
SQL>startup pfile=D:\APP\ORACLE\db_home1\dbs\initorcl.ora
SQL> startup
ORA-00444: background process "DBW0" failed while starting
ORA-00020: maximum number of processes () exceeded