| not able to bring up the instance [message #307479] |
Wed, 19 March 2008 00:06  |
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.
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
