ORA-01119 and ORA-27042 when create bigfile tablespace on AIX 5.3 (64bit)
qiutaoMay 14 2010 — edited May 14 2010create bigfile tablespace command and error info:
SQL> create bigfile tablespace test nologging datafile '/dev/rtest' size 3000000m reuse extent management local segment space management auto;
ORA-01119: error in creating database
file '/dev/rtest'
ORA-27042: not enough space on raw partition to
fullfill request
Additional information: 3
alert_ora11g.log:
Thu May 13 14:13:04 2010
create bigfile tablespace test nologging datafile '/dev/rtest' size 3000000m reuse
extent management local segment space management auto
ORA-1119 signalled during:
create bigfile tablespace test nologging datafile '/dev/rtest' size 3000000m reuse
extent management local segment space management auto
...
mklv command:
#mklv -y test -T O -w n -s n -r n -t 'raw' oravg 6024
oravg info:
# lsvg oravg
VOLUME GROUP: oravg VG IDENTIFIER: 00c1be0b00004c0000000128855f316d
VG STATE: active PP SIZE: 512 megabyte(s)
VG PERMISSION: read/write TOTAL PPs: 7408 (3792896 megabytes)
MAX LVs: 512 FREE PPs: 1384 (708608 megabytes)
LVs: 1 USED PPs: 6024 (3084288 megabytes)
OPEN LVs: 0 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: 127000
MAX PPs per PV: 5080 MAX PVs: 25
LTG size (Dynamic): 256 kilobyte(s) AUTO SYNC: no
HOT SPARE: no BB POLICY: relocatable