Oracle Tips by Burleson

Oracle10g Grid Computing with RAC
Chapter 6 - Install, Configure and Database Creation

Database Creation Manually

Edit init.ora and set appropriate values for the 2nd instance on the 2^nd Node (Names may need to be modified):

instance_name=RACDB2
instance_number=2
local_listener=LISTENER_RAC2
thread=2
undo_tablespace=UNDOTBS2

From the first instance, run the following command:

alter database
add logfile thread 2
group 4 ('/dev/RAC/redo2_01_100.dbf') size 100M ,
group 5 ('/dev/RAC/redo2_02_100.dbf') size 100M ,
group 6 ('/dev/RAC/redo2_03_100.dbf') size 100M ;

Then make thread available by:

alter database enable public thread 2;

Start the second instance (assuming that the cluster configuration is up and running). At this point, the Oracle database is installed, patched, and running on all members of the cluster.

Did you notice that the SYSAUX tablespace is specified with the CREATE DATABASE command. This is demonstrated in the example database creation script.