Oracle Tips by Burleson

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

Database Creation Manually

When the database is created manually, there is complete control over the process. Tablespaces can be added or reduced and the flow of the creation process can be managed. Here are the steps to be followed to create a Real Application Clusters database manually:

Make init.ora in the $ORACLE_HOME/dbs directory. On Windows, this file is in $ORACLE_HOME\database. To simplify, init.ora can be copied to init.ora and the file modified. Remember that the control file must be pointing to a pre-existing raw device or cluster file system location or ASM storage pool. Path names, file names, and sizes will need to be modified.

Here are some example parameter settings for the first instance:
Cluster-Wide Parameters for Database "RAC":
 
db_block_size=8192
db_cache_size=52428800
background_dump_dest=/u01/app/oracle/product/10.0.2/rdbms/lo
core_dump_dest=/u01/app/oracle/product/10.0.2/rdbms/log
user_dump_dest=/u01/app/oracle/product/10.0.2/rdbms/log
timed_statistics=TRUE
control_files=("/dev/RAC/control_01.ctl", "/dev/RAC/control_02.ctl")
db_name=RAC
shared_pool_size=52428800
sort_area_size=524288
undo_management=AUTO
cluster_database=true
cluster_database_instances=2
remote_listener=LISTENERS_RAC