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 volumes

Repeat the following steps for all the volumes to be created.

To create dynamic volumes

  1. Launch Veritas Enterprise Administrator from the Apps menu on the Start screen.

    Select a profile if prompted.

  2. Click Connect to a Host or Domain.
  3. In the Connect dialog box select the host name from the pull-down menu and click Connect.

    To connect to the local system, select localhost. Provide the user name, password, and domain if prompted.

  4. To start the New Volume wizard, expand the tree view under the host node to display all the disk groups. Right click a disk group and select New Volume from the context menu.

    You can right-click the disk group you have just created.

  5. At the New Volume wizard opening screen, click Next.
  6. Select the disks for the volume.
    • Make sure the appropriate disk group name appears in the Group name drop-down list.

    • For Site Preference, leave the setting as Siteless (the default).

    • Automatic disk selection is the default setting. To manually select the disks, click Manually select disks and use the Add and Remove buttons to move the appropriate disks to the Selected disks list. Manual selection of disks is recommended.

    • You may also check Disable Track Alignment to disable track alignment for the volume. Disabling Track Alignment means that the volume does not store blocks of data in alignment with the boundaries of the physical track of the disk.

    • Click Next.

  7. Specify the volume attributes
    • Enter a volume name. The name is limited to 18 ASCII characters and cannot contain spaces or forward or backward slashes.

    • Select a volume layout type. To select mirrored striped, click both the Mirrored checkbox and the Striped radio button.

    • If you are creating a striped volume, the Columns and Stripe unit size boxes need to have entries. Defaults are provided.

    • Provide a size for the volume.

    • If you click on the Max Size button, a size appears in the Size box that represents the maximum possible volume size for that layout in the dynamic disk group.

    • In the Mirror Info area, select the appropriate mirroring options.

    • Click Next.

  8. In the Add Drive Letter and Path dialog box, assign a drive letter or mount point to the volume. You must use the same drive letter or mount point on all systems in the cluster. Make sure to verify the availability of the drive letter before assigning it.
    • To assign a drive letter, select Assign a Drive Letter, and choose a drive letter.

    • To mount the volume as a folder, select Mount as an empty NTFS folder, and click Browse to locate an empty folder on the shared disk.

  9. Click Next.
  10. Create an NTFS file system.
    • Make sure the Format this volume checkbox is checked and click NTFS.

    • Select an allocation size or accept the Default.

    • The file system label is optional. SFW makes the volume name the file system label.

    • Select Perform a quick format if you want to save time.

    • Select Enable file and folder compression to save disk space. Note that compression consumes system resources and performs encryption and decryption, which may result in reduced system performance.

    • Click Next.

  11. Click Finish to create the new volume.
  12. Repeat these steps to create additional volumes.

    Create the cluster disk group and volumes on the first node of the cluster only.