Installation guide

Under Oracle9i RAC, several issues have been noted with DBCA. If you follow the instrucons below, you should nish database cre-
aon without any problems. Nevertheless, it may prove helpful to create a trace le for the DBCA installaon. In case of a problem,
the trace le will help you determine the cause. To enable tracing, edit the le $ORACLE_HOME\bin. Edit line 40 to read like:
“E:\Program Files\Oracle\jre\1.1.8\BIN\JRE” -DTRACING.ENABLED=true
-DTRACING.LEVEL=2 -DORACLE_HOME=”%OH%” …
Database Creaon Tasks
DBCA will do a good job of creang required database les. One limitaon that you should be aware of is that DBCA is designed to
create data les on only one OCFS volume. If you want to place data les or log les on mulple OCFS volumes, you should move les
or create new les aer the database is created. The procedure to run DBCA and to create a seed database is as follows:
1. To start DBCA with tracing enabled, use the following command: dbca -dataleDesnaon O:\u01 > dbca_trace.txt
2. In the “Welcome” page, choose the “Oracle Cluster Database” opon. Click “Next”.
3. In the “Operaons” page, select “Create a Database”. Click “Next”.
4. In the “Node Selecons” page, choose all of the cluster nodes. Click “Next”. If the OracleGSDService is not running on any
node, you will receive instrucons on how to start the service.
5. On the “Database Templates” page, choose from the list of available database templates. To create a custom database,
choose “New Database”. Click “Next”.
6. In the “Database Idencaon” page, enter a “Global Database Name” and an “Oracle System Idener (SID) Prex”.
The Global Database Name is usually of the form name.domain. It is a Best Pracce to make the “name” equal to the SID.
The SID should be ve characters or less.
7. In the “Database Opons” page, choose any oponal database features that you want to install. You may also click on
the “Addional Database Opons” buon to congure addional opons such as Java and interMedia. By default, all of the
Addional Database Opons are turned on. It is recommended that you do not turn o any of these “Addional” opons,
since they may noceably impact database funconality.
8. In the “Connecon Opons” page, choose either the “Dedicated Server” or “Shared Server” opon. Click “Next”
9. The “Inializaon Parameters” page contains a number of opons on several dierent tabs:
a. For “Archivelog Mode”, the “Noarchivelog” opon is recommended throughout the database creaon period.
You can enable Archivelog mode later.
b. In the “DB Sizing” tab, you may edit the “db_block_size”, “sort_area_size”, and “database character set”
parameters.
c. In the “File Locaons” tab, the “Create persistent inializaon parameter le” is selected by default. This creates
a raw device le for the Server Parameter le (sple).
d. The “File Locaon Variables” buon displays variable informaon.
e. The “All Inializaon Opons” buon gives access to the “Inializaon Parameters” dialog box. This dialog box
allows you to edit a large variety of general and instance specic parameters. Aer you have edited all parameters
that you wish to edit, click “Next”.
10. In the “Database Storage Window”, tablespace names, le names and sizing parameters may be edited, along with redo
log informaon. Do not try to change the OCFS volume or base directory in this screen. Check the redo logs for the correct
thread numbers (one thread set of redo logs per node). Aer you have nished eding, click “Next”.