Sun Cluster Data Service for Oracle Guide for Solaris OS

Creating an Oracle Database

After verifying the Oracle installation and configuration, create the Oracle databases that you require. If you are using Oracle without standby databases, perform the procedure How to Create a Primary Oracle Database. This procedure is not required for any additional databases that you might create and configure. If you are using Oracle DataGuard, create the following database instances:

ProcedureHow to Create a Primary 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.

    Note –

    If the database exists in the non-global zone, do not place the database-related files on the shared raw devices.

    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

    • The Oracle Database Configuration Assistant

    During creation, ensure that all the database-related files are placed in the appropriate location, either on shared global devices , on the cluster file system, or on a highly available local 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.

Next Steps

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