Home » Infrastructure » Unix » not able to bring up the instance ( oracle 9.2.0.6.0 sunsolaris 5.9)
not able to bring up the instance [message #307479] Wed, 19 March 2008 00:06 Go to next message
kesavansundaram
Messages: 183
Registered: October 2007
Location: MUMBAI
Senior Member

iam not able to bringup the instance,iam getting follwoing error:

bash-2.05$ export ORACLE_SID=SAPRD
bash-2.05$ sqlplus /nolog

SQL*Plus: Release 9.2.0.6.0 - Production on Wed Mar 19 10:22:30 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> conn sys as sysdba
Enter password:
Connected to an idle instance.
SQL> 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: sskgpsemsper
SQL>

at o/s level, the partition is :
----------------------------------
/dev/dsk/c5t0d15s2 20639752 18973383 1459972 93% /INT_dbsys
/dev/dsk/c5t1d16s2 25799463 23836659 1704810 94% /GFPRD_dbsys <<<<...
/dev/dsk/c5t1d4s2 41284451 39827562 1044045 98% /GFPRD_dbdata1


in alert log file, the info is:
-------------------------------
Wed Mar 19 10:22:37 2008
Starting ORACLE instance (normal)
Wed Mar 19 10:22:38 2008
Errors in file /GFPRD_dbsys/database/SAPRD/trace/udump/saprd_ora_29939.trc:
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: sskgpsemsper

we have 1.7 gb free space in subj partiion.
we already 2 times unmoutned the subj.partition and mounted.
now how to proceed.
need urgent reply

tks
kesavan.
Re: not able to bring up the instance [message #307483 is a reply to message #307479] Wed, 19 March 2008 00:20 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
May be your device (storage) was crashed. Ask your OS administrator.
Re: not able to bring up the instance [message #307508 is a reply to message #307479] Wed, 19 March 2008 01:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use "du" instead of "df". "df" may not have correct data.
Use "fsck" on your file system, maybe you have orphan objects or invalid free list.

Regards
Michel
Re: not able to bring up the instance [message #307741 is a reply to message #307479] Wed, 19 March 2008 14:48 Go to previous messageGo to next message
dzt52r
Messages: 19
Registered: July 2007
Location: PA
Junior Member
check your kernel parameters. Make sure you have enough semaphores available and that max shared memory is set large enough
Re: not able to bring up the instance [message #307746 is a reply to message #307741] Wed, 19 March 2008 15:35 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Good catch, I didn't see the "semget failed".

Regards
Michel
Previous Topic: passind date from shell script to java
Next Topic: regarding UNIX
Goto Forum:
  


Current Time: Thu Mar 28 08:21:28 CDT 2024