Home » RDBMS Server » Server Administration » unable to increse the processes
unable to increse the processes [message #52866] Sun, 18 August 2002 20:44 Go to next message
Amit
Messages: 166
Registered: February 1999
Senior Member
We have oracle 7.3.4 on Sco unix open server 5.0.4.

We have 25 processes in init.ora file, which are too few. When we try to increase it to even 26, it gives following error.

we try to open database by giving the command startup.

SVRMGR> ORA-07252: spcre: semget error, could not allocate semaphores.
SCO System V/386 Error: 28: No space left on device Additional information: 2

we configured kernel parameter as outlined in oracle documentation.

SEMMAP ---10
SEMMNI 300
SEMMNU 100
SHMMAX 268435456
SHMMIN 1
ULIMIT 2097152

Hard disk size is 54 GB , RAM 1 GB with RAID 5.

What can we do??

Report message to a moderator

Re: unable to increse the processes [message #52874 is a reply to message #52866] Mon, 19 August 2002 04:12 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
 
there is some kind of 'SYNTACTICAL ERROR' (spelling, unwanted characters etc)in the semaphore settings of /etc/system file.
check that first.
and
as per your posting

SEMMAP ---10

there are supposed to be NO '-' here
if this a typo, remove that.

Report message to a moderator

Re: unable to increse the processes [message #52898 is a reply to message #52874] Mon, 19 August 2002 20:00 Go to previous messageGo to next message
Amit
Messages: 166
Registered: February 1999
Senior Member
Yes, there is typing mistake but only in earlier message. No, mistakes in server configuration.

Another, there is no /etc/system file in SCO-unix open server 5.

amit

Report message to a moderator

Re: unable to increse the processes [message #52901 is a reply to message #52866] Tue, 20 August 2002 00:13 Go to previous messageGo to next message
Ron Richardson
Messages: 3
Registered: August 2002
Junior Member
Hi,
I work with HP-UX so this may not be correct for SCO unix but the max number of Semaphores is set by the semmns kernel parameter?

Oracle DBA

we configured kernel parameter as outlined in oracle documentation.

SEMMAP ---10
SEMMNI 300
SEMMNU 100
SHMMAX 268435456
SHMMIN 1
ULIMIT 2097152

Report message to a moderator

Re: unable to increse the processes [message #52903 is a reply to message #52866] Tue, 20 August 2002 00:48 Go to previous messageGo to next message
Ron Richardson
Messages: 3
Registered: August 2002
Junior Member
Hi,
I work with HP-UX so this may not be correct for SCO unix but the max number of Semaphores is set by the semmns kernel parameter?

Oracle DBA

we configured kernel parameter as outlined in oracle documentation.

SEMMAP ---10
SEMMNI 300
SEMMNU 100
SHMMAX 268435456
SHMMIN 1
ULIMIT 2097152

Report message to a moderator

Re: unable to increse the processes [message #52907 is a reply to message #52898] Tue, 20 August 2002 05:08 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
may be...
I beleive, this is an issue witht he semaphores settings only.
check that out!

Report message to a moderator

Re: unable to increse the processes [message #52910 is a reply to message #52898] Tue, 20 August 2002 05:14 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
may be...
I beleive, this is an issue witht he semaphores settings only.
check that out!

Report message to a moderator

Previous Topic: Tools for database growth/performance monitoring
Next Topic: external table - issue (very urgent)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 13:41:29 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.