I have a database server with 90+ DB instances. I am having problems creating new databases with the process size greater than 150! I get ORA-27300, 27301, 27302. Seems the total available semaphores is less. The Kernal values of semmni=4096, semmns=15000, semmsl=2048 and semmap=4202. The process size of the 90 databases are either greater than 150 and less than 300. Reducing the size is not helping. Need your advice.

    Requires Free Membership to View

You have run out of semaphores. Increase the Kernel semaphores setting. The following formula can be used to determine the appropriate size.
   SEMMNS = Sum(Processes parameter of each database) * 2

This was first published in May 2007

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: