Re: Space problem when running two db at the same time (question)

Ok, let us start at the beginning. First you need to get the value of some parameters:

SEMMNS = Maximum semaphore identifiers system wide

Now do ipcs -sb and added up the numbers under the NSEMS column. Subtract this number from SEMMNS. The ending result will be the number of semaphores that are free, provided there is no fragmentation of semaphores. Now go to $ORACLE_HOME/dbs for the database you are having trouble bringing up. Do "grep processes init${ORACLE_SID}.ora", where ORACLE_SID is the SID of the database you are bringing up. If processes is greater than the number of free semaphores there is your problem. You can either reduce the number of processes or increase SEMMNS and rebuild your kernel. If you need more help my email is mah_at_reaper.mitre.org.

Mike H. Received on Tue Jul 11 1995 - 00:00:00 CEST