start the db

Hiii,I have problem to start the database on sunsolaris
db version 9i
Thu Aug 8 17:02:56 2002
Starting ORACLE instance (normal)
Thu Aug 8 17:02:58 2002
Errors in file /app/oracle/admin/sghtest/udump/sghtest_ora_27875.trc:
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
Thu Aug 8 17:02:58 2002
Errors in file /app/oracle/admin/sghtest/udump/sghtest_ora_27875.trc:
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

when try to connect from sqlprompt i get a one more error**
SQL> connect websms/sghocs1@sghtest.192.100.86.52;
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory

plss reply soon
thanks
kavitha

Increase semaphores in /etc/system: SEMMSL & SEMMNI

Note: websms/sghocs1@sghtest.192.100.86.52 is a bit too much information given in Internet.

Hi,

Reading your output tells me your shmmax setting is to low.

Read the installation guide to see how you have to change it and also put some extra semaphores in.

Kind regards,

Tycho

hii,many thanks
can u give detail doc or procedure

Quote:

---

Originally posted by julian

Note: websms/sghocs1@sghtest.192.100.86.52 is a bit too much information given in Internet.

---

you shouldn't have given all these details, i would change the password if i were you kavithared.

alter user websms identified by new_password;

Regards.

Just to add, one more thing, if any one of mount point is 100% full, you cann't start your Oracle. So check if this is the situation if you are not able to solve the problem.
Always take care of the point pointed out by Hany... :-)
Sandy

login as root
Use a text editor such as vi to change kernel parameter settings in the /etc/system file

check the values for the following settings

SEMMNI 100
SEMMNS 256
SEMMSL 256
SHMMAX 4294967295
SHMMIN 1
SHMMNI 100
SHMSEG 10

reboot the system if you change any of these values.

http://www.dbspecialists.com/present...20solaris.html

go through this link which has the step by step installation process

[Edited by sona on 08-08-2002 at 07:35 AM]