DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

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

  1. #1
    Join Date
    Apr 2006
    Posts
    8

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

    Hi,

    I got this error. How do I get out of this. I am not able to get a new connection, so I cannot increase the processes in init.

    Pl. advice me.

    Thanks
    Sathidevi

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    a) learnt to post in the right forum
    b) what version? you dont need a connection to update the init.ora file
    c) stop other connections if you want to get a connect

  3. #3
    Join Date
    Apr 2006
    Posts
    23
    To Increase the number of process
    Step-1
    Create pfile= /oracle/.... from spfile
    Step 2
    Shutdown database
    Step-3
    Amend that pfile and increase the number of processes
    Step -4
    startup the database with new pfile
    startup pfile='/oracle/....'
    Step-5
    Create spfile from pfile='/otacle/....'
    So that when you startup database next time it will read spfile (new)

    Best of luck.
    Regards

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    what is wrong with alter system scope=spfile?

    why create a pfile???

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    there is no need, Mr Mahsnj doesnt appear to know fully what to do here

  6. #6
    Join Date
    Apr 2006
    Posts
    23
    Beacuse you can not change parameter called process by alter system

  7. #7
    Join Date
    Apr 2006
    Posts
    23
    Quote Originally Posted by davey23uk
    there is no need, Mr Mahsnj doesnt appear to know fully what to do here
    I have clearly mentioned these steps are to increase the number of process in init.ora file.
    To get rid of connections I think she will have to kill connections so that application can make new connections.and this also calls for Increase of number of process in init.ora file
    ANY suggestion DAVEY23UK SIR

  8. #8
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Quote Originally Posted by mahsnj
    Beacuse you can not change parameter called process by alter system
    Don't be silly, of course you can change it directly in spfile!

    Code:
    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production
    With the Partitioning, OLAP and Data Mining options
    
    SQL> alter system set processes=150 scope=spfile;
    
    System altered.
    
    SQL>
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  9. #9
    Join Date
    Apr 2006
    Posts
    23
    Quote Originally Posted by jmodic
    Don't be silly, of course you can change it directly in spfile!

    Code:
    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production
    With the Partitioning, OLAP and Data Mining options
    
    SQL> alter system set processes=150 scope=spfile;
    
    System altered.
    
    SQL>
    Your are right I was missing scope=Spfile
    SQL> alter system set processes=150;
    alter system set processes=150
    *
    ERROR at line 1:
    ORA-02095: specified initialization parameter cannot be modified
    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width