Using Serviceguard Extension for RAC, 4th Edition, February 2007

Serviceguard Configuration for Oracle 9i RAC

Oracle Demo Database Files

Chapter 3154

Create these files if you wish to build the demo database. The three

logical volumes at the bottom of the table are included as additional data

files, which you can create as needed, supplying the appropriate sizes. If

your naming conventions require, you can include the Oracle SID and/or

the database name to distinguish files for different instances and

different databases. If you are using the ORACLE_BASE directory

structure, create symbolic links to the ORACLE_BASE files from the

appropriate directory.

Example:

# ln -s /dev/vx/rdsk/ops_dg/opsctl1.ctl \

/u01/ORACLE/db001/ctrl01_1.ctl

Example, Oracle9:

1. Create an ASCII file, and define the path for each database object.

control1=/dev/vx/rdsk/ops_dg/opsctl1.ctl

control1=/u01/ORACLE/db001/ctrl01_1.ctl

2. Set the following environment variable where filename is the name

of the ASCII file created.

# export DBCA_RAW_CONFIG=<full path>/filename

opsundotbs1.dbf 320 /dev/vx/rdsk/ops_dg/opsundotbs1.dbf 312

opsundotbs2.dbf 320 /dev/vx/rdsk/ops_dg/opsundotbs2.dbf 312

opsexample1.dbf 168 /dev/vx/rdsk/ops_dg/opsexample1.dbf 160

opscwmlite1.dbf 108 /dev/vx/rdsk/ops_dg/opscwmlite1.dbf 100

opsindx1.dbf 78 /dev/vx/rdsk/ops_dg/opsindx1.dbf 70

Table 3-3 Required Oracle File Names for Demo Database (Continued)

Volume Name

Size

(MB) Raw Device File Name

Oracle

File Size

(MB)