3.7.0 HP StorageWorks MxDB-Oracle-HiAv installation and administration guide HP MxDB-Oracle-HiAv for Linux (AG513-96009, June 2009)

filesystem. This filesystem is mounted with the normal filesystem options but not the
dboptimize option. (Note that PSFS filesystems also support asynchronous IO.)
Because oradata is, by OFA standards, the root directory for Oracle datafiles, it
must be physically located on the dboptimized filesystem. Also, OFA naming
convention requires oradata to be located at either $ORACLE_HOME/oradata or
$ORACLE_BASE/oradata. To satisfy both conditions, as user root, first create a
subdirectory named oradata under the dboptimized mount point. Then create a
soft link called oradata from $ORACLE_BASE (or $ORACLE_HOME) to
<mountpoint>/oradata. In the following example, the mount point is /u02 and
we will use $ORACLE_BASE.
cd /u02 # dboptimized mount point
mkdir oradata
cd /u01/app/oracle # $ORACLE_BASE
ln –s /u02/oradata oradata
Be sure to use the same mount point name (/u02/ in the above example) for the
dboptimized filesystem on each node in the cluster. This ensures that the database
will be found in the right location after a failover.
To see the mount options used for a particular filesystem, run the mx fs status
command. In the following example, the psv4 filesystem is mounted with the
dboptimize option.
mx fs status --mounted
FS psv4 (ORADATA) MOUNTED(/u02) rw,async,dev,exec,suid,dboptimize,
shared,data=ordered tmr6.customer.com
After creating the necessary PSFS filesystems, note the following:
• On each server in the cluster, it is important that the Oracle user (that is, user
“oracle”) has the same user ID and all groups (such as group dba or oinstall)
have the group ID.
• The Oracle user must be a member of the pmxs group. When you are logged in
as user oracle, the output from the id command shows pmxs in the list of groups.
For example:
$ id
uid=500 (oracle) gid=1000(dba) groups=1001(oinstall),11(pmxs)
• The administrator needs to set up permissions for the oracle user (e.g., “oracle”).
For example:
# chown –R oracle:oinstall/u01
# chown –R oracle:oinstall/u02
MxDB-Oracle-HiAv installation and administration guide 15