Re: error in creating a new db on solaris

From: k.vinayak <k_vinayak_at_my-deja.com>
Date: Thu, 04 Nov 1999 08:56:08 GMT
Message-ID: <7vrhn7$c47$1@nnrp1.deja.com>

Hi Sajnish:

According to me the following two could be the reasons why U are getting the error:

U may not have reboot the system after making the changes to the /etc/system parameter file.
Ur successive attempts of creating a database might have already allocated shared memory segs and or semaphores which are not removed.

The solution could be
1) reboot the system if you have not done so, 2) check out the current shared memory seg allocation and semaphore status using ipcs. If U see something owned by the oracle s/w owner account then kill them using ipcrm. The man pages for ipcrm could be of some help to U here.

HTH,
Vinayak.K
--
Reality is the illusion created by the deficiency of alcohol. --Anon

In article <nL0U3.43075$5W2.962396_at_news6.giganews.com>, "Sajnish Gupta" <sgupta_at_orillion.com> wrote:
> When I run the CREATE DATABASE script I get the following error:
>
> ORA-07252: spcre: semget error, could not allocate semaphores
> Cause: semget system call returned an error. There is possibly a
resource
> limit
> problem.
> Action: Examine errno. Verify that enough semaphores are available in
> sys-tem.
> If additional errors occur in destroying the semaphore sets, then
sercose[0]
> will be non-zero. If this occurs, remove the semaphore sets using
ipcrm.
>
> I have checked my /etc/system file and everything is according to
Oracle's
> standards. What else can I do to get rid of this error.
> thanks
> SG
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 04 1999 - 02:56:08 CST