Richmond Cluster (09)

Sunday 04 May, 2008 - 21:59

Found How to Add CSS Voting Disk Mirrors on Linux Using Shared Raw Partitions (Doc.Id: 329734.1) says: To set them up as raw devices, with permissions 600 and ownership assigned to oracle:dba,.... This contradicts the Oracle Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide (pp.3-15 to 3-16):

For the raw device that you created for the Oracle Cluster Registry (OCR), enter commands similar to the following to set the owner, group, and permissions on the device file:

# chown root:oinstall /dev/raw/rawn

# chmod 640 /dev/raw/rawn

By making the oinstall group the owner of the OCR, this permits the OCR to be read by multiple Oracle homes, including those with different OSDBA groups.

In the installer log ($ORACLE_BASE/oraInventory/logs), the following messages are found:

PathName = /dev/raw/raw1

INFO: Query Returned: 0

SEVERE: The specified shared raw partition /dev/raw/raw1 may not have correct permission. Verify that the partition is owned by Oracle User.

Changed the ownership of the ocr devices on richmond1:

$ su -

# chown oracle:oinstall /dev/raw/raw1 /dev/raw/raw16

# ls -l /dev/raw/raw1 /dev/raw/raw16

crw-r----- 1 oracle oinstall 162, 1 Jun 25 2004 /dev/raw/raw1

crw-r----- 1 oracle oinstall 162, 16 Jun 25 2004 /dev/raw/raw16

This did not solve the problem.

According to 5.10 Raw Devices on Oracle Enterprise Linux and Red Hat Enterprise Linux in the release notes, the settings should be:

# OCR

chown root:oinstall /dev/raw/raw1

chown root:oinstall /dev/raw/raw2

chmod 660 /dev/raw/raw1

chmod 660 /dev/raw/raw2

# Voting Disks

chown oracle:oinstall /dev/raw/raw3

chown oracle:oinstall /dev/raw/raw4

chown oracle:oinstall /dev/raw/raw5

chmod 644 /dev/raw/raw3

chmod 644 /dev/raw/raw4

chmod 644 /dev/raw/raw5

According to Pro Oracle Database 10g Rac on Linux: Installation, Administration, and Performance (p.286), I should be doing:

# chown root:oinstall /dev/raw/raw1

# chmod 660 /dev/raw/raw1

This matches the release notes with respect to the OCR files.

Still get the same error.

I changed /etc/sysconfig/rawdevices to use the block device name instead of the device major and minor numbers. Restart the rawdevices service. Still get the same error.

Rebooted both richmond1 and richmond2. (When the rational fails, use the irrational.) Permissions are the same as before: crw-rw---- oracle oinstall. Now the installer accepts these as OCR files, but fails to accept the voting disks! (permission is crw-rw-r-- oracle oinstall)

Rebooted richmond1. Still get the same problem with the voting disks. Made the same changes on richmond2 and rebooted.

$ su -

# chown oracle:oinstall /dev/raw/raw1 /dev/raw/raw2 /dev/raw/raw16 /dev/raw/raw17 /dev/raw/raw31 /dev/raw/raw32

# chmod 660 /dev/raw/raw1 /dev/raw/raw16 /dev/raw/raw31

# chmod 664 /dev/raw/raw2 /dev/raw/raw17 /dev/raw/raw32

# vi /etc/sysconfig/rawdevices (change to block device names)

# reboot

The error message in the log is:

PathName = /dev/raw/raw2

INFO: Query Returned: 0

SEVERE: The specified shared raw partition /dev/raw/raw2 may not have correct permission. Verify that the partition is owned by Oracle User.

# ls -l /dev/raw/raw2

crw-rw-r-- 1 oracle oinstall 162, 2 Jun 25 2004 /dev/raw/raw2

And people wonder why computer people get paid so much! The instructions are wrong, the error messages are brief, and the experts got lucky.

Richmond Cluster (08)

Richmond Cluster (10)