skip to main |
skip to sidebar
Found this error when creating a 10.2.0.3 database on solaris 9.This error can occur on any unix host when starting an oracle database. The error is saying that the semiphore parameters are not set correctly.In cases like this, the first parameter to look for is SEMMNSEssentially this parameter tells how many os processes shared memory components can use on the server. So the important oracle database parameter to look at is process.Use the following calulation to work out what SEMMNS should be set to:SEMMNS = sum(oracle processes) + num oracle databases + system requirementsThis all suggests when setting up a new server you should have an idea of the number of databases running on the server or set the SEMMNS parameter to a fairly high number.
This view is slightly different to v$parameter in that it seperates out the values for specific parameters into seperate rows.Some examples of parameters where this may occur are : - control_files - utl_file_dir Useful when wanting to query specific values, say a particular utl_file_dir or control file.
For this to work, the seperate values for these parameters must be seperated by commas.
i.e.:
alter system set utl_file_dir= '/u01/ora_utl_file/hpac/', '/home/sequel/cms/test/socrates/output/', '/u01/ora_utl_file/contt/' scope=spfile ;