Sun Cluster Data Service for Oracle Guide for Solaris OS

Creating an Oracle Database

This section contains the procedure to configure and create the initial Oracle database in a Sun Cluster environment. If you create and configure additional databases, omit the procedure How to Create an Oracle Database.

How to Create an Oracle Database

  1. Prepare database configuration files.

    Place all of the database-related files (data files, redo log files, and control files) on either shared raw global devices or on the cluster file system. See Preparing the Nodes and Disks for information about installation locations.

    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 use Solaris authentication for database logins, set the remote_os_authent variable in the init$ORACLE_SID.ora file to True.

  2. Start the creation of the database by using one utility from the following list:

    • The Oracle installer

    • The Oracle sqlplus(1M) command

    During creation, ensure that all of the 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 HA for Oracle fault monitor uses this view.

Where to Go From Here

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