test

Sun Cluster 3.0 Data Services Installation and Configuration Guide

Creating an Oracle Database

Complete both procedures in this section to configure and create the initial Oracle database in a Sun Cluster configuration. If you are creating and configuring additional databases, perform only the procedure, "How to Create an Oracle Database".

How to Configure Oracle Database Access

  1. Configure the disk devices for use by your volume manager.

    For more information, see the appendix for your volume manager in the Sun Cluster 3.0 Installation Guide.

  2. If you are using Solstice DiskSuite, set up UFS logging or raw mirrored meta devices on all the nodes that are running Sun Cluster HA for Oracle.

    If you are using raw devices to contain the databases, change the owner, group, and mode of each of the raw mirrored meta devices and verify the changes. If you are not using raw devices, skip this step. Instructions for configuring raw devices are provided in the Sun Cluster 3.0 Installation Guide.

    If you are creating raw devices, type the following commands for each device on each node that can master the Oracle resource group:


    # chown oracle_id /dev/md/disk_device_group/rdsk/dn
# chgrp dba_id /dev/md/disk_device_group/rdsk/dn
# chmod 600 /dev/md/disk_device_group/rdsk/dn

    Verify that the changes have taken effect.


    # ls -lL /dev/md/disk_device_group/rdsk/dn

  3. If you are using VERITAS Volume Manager, set up UFS logs or raw devices on all the nodes.

    For information about Solaris UFS logging, see the mount_ufs(1M) man page and the Solaris Transition Guide. If you are using raw devices to contain the databases, change the owner, group, and mode of each device. If not, skip this step.

    If you are creating raw devices, type the following command for each raw device:


    # vxedit -g disk_device_group set user=oracle_id \
group=dba mode=600 volume_name

    Verify that the changes have taken effect.


    # ls -lL /dev/vx/rdsk/disk_device_group/volume_name

    Next, re-register the disk device group with the cluster. This step is necessary to keep the VxVM namespace consistent throughout the cluster. If you are using Solstice DiskSuite, you can skip this step.


    # scconf -c -D name=disk_device_group

How to Create an Oracle Database

  1. Prepare database configuration files.

    Place all database-related files (data files, redolog files, and control files) on either shared raw global devices or the cluster file system. For information on installation locations, refer to "Preparing to Install Sun Cluster HA for Oracle".

    Within the init$ORACLE_SID.ora or config$ORACLE_SID.ora file, you might need to modify the assignments for control_files and background_dump_dest to specify the locations of the control files and alert files.

    Note -

    If you are using Solaris authentication for database logins, set the remote_os_authent variable in the init$ORACLE_SID.ora file to True.

  2. Create the database.

    Start the Oracle installer and select the option to create a database. Alternatively, depending on your Oracle version, you can create the database by using the Oracle svrmgrl command.

    During creation, ensure that all database-related files are placed in the appropriate location: either on shared global devices or on the cluster file system.

  3. Verify that the file names of your control files match the file names in your configuration files.

  4. Create the v$sysstat view.

    Run the catalog scripts that create the v$sysstat view. The Sun Cluster fault monitoring scripts use this view.

Where to Go from Here

When you have completed the work in this section, go to "Setting Up Oracle Database Permissions".