Has anyone created tablespaces on raw devices with aix
4.3.3.0 and oracle 8.1.7 64 bit. I get an error fron the create saying no such device, even thought I can dd to the device. Here is what i am doing,
mkvg -f -y'rawvg' -s'16' hdisk8
mklv -y'rawlv' -b'n' rawvg 100
#ls -la | grep -i dev
drwxrwxrwx 6 root system 3072 Dec 19 14:27 dev
# cd /dev
# ls -ltr | grep -i rawlv
crw-rw---- 1 root system 56, 1 Dec 19 14:27 rrawlv
brw-rw---- 1 root system 56, 1 Dec 19 14:27 rawlv
# chown oraspn:dba rrawlv
# ls -ltr | grep -i rawlv
crw-rw---- 1 oraspn dba 56, 1 Dec 19 14:27 rrawlv
brw-rw---- 1 root system 56, 1 Dec 19 14:27 rawlv
lsvg -l rawvg
rawvg:
LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINT
rawlv jfs 100 100 1 closed/syncd N/A
su - oraspn
% cd dbs
% ls
init.ora initSPN.ora initdw.ora initsoxx.sql lkSPN orapwSPN snapcf_SPN.f
% ln -s /dev/rrawlv raw_datafile
% ls -ltr
total 6362
-rw-r--r-- 1 oraspn dba 8385 Oct 22 1999 init.ora
-rw-r--r-- 1 oraspn dba 9219 Oct 22 1999 initdw.ora
-rw-r--r-- 1 oraspn dba 835 Dec 13 1999 initsoxx.sql
lrwxrwxrwx 1 netinst dba 43 Dec 18 11:33 initSPN.ora -> /u01/app/oracle/admin/SPN/pfile/initSPN.ora
-rwSr----- 1 oraspn dba 1536 Dec 18 11:48 orapwSPN
-rw-r----- 1 oraspn dba 3235840 Dec 18 11:52 snapcf_SPN.f
-rw-rw---- 1 oraspn dba 24 Dec 19 13:08 lkSPN
lrwxrwxrwx 1 oraspn dba 11 Dec 20 11:55 raw_datafile -> /dev/rrawlv
ls -ltr /dev |grep -i rraw
crw-rw---- 1 oraspn dba 56, 1 Dec 19 14:27 rrawlv
SVRMGR> create tablespace trial datafile '/u01/app/oracle/product/8.1.7/dbs/raw_datafile' size 1M reuse;
create tablespace trial datafile '/u01/app/oracle/product/8.1.7/dbs/raw_datafile' size 1M reuse
*
ORA-01119: error in creating database file '/u01/app/oracle/product/8.1.7/dbs/raw_datafile'
ORA-27041: unable to open file
IBM AIX RISC System/6000 Error: 6: No such device or address
Additional information: 11
anyone have any ideas on this failure.
4.3.3.0 and oracle 8.1.7 64 bit. I get an error fron the create saying no such device, even thought I can dd to the device. Here is what i am doing,
mkvg -f -y'rawvg' -s'16' hdisk8
mklv -y'rawlv' -b'n' rawvg 100
#ls -la | grep -i dev
drwxrwxrwx 6 root system 3072 Dec 19 14:27 dev
# cd /dev
# ls -ltr | grep -i rawlv
crw-rw---- 1 root system 56, 1 Dec 19 14:27 rrawlv
brw-rw---- 1 root system 56, 1 Dec 19 14:27 rawlv
# chown oraspn:dba rrawlv
# ls -ltr | grep -i rawlv
crw-rw---- 1 oraspn dba 56, 1 Dec 19 14:27 rrawlv
brw-rw---- 1 root system 56, 1 Dec 19 14:27 rawlv
lsvg -l rawvg
rawvg:
LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINT
rawlv jfs 100 100 1 closed/syncd N/A
su - oraspn
% cd dbs
% ls
init.ora initSPN.ora initdw.ora initsoxx.sql lkSPN orapwSPN snapcf_SPN.f
% ln -s /dev/rrawlv raw_datafile
% ls -ltr
total 6362
-rw-r--r-- 1 oraspn dba 8385 Oct 22 1999 init.ora
-rw-r--r-- 1 oraspn dba 9219 Oct 22 1999 initdw.ora
-rw-r--r-- 1 oraspn dba 835 Dec 13 1999 initsoxx.sql
lrwxrwxrwx 1 netinst dba 43 Dec 18 11:33 initSPN.ora -> /u01/app/oracle/admin/SPN/pfile/initSPN.ora
-rwSr----- 1 oraspn dba 1536 Dec 18 11:48 orapwSPN
-rw-r----- 1 oraspn dba 3235840 Dec 18 11:52 snapcf_SPN.f
-rw-rw---- 1 oraspn dba 24 Dec 19 13:08 lkSPN
lrwxrwxrwx 1 oraspn dba 11 Dec 20 11:55 raw_datafile -> /dev/rrawlv
ls -ltr /dev |grep -i rraw
crw-rw---- 1 oraspn dba 56, 1 Dec 19 14:27 rrawlv
SVRMGR> create tablespace trial datafile '/u01/app/oracle/product/8.1.7/dbs/raw_datafile' size 1M reuse;
create tablespace trial datafile '/u01/app/oracle/product/8.1.7/dbs/raw_datafile' size 1M reuse
*
ORA-01119: error in creating database file '/u01/app/oracle/product/8.1.7/dbs/raw_datafile'
ORA-27041: unable to open file
IBM AIX RISC System/6000 Error: 6: No such device or address
Additional information: 11
anyone have any ideas on this failure.