Re: can't create new database

James Dickson wrote:
>
> To: comp.databases.oracle, comp.unix.questions newsgroups
 

> pfile=/gigante_home1/3rdsw/oradba/product/7.2.2/dbs/initPROCOS_0.ora
> ORA-07279: spcre: semget error, unable to get first semaphore set.
> SVR4 Error: 28: No space left on device
> Additional information: 1
> SQLDBA> exit
> SQL*DBA complete.
> > oerr ora 07279
> 07279, 00000, "spcre: semget error, unable to get first semaphore set."
> // *Cause: An error occurred when trying to get first semaphore set.
> // *Action: Check errno. Verify that system is configured to have
> semaphores.
> // Verify that enough semaphores are available. Additional
> information
> // indicates how many semaphores were requested.
>

OK first off I’m definitely not the Oracle expert, but perhaps this will help.
( At lest you didn’t mention it )

Isn’t the semaphore set in 2 places. One in the kernel and the 2nd in Oracle. ?
I’m looking at the 7.1 man and it tells me to set the parameter in /etc/system.
The following is an example:

                /etc/system

	set shmsys:shminfo_shmmax=8388608
	set shmsys:shminfo_shmmin=1
	set shmsys:shminfo_shmmni=100
	set shmsys:shminfo_shmseg=10
	set semsys:seminfo_semmns=200
	set semsys:seminfo_semmni=70

the above is for a single instance of Oracle using the default "initsid.ora" file
with Oracle 7.1

        This may not help but may lead you to something ???????

	Al Pritchard
		pritchaj_at_waymark.net
		alprit_at_henryschein.com