Sample Configurations with SGeRAC and Oracle RAC 10gR2, March 2009

7168000 35644 6686584 0% /cfs/mnt1

/dev/vx/dsk/cfsdg1/vol2

7168000 25644 6686584 0% /cfs/mnt2

/dev/vx/dsk/cfsdg1/vol3

307200 3264 284657 1% /cfs/mnt3

Viewing configuration

# cmviewcl

CLUSTER STATUS

cluster_mo up

NODE STATUS STATE

minie up running

mo up running

MULTI_NODE_PACKAGES

PACKAGE STATUS STATE AUTO_RUN SYSTEM

SG-CFS-pkg up running enabled yes

SG-CFS-DG-1 up running enabled no

SG-CFS-MP-1 up running enabled no

SG-CFS-MP-2 up running enabled no

SG-CFS-MP-3 up running enabled no

Prerequisites for Oracle 10g (sample installation)

These are sample steps to prepare a SGeRAC cluster for Oracle 10g. Consult Oracle documentation

for Oracle installation details.

Create groups on each node

Create the Oracle Inventory group if one does not exist, create the OSDBA group, and create the

Operator Group (optional).

# /usr/sbin/groupadd oinstall

# /usr/sbin/groupadd dba

# /usr/sbin/groupadd oper

Create Oracle User on each node

# /usr/bin/useradd –u 203 –g oinstall –G dba,oper oracle

Change password on each node

# passwd oracle

Enable remote access (ssh or remsh) for Oracle user on all nodes

For remsh, add oracle user to the .rhosts file or host.equiv file.

Create symbolic links

Required if Motif 2.1 Development Environment Package is not installed.

# ln -s /usr/lib/libX11.3 /usr/lib/libX11.sl

# ln -s /usr/lib/libXIE.2 /usr/lib/libXIE.sl

# ln -s /usr/lib/libXext.3 /usr/lib/libXext.sl

# ln -s /usr/lib/libXhp11.3 /usr/lib/Xhp11.sl

# ln -s /usr/lib/libXi.3 /usr/lib/libXi.sl

# ln -s /usr/lib/libXm.4 /usr/lib/libXm.sl

# ln -s /usr/lib/libXp.2 /usr/lib/libXp.sl