Cluster Server 7.3.1 Implementation Guide for Oracle - Windows

Last Published:
Product(s): InfoScale & Storage Foundation (7.3.1)
  1. Introducing the VCS agents for Oracle and NetApp
    1.  
      About the VCS agents for Oracle and NetApp
    2. 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
    3. About the VCS hardware replication agent for NetApp
      1.  
        About the NetApp Filer agent
      2.  
        About the NetApp SnapDrive agent
      3.  
        About the NetApp SnapMirror agent
    4.  
      How the agent makes Oracle highly available
    5.  
      Typical Oracle configuration in a VCS cluster
  2. Installing 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.  
      Configuring Microsoft iSCSI initiator
    7. Managing storage using Windows Logical Disk Manager
      1.  
        Reserving disks (if you use Windows LDM)
      2.  
        Creating volumes (if you use Windows LDM)
      3.  
        Mounting volumes (if you use Windows LDM)
      4.  
        Unassigning a drive letter
      5.  
        Releasing disks (if you use Windows LDM)
    8. Managing storage using NetApp filer
      1.  
        Connecting virtual disks to the cluster node
      2.  
        Disconnecting virtual disks from the cluster nodes
    9.  
      Creating a temporary service group
    10. Configuring Oracle on the first node
      1.  
        Dismounting a volume
      2.  
        Bringing the temporary service group online
      3.  
        Creating the Oracle database on shared disks
      4.  
        Creating the listener service
      5.  
        Configuring the listeners to use the virtual IP address
      6. Associating the database with the listener
        1.  
          Prerequisites to associate the databases with the listeners
      7. 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 PFILE (Oracle 9i only)
        5.  
          Modifying the SPFILE
        6.  
          Moving the initialization file to shared disks (Oracle 10g and 11g)
        7.  
          Setting the Oracle database parameters
        8.  
          Verifying the initialization file settings
      8.  
        Configuring the Oracle and listener services
      9.  
        Disconnecting virtual disks from the first node
      10.  
        Releasing disks (if you use Windows LDM)
    11.  
      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.  
        Oracle agent
      2.  
        Netlsnr agent
      3.  
        NetApp agents
  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
      1.  
        Sample configuration file
      2.  
        Sample configuration file using iSCSI initiator
      3.  
        Sample configuration file using FC initiator
  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

Installing Oracle

Complete these steps to install Oracle. The installer screens and options may vary slightly for different versions of Oracle.

Refer to the Oracle documentation for detailed installation steps.

While installing Oracle, note the following:

  • Install Oracle in software only mode. Do not configure the Oracle database while installing Oracle on additional cluster nodes.

  • Install the Oracle software program files on a local disk.

    To ensure application installations are identical, the values you specify while installing Oracle must be the same on all nodes.

    For example, the database name, file locations, database credentials must be the same on all cluster nodes.

  • The Oracle Home name and path should be the same on all the cluster nodes.

  • Do not create the Oracle Starter database.

To install Oracle

  1. Insert the Oracle software disc in a drive connected to the node and run the Setup program.
  2. Complete the instructions given below, depending on the version of Oracle.

    For Oracle 9i version, follow these steps:

    • From the browser menu, click Install/Deinstall Products.

    • Read the information in the Welcome panel and click Next.

    • In the File Locations dialog box, type or select a name and a path on the local disk, for the Oracle Home, and click Next.

      This will install the Oracle binaries on the local disk. Use the same Oracle Home name and path on all nodes.

    • In the Available Products panel, select the Oracle 9i Database option and click Next.

    • In the Installation Types panel, select the Enterprise Edition option and click Next.

    • In the Database Configuration panel, select the Customized or Software Only option and click Next. Select the Customized option if you want to migrate earlier databases to Oracle 9i.

    • If you chose the Customized option, then on the Database Identification panel, select or type a unique name and SID for the global database and click Next.

    For Oracle 10g and 11g version, follow these steps:

    • Install 10g or 11g database.

    • Choose the Basic or Advanced installation type.

    If you choose Basic installation, follow these steps:

    • In the Oracle Home Location box, type or select a name and a path on the local disk for the Oracle Home.

    • This installs the Oracle binaries on the local disk. Use the same Oracle Home name and path on all nodes.

    • Select Enterprise Edition.

    • Clear Create Starter Database and click Next.

    If you choose Advanced installation, follow these steps:

    • Select the destination directory for the Oracle installation and click Next.

    • Select Enterprise Edition and click Next.

    • Select Do not create a starter database.

  3. Follow the wizard instructions, select options as per your configuration and complete the installation.