How to Create an Oracle Database

Before You Begin

Have available your Oracle installation documentation. Refer to those procedures to perform the following tasks.

1. On phys-sun, prepare the database configuration files.

   • Place all of the database-related files (data files, redo log files, and control files) on the /oradata/10gR2 directory.

   • Within the init$ORACLE_SID.ora file or the config$ORACLE_SID.ora file, modify the assignments for control_files and background_dump_dest to specify the location of the control files.

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

   • The Oracle Database Configuration Assistant (DBCA)

   • The Oracle sqlplus(1M) command

   During creation, ensure that all of the database-related files are placed in the /oradata/10gR2 directory.

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.