Home » RDBMS Server » Backup & Recovery » Oracle - Linux Raw
Oracle - Linux Raw [message #192493] Tue, 12 September 2006 10:57 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
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.


Previous Topic: Using retention policy and delete obsolete in RMAN
Next Topic: Recovery Catalog
Goto Forum:
  


Current Time: Tue Dec 06 08:16:09 CST 2016

Total time taken to generate the page: 0.14677 seconds