5.2.4 How to Create an Oracle Database

These are the high-level steps to create an Oracle database:

• Preparing the database configuration files

• Creating the database

• Creating the v$sysstat view

These are the detailed steps to create an Oracle database.

1. Prepare database configuration files.

   Place all parameter files, data files, redolog files, and control files on the logical host, that is, the disk group's multihost disks.

   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 location of control files and alert files on the logical host.

   ---

   Note -

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

   ---

   Full path names must be provided for background_dump_dest. The special character ? for specifying ORACLE_HOME should not be used.

2. Create the database.

   During creation, ensure that all configuration and database files are placed on the logical hosts.

   1. Start the Oracle installer (orainst) and select the Create New Database Objects option.

   2. During the orainst session, place all the database files on the logical hosts.

      Override the default file locations provided by the Oracle installer.

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

      Alternatively, you can create the database using the Oracle svrmgrl command, depending on your Oracle version.

3. Create the v$sysstat view.

   Run the catalog scripts that create the v$sysstat view. This view is used by the Sun Cluster fault monitoring scripts.