Configuration With Shared Server Support

This section describes how to configure Oracle instance having shared server support in a VCS environment for high availability. For resource dependency graph and sample configuration, see Oracle Configuration With Shared Server Support.

  To configure Oracle with shared server support

1. Review the Oracle and Netlsnr resource types and their attribute definitions, described in Resource Type Definitions.
2. Configure Oracle for VCS. This involves configuring the Oracle files listener.ora and tnsnames.ora as per VCS requirements. This section describes the changes required in these files, depending on your Oracle configuration.
   1. For clients to connect to the failover instance, in the file tnsnames.ora, located at $TNS_ADMIN change the host name for all TCP protocol address databases to the virtual IP address for the service group.

   In the following example, assuming that the host name for the database is set to oraprod, which represents the virtual IP address for the service group.

   
       prod =
        (DESCRIPTION =
        (ADDRESS_LIST =
         (ADDRESS = (PROTOCOL = TCP)(HOST = oraprod)(PORT = 1521))
        )
        (CONNECT_DATA =
         (SERVICE_NAME = prod)
        )
       )
   2. Perform additional configuration tasks specific to the listener configuration. In the file listener.ora located at $TNS_ADMIN, edit the "Host=" line in the ADDRESS_LIST section and add the name of the high availability address for the service group, in this case, oraprod.
   
       LISTENER_PROD = 
        (DESCRIPTION_LIST =
        (DESCRIPTION =
        (ADDRESS_LIST =
         (ADDRESS = (PROTOCOL = TCP)(HOST = oraprod)(PORT = 1522))
        ) 
       )
3. In the initialization parameter file, for the mts_dispatchers (called dispatchers in Oracle9i versions and above) parameter, set the host name for all TCP protocol address dispatchers to the virtual IP address for the service group.

   In the following example from an Oracle 8i configuration, the host name for the dispatcher is set to oraprod.

   
     mts_dispatchers =
      "(ADDRESS = (PROTOCOL = TCP)(HOST = oraprod))
      (MUL=ON)(TICK=15)(POOL=true)" 

   In the following example from an Oracle9i configuration, the host name for the dispatcher is set to oraprod.

   
     dispatchers =
      "(ADDRESS = (PROTOCOL = TCP)(HOST = oraprod))
      (MUL=ON)(TICK=15)(POOL=true)"
4. In the initialization parameter file, set the LOCAL_LISTENER attribute to a listener alias, so that the Oracle PMON process registers information with the listener.
      _listener=listener_alias 

   This listener alias gets appended by the default domain set in the file sqlnet.ora.

5. In the file tnsnames.ora, create an entry for the listener alias to resolve the address information. In the address parameter, set the host name to the virtual IP address for the service group, without the CONNECT_DATA portion of the connect descriptor.

   In the following example, the listener listener_alias uses TCP/IP port 1521 and the virtual IP address for the service group is oraprod.

   
     listener_alias=
      (address = (PROTOCOL = TCP)(HOST = oraprod)
      (PORT= 1521))
6. Create the Oracle service groups using the Agent Configuration wizard, Cluster Manager (Java Console,) or the command-line. For information on using Cluster Manager (Java Console), see Configuring the Agent Using Cluster Manager (Java Console).
7. Bring the Oracle service group online. See Bringing the Service Group Online for instructions.