Help increasing the number of Processes on a 8i DB
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Help increasing the number of Processes on a 8i DB

  1. #1
    Join Date
    Feb 2001
    Posts
    39

    Angry

    Hi All,
    I am having a hard time increasing the amount of processes on my 8i DB. When I increase the size to about 50 in my init.ora file the DB cannot be restarted. It gives the error ORA-27146. Can someone please help he out with some information.

    Thanks,
    Dee.
    God Bless

  2. #2
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Hi,

    ORA-27146 means that the system is running out of semaphores. You can either decrease the "processes" parameter in the init.ora file, or increase the kernel parameters to accept more processes.

    If you don't know how to configure the kernal you may need to speak to your Unix Administrator.

    Cheers

    Suresh


  3. #3
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    Based on the type of box you have sun, hp, aix you should search metaling for kernel parameters and have your unix admin rebuild the kernel after apply proper values to them. Reboot the box then try increasing the parms and it will work. Oracle needs to be allocated certain amount of system memory as well thats why you require kernel parms.
    "High Salaries = Happiness = Project Success."

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