Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

oracle 64 bit on aix fails to create tablespace on raw device

Status
Not open for further replies.

novi

MIS
Jan 2, 2002
6
US
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.
 
Post the results of

ls -l /u01/app/oracle/product/8.1.7/dbs/raw_datafile

Bill.
 
here the listing
ls -l raw_datafile
lrwxrwxrwx 1 oraspn dba 11 Dec 20 11:55 raw_datafile -> /dev/rrawlv

# ls -l /dev/rrawlv
crw-rw---- 1 oraspn dba 56, 1 Dec 19 14:27 /dev/rrawlv
#
 
novi,

Please post results of _exactly_

ls -l /u01/app/oracle/product/8.1.7/dbs/raw_datafile

Thanks, Bill.
 
# ls -l /u01/app/oracle/product/8.1.7/dbs/raw_datafile
lrwxrwxrwx 1 oraspn dba 11 Dec 20 11:55 /u01/app/oracle/product/8.1.7/dbs/raw_datafile -> /dev/rrawlv
#
 
Now try this.

su - oraspn
cd /dev
touch somefile
rm somefile

Post the results.

Bill.
 
# cd
# su - oraspn
% cd /dev
% touch testfiletodelete
% rm testfiletodelete
%
This works fine....
 
I also have tried dd to the device as root and oracle user
to check that I can read and write to the disk.

# dd if=/dev/rhdisk8 of=/dev/rhdisk8 ibs=512 count=100
100+0 records in.
100+0 records out.
#
#
#
# su - oraspn
% dd if=/dev/rhdisk8 of=/dev/rhdisk8 ibs=512 count=100
dd: /dev/rhdisk8: The file access permissions do not allow the specified action.
%
 
I also tried the following...

% dd if=/dev/rrawlv of=/dev/rrawlv ibs=512 count=100
100+0 records in.
100+0 records out.

% dd if=/u01/app/oracle/product/8.1.7/dbs/raw_datafile of=/u01/app/oracle/product/8.1.7/dbs/raw_datafile ibs=512 count=100
100+0 records in.
100+0 records out.
%
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top