【问题描述】
操作系统为AIX，在数据库的Alert日志中，出现如下报错：
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
Fri Jul 13 13:33:08 2012
Process m000 died, see its trace file
Fri Jul 13 13:33:08 2012
ksvcreate: Process(m000) creation failed
Fri Jul 13 13:34:08 2012
Process startup failed, error stack:
Fri Jul 13 13:34:08 2012
Errors in file /oracle/admin/nms115/bdump/nms115_psp0_7667948.trc:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
Fri Jul 13 13:34:09 2012
Process m000 died, see its trace file
Fri Jul 13 13:34:09 2012
ksvcreate: Process(m000) creation failed
Fri Jul 13 13:35:27 2012
Thread 1 advanced to log sequence 3275 (LGWR switch)
Current log# 3 seq# 3275 mem# 0: /oracle/oradata/nms115/redo03.log
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
Fri Jul 13 13:33:08 2012
Process m000 died, see its trace file
Fri Jul 13 13:33:08 2012
ksvcreate: Process(m000) creation failed
Fri Jul 13 13:34:08 2012
Process startup failed, error stack:
Fri Jul 13 13:34:08 2012
Errors in file /oracle/admin/nms115/bdump/nms115_psp0_7667948.trc:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
Fri Jul 13 13:34:09 2012
Process m000 died, see its trace file
Fri Jul 13 13:34:09 2012
ksvcreate: Process(m000) creation failed
Fri Jul 13 13:35:27 2012
Thread 1 advanced to log sequence 3275 (LGWR switch)
Current log# 3 seq# 3275 mem# 0: /oracle/oradata/nms115/redo03.log
【处理过程】
此错误已经很明确了，是由于交换空间不够导致，因此需要扩大AIX的交换空间：
首先检查交换空间情况，得到交换空间为hd6。
# swap -l
device maj,min total free
/dev/hd6 10, 2 5120MB 97MB
device maj,min total free
/dev/hd6 10, 2 5120MB 97MB
查勘vg情况，得知pp size为256M
# lsvg rootvg
VOLUME GROUP: rootvg VG IDENTIFIER: 00cd0d6500004c00000001348669a73b
VG STATE: active PP SIZE: 256 megabyte(s)
VG PERMISSION: read/write TOTAL PPs: 1092 (279552 megabytes)
MAX LVs: 256 FREE PPs: 2 (512 megabytes)
LVs: 13 USED PPs: 1090 (279040 megabytes)
OPEN LVs: 12 QUORUM: 2 (Enabled)
TOTAL PVs: 2 VG DESCRIPTORS: 3
STALE PVs: 0 STALE PPs: 0
ACTIVE PVs: 2 AUTO ON: yes
MAX PPs per VG: 32512
MAX PPs per PV: 1016 MAX PVs: 32
LTG size (Dynamic): 1024 kilobyte(s) AUTO SYNC: no
HOT SPARE: no BB POLICY: relocatable
VOLUME GROUP: rootvg VG IDENTIFIER: 00cd0d6500004c00000001348669a73b
VG STATE: active PP SIZE: 256 megabyte(s)
VG PERMISSION: read/write TOTAL PPs: 1092 (279552 megabytes)
MAX LVs: 256 FREE PPs: 2 (512 megabytes)
LVs: 13 USED PPs: 1090 (279040 megabytes)
OPEN LVs: 12 QUORUM: 2 (Enabled)
TOTAL PVs: 2 VG DESCRIPTORS: 3
STALE PVs: 0 STALE PPs: 0
ACTIVE PVs: 2 AUTO ON: yes
MAX PPs per VG: 32512
MAX PPs per PV: 1016 MAX PVs: 32
LTG size (Dynamic): 1024 kilobyte(s) AUTO SYNC: no
HOT SPARE: no BB POLICY: relocatable
使用smit来扩展
# smit chps
+--------------------------------------------------------------------------+
| PAGING SPACE name |
| |
| Move cursor to desired item and press Enter. |
| |
| hd6 |
| |
| F1=Help F2=Refresh F3=Cancel |
| Esc+8=Image Esc+0=Exit Enter=Do |
| /=Find n=Find Next |
Change / Show Characteristics of a Paging Space
Type or select values in entry fields.
Press Enter AFTER making all desired changes.
[Entry Fields]
Paging space name hd6
Volume group name rootvg
Physical volume name hdisk1
NUMBER of additional logical partitions [4] #
Or NUMBER of logical partitions to remove [] #
Use this paging space each time the system is yes +
RESTARTED?
Checksum Size [0] +#
+--------------------------------------------------------------------------+
| PAGING SPACE name |
| |
| Move cursor to desired item and press Enter. |
| |
| hd6 |
| |
| F1=Help F2=Refresh F3=Cancel |
| Esc+8=Image Esc+0=Exit Enter=Do |
| /=Find n=Find Next |
Change / Show Characteristics of a Paging Space
Type or select values in entry fields.
Press Enter AFTER making all desired changes.
[Entry Fields]
Paging space name hd6
Volume group name rootvg
Physical volume name hdisk1
NUMBER of additional logical partitions [4] #
Or NUMBER of logical partitions to remove [] #
Use this paging space each time the system is yes +
RESTARTED?
Checksum Size [0] +#
Hi there, of course this piece of writing is in fact good
and I have learned lot of things from it about blogging.
thanks.