OraFAQ Forum: Server Administration » Instance failure with Session and Process parameter

Home » RDBMS Server » Server Administration » Instance failure with Session and Process parameter

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Instance failure with Session and Process parameter [message #271683]

Tue, 02 October 2007 08:45

preet_kumar
Messages: 204
Registered: March 2007

Senior Member

Running Oracle 10gR2 on Sun Ultrasparc II Solaris 5.9 with 2GB RAM.

While starting the instance I get the following error when i increase the process and session parameter above 600 while the instance starts normally if i use a value below 600 for process and sessions.
sqlplus >startup
ORA-27154: post/wait create failed
ORA-27300: OS system dependent operation:semget failed with status: 28
ORA-27301: OS failure message: No space left on device
ORA-27302: failure occurred at: sskgpcreates

Report message to a moderator

Re: Instance failure with Session and Process parameter [message #271690 is a reply to message #271683]

Tue, 02 October 2007 09:14

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It seems you reached an Oracle limit for your OS.

Regards
Michel

Report message to a moderator

Re: Instance failure with Session and Process parameter [message #271695 is a reply to message #271683]

Tue, 02 October 2007 09:41

preet_kumar
Messages: 204
Registered: March 2007

Senior Member

what does that mean by Oracle Limit,do you mean something with ulimit

Report message to a moderator

Re: Instance failure with Session and Process parameter [message #271696 is a reply to message #271683]

Tue, 02 October 2007 09:43

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

When processes/sessions in initSID.ora is increased then SGA gets larger.
It is possible/likely this increase in SGA is exceeding some limit within /etc/system file.

Report message to a moderator

Re: Instance failure with Session and Process parameter [message #271702 is a reply to message #271683]

Tue, 02 October 2007 10:23

preet_kumar
Messages: 204
Registered: March 2007

Senior Member

The system setting is

set semsys:seminfo_semmni=512
set semsys:seminfo_semmns=1024
set semsys:seminfo_semmsl=512
set semsys:seminfo_semvmx=65534
set semsys:seminfo_semopm=256
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=512
set shmsys:shminfo_shmseg=128

which value should i change so i can increase the process and sessions parameter

Report message to a moderator

Re: Instance failure with Session and Process parameter [message #271703 is a reply to message #271683]

Tue, 02 October 2007 10:30

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

I am NOT a mind reader.
I don't know the before & after values in your initSID.ora file
I don't know how many other Oracle DB's are on your system.
This is YOUR system; so learn to manage it!

Report message to a moderator

Re: Instance failure with Session and Process parameter [message #271713 is a reply to message #271683]

Tue, 02 October 2007 11:11

preet_kumar
Messages: 204
Registered: March 2007

Senior Member

Thanks,
I have already mentioned the before and after value of 600 if its increased to 601 it gives the problem.Also never mentioned about multiple DBs which means its only one DB
I posted the message to get some solution from experts or someone who faced similar problems not for advice or reading minds

Report message to a moderator

Re: Instance failure with Session and Process parameter [message #271714 is a reply to message #271713]

Tue, 02 October 2007 11:14

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes, you encountered an OS limit.
There are many and many parameters that impact SGA size.
Try to decrease another parameter.
Try to stop another database and restart only this one.
Try as many tests as possible.

Finally, ORA-273XX error is "contact Oracle support".

Regards
Michel

Report message to a moderator

Re: Instance failure with Session and Process parameter [message #271719 is a reply to message #271683]

Tue, 02 October 2007 11:35

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

According to MetaLink there should be a corresponding trace file whose name can be found in the alertSID.log file.

Post contents of trace file back here.

Have you researched your errors on MetaLink?

Report message to a moderator

Previous Topic:	database creation problem
Next Topic:	tablespace location on hard disk

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 04:36:37 CST 2024