Home » RDBMS Server » Server Administration » Instance failure with Session and Process parameter
Instance failure with Session and Process parameter [message #271683] Tue, 02 October 2007 08:45 Go to next message
preet_kumar
Messages: 195
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
Re: Instance failure with Session and Process parameter [message #271690 is a reply to message #271683] Tue, 02 October 2007 09:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It seems you reached an Oracle limit for your OS.

Regards
Michel
Re: Instance failure with Session and Process parameter [message #271695 is a reply to message #271683] Tue, 02 October 2007 09:41 Go to previous messageGo to next message
preet_kumar
Messages: 195
Registered: March 2007
Senior Member
what does that mean by Oracle Limit,do you mean something with ulimit
Re: Instance failure with Session and Process parameter [message #271696 is a reply to message #271683] Tue, 02 October 2007 09:43 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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.
Re: Instance failure with Session and Process parameter [message #271702 is a reply to message #271683] Tue, 02 October 2007 10:23 Go to previous messageGo to next message
preet_kumar
Messages: 195
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
Re: Instance failure with Session and Process parameter [message #271703 is a reply to message #271683] Tue, 02 October 2007 10:30 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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!
Re: Instance failure with Session and Process parameter [message #271713 is a reply to message #271683] Tue, 02 October 2007 11:11 Go to previous messageGo to next message
preet_kumar
Messages: 195
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
Re: Instance failure with Session and Process parameter [message #271714 is a reply to message #271713] Tue, 02 October 2007 11:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: Instance failure with Session and Process parameter [message #271719 is a reply to message #271683] Tue, 02 October 2007 11:35 Go to previous message
BlackSwan
Messages: 25046
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?
Previous Topic: database creation problem
Next Topic: tablespace location on hard disk
Goto Forum:
  


Current Time: Fri Dec 09 00:17:45 CST 2016

Total time taken to generate the page: 0.10380 seconds