SQL> startup mount
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: sskgpcreates
SQL>[@more@]

一个Oracle数据库被用户管理员修改了一些参数后不能启动，提示：

SQL> startup mount
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: sskgpcreates
SQL>

经检查：

SQL> host df -h
文件系统 大小 用了 可用 容量 挂接在
/dev/md/dsk/d0 9.6G 104M 9.4G 2% /
/dev/md/dsk/d4 9.6G 1.6G 7.9G 18% /usr
/proc 0K 0K 0K 0% /proc
mnttab 0K 0K 0K 0% /etc/mnttab
fd 0K 0K 0K 0% /dev/fd
/dev/md/dsk/d5 9.6G 342M 9.2G 4% /var
swap 11G 48K 11G 1% /var/run
swap 11G 0K 11G 0% /tmp
/dev/md/dsk/d3 9.6G 32M 9.5G 1% /opt
/dev/md/dsk/d45 134G 30G 103G 23% /data
/dev/md/dsk/d6 21G 21M 20G 1% /export/home


Mon Jul 6 11:36:16 2009
Errors in file /data/oracle/ora9i/admin/jwc/udump/jwc_ora_3587.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: sskgpcreates
Mon Jul 6 11:40:07 2009
Starting ORACLE instance (normal)
Mon Jul 6 11:40:07 2009
Errors in file /data/oracle/ora9i/admin/jwc/udump/jwc_ora_5000.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: sskgpcreates
Mon Jul 6 11:40:07 2009
Errors in file /data/oracle/ora9i/admin/jwc/udump/jwc_ora_5000.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: sskgpcreates
bash-2.05$ date
2009年07月06日 星期一 11时41分43秒 CST

bash-2.05$ cat /etc/system
set shmsys:shminfo_shmmax=2147483648
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmni=110
set semsys:seminfo_semmns=310

确认/etc/system文件中关于内核参数的设置被修改，重新修改成正确的参数，问题解决

set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=20
set semsys:seminfo_semmni=100
set semsys:seminfo_semmsl=3000
set semsys:seminfo_semmns=32767
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767
set max_nprocs=6100
set maxuprc=6000