InfoScale™ 9.0 Agent for Oracle Installation and Configuration Guide - AIX

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 VCS service groups for Oracle.

   See Configuring the VCS service group for Oracle.

5. Bring the Oracle service group online.