To configure multiple Oracle instances (single listener)

1. Review the Oracle and Netlsnr resource types and their attribute definitions.

2. Configure the Oracle file tnsnames.ora as per VCS requirements. The changes required in the file depends on your Oracle configuration.

   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.

   The following example assumes 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)
         )
        )
       mktg =
        (DESCRIPTION =
         (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = oramktg)(PORT = 1522))
         )
         (CONNECT_DATA =
          (SERVICE_NAME = mktg)
         )
        )

3. Configure the Oracle file listener.ora as per VCS requirements. The changes required in the file depends on your Oracle 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_ORACLE = 
       (DESCRIPTION_LIST =
       (DESCRIPTION =
       (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = oraprod)(PORT = 1521))
        (ADDRESS = (PROTOCOL = TCP)(HOST = oramktg)(PORT = 1522))
       )

4. Create the VCS service groups for Oracle.

   See Configuring the VCS service group for Oracle.

5. Bring the Oracle service group online.