Atasi Maximum Number of Processes di Oracle 9i

Pesan Error :

ORA-00020: maximum number of processes (%s) exceeded

Setelah googling, ehh ketemu perintah command line yang passss….., seperti ini:

lsnrctl stop;
sqlplus “/as sysdba”
shutdown immediate;
startup;
alter system set processes=150 scope=spfile;
shutdown immediate;
startup;
lsnrctl start;

Semoga berguna… Heee