Cluster Server 7.4.2 Database Agent for Oracle Configuration Guide - Windows

Last Published:
Product(s): InfoScale & Storage Foundation (7.4.2)
Platform: Windows
  1. Introducing the VCS agent for Oracle
    1. About the VCS agent for Oracle
      1.  
        About the Oracle agent
      2.  
        About the Netlsnr agent
      3.  
        About the Info function
      4.  
        About the Action function
    2.  
      How application availability is achieved in a physical environment
    3.  
      How the agent makes Oracle highly available
    4.  
      Typical Oracle configuration in a VCS cluster
  2. Installing the product and configuring VCS
    1.  
      About installing the VCS agents
    2. Configuring the cluster using the Cluster Configuration Wizard
      1.  
        Configuring notification
      2.  
        Configuring Wide-Area Connector process for global clusters
  3. Installing and configuring Oracle
    1.  
      About installing Oracle
    2. Prerequisites for installing Oracle
      1.  
        Privilege requirements
    3.  
      Installing Oracle
    4.  
      About creating and configuring Oracle
    5.  
      Prerequisites for configuring Oracle
    6. Managing Storage using SFW
      1.  
        Creating disk groups
      2.  
        Importing disk groups
      3.  
        Creating volumes
      4.  
        Mounting volumes
    7.  
      Creating a temporary service group
    8. Configuring Oracle on the first node
      1.  
        Bringing the temporary service group online
      2.  
        Creating the Oracle database on shared disks
      3.  
        Creating the listener service
      4.  
        Configuring the listeners to use the virtual IP address
      5. Associating the database with the listener
        1.  
          Prerequisites to associate the databases with the listeners
      6. Configuring the Oracle database
        1.  
          Updating the tnsnames.ora files
        2.  
          If you use a PFILE (initSID.ora)
        3.  
          If you use an SPFILE
        4.  
          Modifying the SPFILE
        5.  
          Moving the initialization file to shared disks
        6.  
          Setting the Oracle database parameters
        7.  
          Verifying the initialization file settings
      7.  
        Configuring the Oracle and listener services
      8.  
        Dismounting a volume
    9.  
      Configuring Oracle on failover nodes
  4. Configuring the Oracle service group
    1.  
      About configuring the Oracle service group
    2.  
      Deleting the temporary service group
    3. About configuring the Oracle service group using the wizard
      1.  
        Prerequisites for configuring the Oracle service group
      2. Creating an Oracle service group using the wizard
        1.  
          About the modifications required for tagged VLAN or teamed network
      3.  
        Configuring dependent services
    4. Verifying the Oracle service group configuration
      1.  
        Bringing the service group online
      2.  
        Taking the service group offline
      3.  
        Switching the service group
      4.  
        Disabling the service group
    5.  
      Reconfiguring the Oracle service group
  5. Administering the Oracle service group
    1.  
      About administering the Oracle service group
    2. About modifying an Oracle service group
      1.  
        Prerequisites for modifying the Oracle service group
      2.  
        Modifying an Oracle service group
    3.  
      Deleting an Oracle service group
    4. Configuring detail monitoring
      1.  
        Enabling detail monitoring
      2.  
        Disabling detail monitoring
  6. Troubleshooting
    1.  
      About troubleshooting VCS agents
    2.  
      Troubleshooting common problems
    3. VCS logging
      1.  
        VCS Cluster Configuration Wizard (VCW) logs
      2.  
        VCWsilent logs
    4. Agent error messages and descriptions
      1.  
        NetApp agents
      2.  
        Oracle agent
      3.  
        Netlsnr agent
  7. Appendix A. Resource type definitions
    1.  
      About resource type definitions
    2. Oracle agent
      1.  
        Resource type definition
      2.  
        Attribute definitions
    3. Netlsnr agent
      1.  
        Resource type definition
      2.  
        Attribute definitions
  8. Appendix B. Sample configuration
    1.  
      About Oracle sample configurations
    2.  
      Sample configuration file
  9. Appendix C. Oracle Enterprise Manager 10g Grid Control with VCS
    1.  
      About Oracle Enterprise Manager 10g Grid Control with VCS
    2.  
      Installing the VCS agent for Oracle
    3.  
      Installing Oracle Enterprise Manager server
    4.  
      Installing Oracle
    5.  
      Installing the Oracle Management Agent
    6.  
      Creating and configuring Oracle database and listener on the first node
    7.  
      Configuring Oracle on failover nodes
    8.  
      Configuring the Oracle service group
    9.  
      Configuring a virtual network name
    10.  
      Configuring the listener for virtual network name
    11.  
      Configuring the database service for virtual network name
    12.  
      Configuring an additional Oracle management agent
    13.  
      Adding the database to the OEM 10g Grid Control
    14. Making the additional agent highly available
      1.  
        Sample Configuration

Creating the Oracle database on shared disks

Create an Oracle database on the shared disk using the Oracle Database Configuration Assistant. You need to create the database only once, from the node on which you installed Oracle first. You do not need to repeat these steps on the remaining cluster nodes.

To create a database on a shared disks

  1. Start the Oracle Database Configuration Assistant from the Apps menu on the Start screen. This launches the database installer.
  2. In the Welcome panel, click Next.
  3. In the Operation panel, select Create a database and click Next.
  4. Complete the iinstructions given below depending on the Oracle version.

    • In the Database Templates panel, select the desired database template and click Next.

    • In the Database Identification panel, specify the Global Database Name and SID in the respective fields.

    • Choose to create the database on the shared disk.

  5. The wizard instructions help you to select other options as per your desired database configuration. Install the control files, data files, log files, bdump, cdump, and udump files on the shared disk.

    Follow these wizard instructions:

    • On the Recovery Configuration panel, specify the Flash Recovery Area and the Archiving location on the shared disk.

    • On the Initialization Parameters panel, click All Initialization Parameters, then click Show All Parameters on the All Initialization Parameters window, and then specify the path for the background_dump_dest (bdump), core_dump_dest (cdump), and user_dump_dest (udump) files.

    • In the Database Storage panel, specify the locations of control files, data files, and redo log files. In the left pane, expand the Storage folder and do the following:

      • Enter a path on the shared disk for each control file.

        To do so, click Controlfile and click the General tab in the right pane. In the File Directory field, enter a path on the shared disk.

      • Enter a path on the shared disk for each data file.To do so, expand the Datafiles folder in the left pane. Select a data file, and click the General tab in the right pane. In the File Directory field, enter a path on the shared disk.

      • Enter a path on the shared disk for each redo log file.

        To do so, expand the Redo Log Groups folder in the left pane. Select a redo log group and click the General tab in the right pane. In the File Directory field, enter a path on the shared disk.

        The path for the redo log files must be the same as that of the bdump, cdump, and udump files, specified earlier.

      • Click Next.

  6. Select the Create database and the Generate Database Creation Scripts options and click Finish.
  7. Follow the wizard instructions and complete the installation.