Re: Oracle on raw devices in SLES9

On Fri, 2007-06-01 at 21:37 +0530, Shashi Kanth Boddula wrote:
> Hi All,
> 
> I am installing Oracle 10gR2 on SLES9 SP3 raw volumes which is made by 
> Linux LVM. As per the oracle documentation, all the raw devices should 
> be owned by oracle user, for that we need to change the ownership on all 
> raw devices  where your installing database to oracle user.
> 
> The problem is , after you create a mapping file in /etc/raw, and when 
> you start the raw service (#rcraw start), the permission again set back 
> to root.
> 
> I have tried to solve this problem by modifying /etc/init.d/raw file , 
> but still , always , when you start the raw services, the ownership on 
> raw devices again go back to root.
> 
> Anyone has any solution for this ?
> 

Modifying the /etc/init.d/raw script is not the way to go.

When the raw devices (or really any devices) are created, the udev
subsystem automatically sets the permissions to root:disk:660.

On SLES9 edit the /etc/udev/udev.permissions file which has rules for
what permissions are given to devices files as they are created.

For raw devices, the permissions are set by the following line:

raw/raw*:root:disk:660

You want to add some rules to set the permissions for the raw devices
that you are going to use like so:

raw/raw1:oracle:oinstall:644
raw/raw2:oracle:oinstall:644
raw/raw3:oracle:oinstall:644
raw/raw*:root:disk:660

Or whatever is appropriate for your setup.  The rules can contain some standard
shell expansions like 'raw/raw[1-3]' or similar.  The man page has more details.
Note that the file is processed in order, and when a matching rule is found
processing stops.  So you need to have the default rule come after your custom
rules or it will not work.

Thanks,
Kevin



-- 
To unsubscribe, email: [email protected]
For additional commands, email: [email protected]
Please see http://www.suse.com/oracle/ before posting