ORA-27301: OS failure message: No space left on device解決一例

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