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

23
Creating a RAC demo database on SLVM
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/10.2.0/db_1
export ORA_CRS_HOME=/mnt/app/crs/oracle/product/10.2.0/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:$ORA
CLE_HOME/network/jlib
export CLASSPATH
export DISPLAY={display}:0.0
Setting up listeners with Oracle Network Configuration Assistant
$ netca
Notes:
1. Select Cluster Configurations
2. Select all nodes
3. Select Listener configuration
4. Select Add
5. Provide Listener name
6. Select Protocols
7. Select TCP/IP port number for listener
Creating demo database with Database Configuration Assistant
$ dbca
Unless specified, the default options are used. Notes:
1. Unless specified, the default options are used.
2. Select Oracle Real Application Clusters database
3. Select Create a Database
4. Select all nodes
5. Select General Purpose template
6. Provide Global Database Name
a. In this sample, the global database name and SID prefix are “ver10”.
7. Select Management Options
a. In this sample, no management options chosen.
8. Provide passwords for user accounts
9. Select Listeners to register database
a. In this sample, the listeners used are “LISTENER_EENIE” and “LISTENER_MEENIE”.
10. Select Storage Options
a. In this sample, Select the storage option for Raw Devices
11. Provide Raw Device Mapping File Location
a. In this sample, the file is located at
/mnt/app/oracle/oradata/ver10/ver10_raw.conf.