ora-00020解决办法

1、windows：
找到orcle的进程[ORACLE.EXE]
c:>netstat -bo
杀掉进程
c:>taskkill /pid pid /F
c:>sqlplus / as sysdba
c:>show parameter processes;
c:>alter system set processes=300 scope=spfile;
c:>shutdown immediate;
c:>startup

2、linux：
找到orcle的进程PID
[oracle@kindo-dev2 ~]$ ps -ef|grep ora_dbw0_$ORACLE_SID
杀掉进程
[oracle@kindo-dev2 ~]$ kill -9 pid
[oracle@kindo-dev2 ~]$ sqlplus / as sysdba
SQL>startup
SQL>select count(*) from v$process; --查目前使用的进程
SQL>select username,serial#, sid from v$session; --查进程被哪些用户使用