Configuring Single Instance Applications in CFS/CVM Environments in Continentalclusters, November 2006

3.3 Creating Oracle Database

The Oracle database is created only on the primary site and it is replicated to the recovery site

through the respective disk array replication technologies like HP Storage Works XP Continuous

Access, and EMC Symmetrix Remote Data Facility (SRDF). The SG-CFS system MNP package should

be up and running in the cluster at the primary site. In case of CVM, the dependent DG MNP

packages should be up and in case of CFS, the dependent MP MNP packages and the dependent

DG MNP packages should be up and running in the cluster.

The replication between the underlying disks between the primary and the recovery cluster must be

changed to split state. The following command splits the replication pair configured under Continuous

Access XP replication technology.

pairsplit –g <diskgroup> -rw

The following command splits the replication pair configured under EMC SRDF replication technology.

symrdf –g <diskgroup> split

The Oracle database is created with the Database Configuration Assistant (dbca) tool provided by

Oracle. For CVM, a mapfile should be created containing the location of the logical volumes as

below.

1) Create the mapfile that looks similar to the following

system=/dev/vx/rdsk/<disk_group_name>/ora_system_raw_500m

sysaux=/dev/vx/rdsk/<disk_group_name>/ora_sysaux_raw_800m

users=/dev/vx/rdsk/<disk_group_name>/ora_users_raw_120m

temp=/dev/vx/rdsk/<disk_group_name>/ora_temp_raw_250m

undotbs1=/dev/vx/rdsk/<disk_group_name>/ora_undotbs1_raw_500m

redo1_1=/dev/vx/rdsk/<disk_group_name>/ora_redo1_1_raw_120m

redo1_2=/dev/vx/rdsk/<disk_group_name>/ora_redo1_2_raw_120m

control1=/dev/vx/rdsk/<disk_group_name>/ora_control1_raw_110m

control2=/dev/vx/rdsk/<disk_group_name>/ora_control2_raw_110m

spfile=/dev/vx/rdsk/<disk_group_name>/ora_spfile_raw_5m

pwdfile=/dev/vx/rdsk/<disk_group_name>/ora_pwdfile_raw_5m

2) Provide this mapfile to the dbca while creating the database.

3) Login in as Oracle user.

4) Run the dbca command on the console.

$su - oracle

$dbca &

In case of CFS, the mounted directory [ /cfs/mnt1 ] should be presented to the dbca during creation

of the database.

1) Login in as Oracle user.

2) Run the dbca command on the console.

$su - oracle

$dbca &