Configuring the Oracle database

Configure an Oracle database on shared disks using the Database Configuration Assistant. You need to configure the database only once, from the node on which you installed Oracle first.

If you configured ASM for Oracle database storage, configure the Oracle database on ASM disk groups.

To configure the Oracle9i database

  1. Set the DISPLAY variable and start the Oracle Database Configuration Assistant as Oracle User.

    # dbca
  2. Read the Welcome screen, click Next.

  3. On the Operations dialog box, select the Create a database option and click Next.

  4. On the Database Templates dialog box, select a template to create the database and click Next.

  5. On the Database Identification dialog box, enter or select a unique name and SID for the global database and click Next.

  6. On the Database Connection Options dialog box, select the Dedicated Server Mode or the Shared Server Mode and click Next.

  7. On the Initialization Parameters dialog box, specify the locations of the archive logs and the initialization parameter files:

    • If you want to enable archive logs for the database, click the Archive tab and select the Archive Log Mode check box. In the Archive Log Destination(s) list, enter a path on the shared disk to ensure that the Archive Log is created on the shared disk.

    • Click the File Locations tab.

    • If installing Oracle locally on all systems, make sure that the initialization parameter file and the trace file directories are on the local disk.

    • Modify other parameters, if desired.

    • Click Next.

  8. On the Database Storage dialog box, specify the locations of the Control, Data, and Redo log files:

    • In the left pane, expand the Storage folder by clicking the + next to it.

    • Click Controlfile and click the General tab in the right pane.

    • In the File Directory field, enter a path on the shared disk for each control file.

    • Expand the Datafiles folder by clicking the + next to it.

    • Select the datafile in the left pane and click the General tab in the right pane. In the Name field, enter a path on the shared disk for each datafile.

    • Expand the Redo Log Groups folder by clicking the + next to it.

    • Select the Redo Log file in the left pane. In the File Directory field in the right pane, enter the path of a directory on the shared disk for each Redo Log file. Specify file sizes for the Redo Log files, if desired.

    • Click Next.

  9. On the Creation Options dialog box, select the Create Database check box and click Finish.

  10. On the Summary dialog box, review your selections and click OK.

To configure the Oracle 10g or Oracle 11g database

  1. Set the DISPLAY variable and start the Oracle Database Configuration Assistant as Oracle User.

    # dbca
  2. Read the Welcome screen, click Next.

  3. In the Operations dialog box, select the Create a database option and click Next.

  4. In the Database Templates dialog box, select a template to create the database and click Next.

  5. In the Database Identification dialog box, enter or select a unique name and SID for the global database and click Next.

  6. Follow the wizard instructions and select other options.

  7. In the Storage Options dialog box, select the File System or Raw Devices option and click Next.

    If you configured ASM, select Automatic Storage Option (ASM) and click Next.

  8. If you configured ASM, in the ASM Disk Groups dialog box, select the ASM disk group for the Oracle database storage and click Next.

  9. In the Database File Locations dialog box, specify a location on the shared disk for the database files to be created and click Next.

    If you configured ASM, choose Use Oracle-Managed Files, specify the database area, and click Next.

  10. In the Recovery Configuration dialog box, specify the Flash Recovery Area on the shared disk and click Next.

    If you configured ASM, specify the appropriate Flash Recovery Area location and click Next.

  11. If you use Oracle 11g, in the Security Settings dialog box, choose the recommended security setting. Choose the Keep the enhanced 11g default security settings option and click Next.

  12. Follow the wizard instructions and complete creating the database.