| What's wrong with my system?~~ [message #58896] |
Fri, 10 October 2003 21:28  |
TianMaohuai
Messages: 3
Registered: October 2003
|
Junior Member |
|
|
I install Oracle9i on Solaris8(Ultra60,521M RAM),there are 2 instance,
but only one instance can start up,when I try to start up the second one,
it says that something wrong with this:
-------------------------------------------------------
/export/home/oracle$ sqlplus /nolog
SQL*Plus: Release 9.2.0.1.0 - Production on Friday 22:53:22 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect sys/sys@OEMREP as sysdba
connected to idle instance.
SQL> startup
ORA-27302: failure occurred at: skgpwreset1
ORA-27303: additional information: invalid shared ctx
ORA-27146: post/wait initialization 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: sskgpsemsper
SQL>
-------------------------------------------------------
I think it maybe some kernel param of OS is too small,
but I don't kown which one exactly,
who can help me?
THANKS A LOT!!!
|
|
|
|
| Re: What's wrong with my system?~~ [message #58897 is a reply to message #58896] |
Sat, 11 October 2003 00:56  |
sachin kumar gupta
Messages: 157
Registered: March 2003
|
Senior Member |
|
|
I am also a new in DBA. May be this hint can help u.
check ur ORACLE_SID before u login to the sqlplus!!
Set appropriate ORACLE_SID before u login to sqlplus.
This is because that by default each oracle user has ORACLE_SID set in .profile!!
Go Ahead!!
Regards,
Sachin K. Gupta
|
|
|
|
| Re: What's wrong with my system?~~ [message #58899 is a reply to message #58896] |
Sat, 11 October 2003 03:49 |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Looks like you have run out of semaphores on your system.Either that you have too many PROCESSES configured in your init.ora for the instances or you have insufficient SEMMNS,SEMMSL in your /etc/system.
If you can afford to reboot the Server, increase SEMMNS(total number of semaphores system wide) ,SEMMSL( number of semaphores per set ) and maybe SEMMNI(max number of semaphore sets) . Remember each process needs a semaphore. Let me know if you want additional info regarding these parameters and values.
If you cant afford to reboot the server immediately,make sure you terminate any unwanted processes/sessions,kill dead processes, reduce PROCESSES parameter of the 2nd instance and startup.
Hope this helps
Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
