Installing 11gR2 Real Application Clusters on Oracle Enterprise Linux 4 x86-64 (64 bit)
Creating the Rac Database
This document provides a step by step guide to, installing Oracle 11gR2 Real Application clusters on Oracle Enterprise Linux 4, x86-64 (64 Bit).
Keep in mind, this is a test installation and hence does not follow some of the best practices for installing oracle real application clusters (eg: use a separate o/s user for oracle grid infrastructure, have at least 3 voting disks etc...).
This document assumes that you have followed the documents 11gR2RacInstall-gridinfra and 11gR2RacInstall-rac to install and configure the oracle grid infrastructure and real application clusters. In this document I have the steps to Create the Rac database.
Creating the 11gR2 Rac Database
Login as oracle to one of the servers.
Set the ORACLE_HOME to your real application clusters ORACLE_HOME (eg: /u01/app/oracle/product/11.2.0/db). make sure you do not set it to the grid infrastructure home.
set PATH=$ORACLE_HOME/bin:$ORACLE_HOME
Make sure that the listener and the SCAN listener are running from the grid infrastructure home.
Run the command dbca
In the screen above, choose "Oracle Real Application Clusters database", click Next.
In the screen above, choose, "Create a database", click Next.
In the screen above, choose, "General purpose transaction processing" database, and click Next.
The screen above is one of the only changes in the dbca screens from the 10g and 11gr1 screens.
Here you have an option to choose Policy-Managed or Admin-Managed configuration. If You choose Admin-Managed then the servers are not part of any server pool, and are managed manually by the administrator. When it is policy-managed, oracle creates server pools and capacity is added and removed from the server pools based on your server pool definitions.
In 11gr2 and above it is recommended to create and use Policy-Managed databases.
In my test installation i choose "Admin-Managed", press Next to continue.
In the above screen, choose the defaults and click on Next (So that enterprise manager database control will be configured).
In the above screen, choose the passwords for the administrative logins.
In the above screen, Choose Oracle-Managed files and +DATA as the diskgroup to be used for the database.
+DATA was created when we installed and configured the grid infrastructure.
Click Next
In the above screen, You will be prompted for the asmsnmp password, provide the password and click ok.
In the above screen, i chose not to configure FRA or Archiving. Since this is a test system.
Click Next to continue.
In the above screen, choose to create the sample schemas, click Next
In the above screen, choose the SGA size to be something reasonable for your server. Click Next.
Review the summary screen above, and make any additional changes, click Next.
In the above screen, choose "create database", click Finish.
Review the information in the summary screen and click "Ok".
Once the database creation is complete, click Exit to exit from dbca.
Now your 11gr2 real application clusters install and database creation are complete.
