HP Serviceguard Extension for RAC (SGeRAC) manual Creating a RAC Demo Database, $ netca, $ dbca

Installing RAC Binaries on Cluster File System

Logon as a “oracle” user:

$ export ORACLE BASE=/cfs/mnt1/oracle

$ export DISPLAY={display}:0.0

$ cd <10g/11g RAC installation disk directory>

$ ./runInstaller

Use following guidelines when installing on a local file system:

1.In this example, the path to ORACLE_HOME is located on a CFS directory /cfs/mnt1/ oracle/product/<oracle version>/db_1.

2.Select installation for database software only.

3.When prompted, run root.sh on each node.

Creating a RAC Demo Database

This section demonstrates the steps for creating a demo database with datafiles on raw volumes with SLVM or CVM, or with Cluster File System (on HP-UX releases that support them. See “About Veritas CFS and CVM from Symantec” (page 15)).

Before setting up Listeners using netca, verify that listeners are already configured as part of Clusterware installation or not. If listeners are configured, then there is no need of configuring them again unless there is a specific requirement.

Creating a RAC Demo Database on SLVM or CVM

Export environment variables for “oracle” user:

export ORACLE_BASE=/mnt/app/oracle

export DBCA_RAW_CONFIG=/mnt/app/oracle/oradata/ver10/ver10_raw.conf

export ORACLE_HOME=$ORACLE_BASE/product/<oracle version>/db_1

export ORA_CRS_HOME=/mnt/app/crs/oracle/product/<oracle version>/crs

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:$ORACLE_HOME/rdbms/lib

SHLIB_PATH=$ORACLE_HOME/lib32:$ORACLE_HOME/rdbms/lib32 export LD_LIBRARY_PATH SHLIB_PATH

export PATH=$PATH:$ORACLE_HOME/bin:$ORA_CRS_HOME/bin:/usr/local/bin:

CLASSPATH=$ORACLE_HOME/jre:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib export CLASSPATH

export DISPLAY={display}:0.0

NOTE: The following procedure is only applicable up to Oracle 11gR1. If you prefer to use SLVM storage for Oracle 11gR2, see Oracle Database 11g Release 2 Real Application Clusters with SLVM/RAW on HP-UX Installation Cookbook http://h18006.www1.hp.com/storage/pdfs/ 4AA2-7668ENW.pdf.

1.Set up listeners with Oracle network configuration assistant (If the listeners are not configured.).

Use the Oracle network configuration assistant to configure the listeners with the following command:

$ netca

2.Create database with Oracle database configuration assistant.

Use the Oracle database configuration assistant to create the database with the following command:

$ dbca

Use following guidelines when installing on a local file system:

a.In this sample, the database name and SID prefix are ver10.

b.Select the storage option for raw devices.

Creating a RAC Demo Database 63