-
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
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.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
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
kavitha
-
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
"Greatest Rewards come only with Greatest Commitments!"
-
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]
Good Judgement comes from Experience.
Experience comes from Bad Judgement
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|