Sample Configuration with HP Serviceguard Extension for RAG and Oracle Real Application Clusters 11g release 2 using Cluster File System

23
Create RAC demo database on CFS
Export environment variables for “oracle” user
export ORACLE_BASE=/cfs/mnt1/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORA_CRS_HOME=/u01/app/11.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:
$ORACLE_HOME/network/jlib
export CLASSPATH
export DISPLAY={display}:0.0
Create demo database with Database Configuration Assistant
$ dbca
Notes:
1. Unless specified, the default options are used.
2. Select Oracle RAC database.
3. Select Create a Database.
4. Select General Purpose template.
5. Provide Global Database Name.
– In this sample configuration, the global database name and SID prefix are “orcl”.
– Select all nodes.
6. Select Management Options.
– In this sample, use default parameters (Configure Enterprise Manager and Configure Database
Control for local management).
7. Provide passwords for user accounts.
8. Specify Database File Locations.
– In this sample, select CFS for the Storage Type.
– In this sample, choose “Use Common Location for all Database Files” and enter
/cfs/mnt2/oradata as the common directory for Database File Location.
9. Choose Recovery Configuration.
– In this sample, use default parameters (Flash Recovery Area configured) and select
Enable Archiving.
– If Flash Recovery Area is configured, archive logs default to the Flash Recovery area.
– With CFS, the archives must be on a file system that can be accessed by any node that
will be performing a database recovery.
Note: If the Flash Recovery Area is configured, it should not be the same as the Database File
Location.
10. Select Database Content.
– In this sample, use default parameters (do not select Sample Schemas).
11. Configure Initialization Parameters.
– In this sample, use default parameters (Typical and Use Automatic Memory Management).