| Oracle - Linux Raw [message #192493] |
Tue, 12 September 2006 10:57  |
coolbalaga
Messages: 24
Registered: September 2006
|
Junior Member |
|
|
Hello,
I wanted help in understanding the Oracle on Linux raw device.
U can also guide me to appropriate websites/Books.
The following are the steps I have performed on the Suse linux for the Oracle 9.2.0.4.0:
1. Created the logical partition(/dev/system/test) with the reiserfs filesystem.
2. The /dev/system/test is mounted on /test
3. Bind the raw interface to it.
(raw /dev/raw/raw5 /dev/system/test)
4. Given the ownership and permission appropriately
chown oracle:oinstall /dev/raw/raw5
chmod 660 /dev/raw/raw5
5. When I tried to create the datafile, I got the below error:
SQL> create tablespace test32 datafile '/dev/raw/raw5' reuse size 1m autoextend on;
<--
ERROR at line 1:
ORA-01119: error in creating database file '/dev/raw/raw5'
ORA-27041: unable to open file
Linux Error: 16: Device or resource busy
Additional information: 1
--->
if I unmount the device /dev/system/test and then I am able to create the datafile.
>>> Wanted to confirm whether this is the known behaviour ?
II) After creating the datafile in the unmount state (associated block device), I am not able to mount /dev/system/test again. To mount it again, I have remove the datafile and then i am able to do it.
Please let me know if this is the known behaviour (i.e., Oracle doesnot allow the associated block device (i.e., in this case /dev/system/test) to be in the mounted state.
I tried the same thing on HP-UX [Created lvol/rvol using lvcreate]. I was able to create the datafile when the associated logical volume(lvol) was mounted.
your help is greatly appreciated.
~ Balu
|
|
|
|
| Re: Oracle - Linux Raw [message #192798 is a reply to message #192493] |
Wed, 13 September 2006 11:59  |
tridentadm
Messages: 142
Registered: March 2006
|
Senior Member |
|
|
| coolbalaga wrote on Tue, 12 September 2006 21:27 |
3. Bind the raw interface to it.
(raw /dev/raw/raw5 /dev/system/test)
|
I dont think this is correct...
what does 'raw' command do by the way ??
| Quote: |
ERROR at line 1:
ORA-01119: error in creating database file '/dev/raw/raw5'
ORA-27041: unable to open file
Linux Error: 16: Device or resource busy
Additional information: 1
|
thats the error which is obvious to come since you have associated the raw device to /dev/system/test
and so its giving your busy..
| Quote: |
if I unmount the device /dev/system/test and then I am able to create the datafile.
|
this is the correct way of doing it.
how have u unmounted ?? whats the command ??
| Quote: |
I tried the same thing on HP-UX [Created lvol/rvol using lvcreate]. I was able to create the datafile when the associated logical volume(lvol) was mounted.
|
the lvol might be eventually a raw device not associated to anything else.
so it was successfull.
|
|
|
|
| Re: Oracle - Linux Raw [message #192859 is a reply to message #192798] |
Wed, 13 September 2006 23:42 |
coolbalaga
Messages: 24
Registered: September 2006
|
Junior Member |
|
|
| tridentadm wrote on Wed, 13 September 2006 22:29 |
| coolbalaga wrote on Tue, 12 September 2006 21:27 |
3. Bind the raw interface to it.
(raw /dev/raw/raw5 /dev/system/test)
|
I dont think this is correct...
what does 'raw' command do by the way ??
>>> The raw command binds the raw interface to the block device.
U get more info on the man pages of "raw" in linux.
| Quote: |
ERROR at line 1:
ORA-01119: error in creating database file '/dev/raw/raw5'
ORA-27041: unable to open file
Linux Error: 16: Device or resource busy
Additional information: 1
|
thats the error which is obvious to come since you have associated the raw device to /dev/system/test
and so its giving your busy..
| Quote: |
if I unmount the device /dev/system/test and then I am able to create the datafile.
|
this is the correct way of doing it.
how have u unmounted ?? whats the command ??
using umount command.
| Quote: |
I tried the same thing on HP-UX [Created lvol/rvol using lvcreate]. I was able to create the datafile when the associated logical volume(lvol) was mounted.
|
the lvol might be eventually a raw device not associated to anything else.
so it was successfull.
lvol has Filesystem. when lvcreate is used, it eventually creates lvol and rvol. i think this rvol is associated with the lvol.
|
|
|
|
|
| Re: Oracle - Linux Raw [message #193940 is a reply to message #192493] |
Wed, 20 September 2006 01:33 |
Shamsher
Messages: 18
Registered: September 2006
|
Junior Member |
|
|
After creating a Raw devices you create a link for the same ex
ln -s /mnt1/abc/raw5 /dev/raw/raw5
then you can use link name for creating a tablespace or datafile.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
