InfoScale™ 9.0 Cluster Server Implementation Guide for Oracle - Windows

Last Published:
Product(s): InfoScale & Storage Foundation (9.0)
Platform: Windows
  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
        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

Oracle agent

The following table lists the description of error messages and recommended solution for the Oracle agent.

Table: Oracle agent error messages

Message

Description

Cannot open service handle.

The agent could not open the Service Control Manager handle. This may occur because of an invalid service name.

Solution: Verify that the correct service name is specified in the configuration definition of the agent.

Cannot close service handle.

The agent could not close the Service Control Manager handle.

Solution: Verify that the specified service is running.

Cannot start service.

The agent could not start the specified service. This may occur because of the following:

  • The specified SCM handle does not have access to the service. or

  • The specified handle is invalid.

Solution: Verify that the service name in the configuration file is the same as the name displayed by the SCM. Verify that the specified service is supported by the host. Verify that the service is listed in the SCM window.

Cannot stop the service.

The agent could not stop the specified service. This may occur because of the following:

  • The specified service was not opened successfully.

    or

  • The specified service was not opened with the required access.

Solution: Verify that the service was opened successfully. Check the access with which the service was opened.

Wait for mutex failed.

The wait function for mutex failed. This message is followed by an error code. Check the error code for more information.

Wait for mutex abandoned.

The mutex object is was not released by the thread that owned the mutex object before the thread terminated. This indicates a possibility that the SQL script is not terminated.

Solution: Verify that the SQL script executed correctly.

Cannot wait for mutex object.

The agent could not acquire mutex for the resource. This may occur if two or more Oracle resources configured.

Solution: Verify that the SQL script executed correctly.

Failed to decrypt password.

The agent could not decrypt the domain password.

Solution: Verify that the password was encrypted using the VCS Encrypt utility.

No domain specified in argument list.

The attribute Domain is not configured for the resource.

Solution: Verify that the correct Domain is defined in the configuration file.

No username specified in argument list.

The attribute UserName is not configured for the resource.

Solution: Verify that the correct UserName is defined in the configuration file.

No password specified in argument list.

The attribute Password is not configured for the resource.

Solution: Verify that the password is encrypted using the VCS Encrypt utility. Verify that the correct encrypted password is defined in the configuration file.

No SID specified in argument list.

The configuration definition of the agent does not contain a value for the attribute SID.

Solution: Verify that the attribute SID is correctly defined in the configuration file.

SQL*Plus process exited with error error_code.

The agent could not execute the SQL*Plus process correctly. See the associated error code for more information.

Invalid filename in argument list file_name.

The SQL script for the resource is incorrectly defined in the filename.

Solution: Verify that the attribute SQLFile is correctly defined in the configuration file. Verify the validity of the file name and path.

An Oracle error occurred.

An error occurred while generating the SQL script. This is an Oracle error and the corresponding error number and error message is logged to the agent log.