To configure multiple Oracle instances (multiple listeners)

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.

      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, create independent configurations for each listener.

      LISTENER_PROD = 
        (DESCRIPTION_LIST =
        (DESCRIPTION =
        (ADDRESS_LIST =
         (ADDRESS = (PROTOCOL = TCP)(HOST = oraprod)(PORT = 1521))
        )
       )
       
       LISTENER_MKTG = 
        (DESCRIPTION_LIST =
        (DESCRIPTION =
        (ADDRESS_LIST =
         (ADDRESS = (PROTOCOL = TCP)(HOST = oramktg)(PORT = 1522))
        )
       )

4. Create the Oracle service groups using the agent configuration wizard, Cluster Manager (Java Console,) or the command-line.

5. Bring the Oracle service group online.