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

This entry was posted on Monday, May 12th, 2008 at 10:33 am and is filed under Tutorial. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “Atasi Maximum Number of Processes di Oracle 9i”

  1. kindy Says:
    June 16, 2008 at 1:34 pm

    by……….

  2. kindy Says:
    June 22, 2008 at 9:13 am

    By.. kamu mau serius blajar Oracle? Mau aq kenalin ma peraih Master Oracle certification g?

Leave a Reply