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

To configure Oracle with shared server support

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)
        )
       )

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_PROD = 
        (DESCRIPTION_LIST =
        (DESCRIPTION =
        (ADDRESS_LIST =
         (ADDRESS = (PROTOCOL = TCP)(HOST = oraprod)(PORT = 1522))
        )
       )

4. In the initialization parameter file, for the dispatchers parameter, set the host name for all TCP protocol address dispatchers to the virtual IP address for the service group.

   In the following example, the host name for the dispatcher is set to oraprod.

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

5. 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.

   local_listener=listener_alias
   					

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

6. 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))

7. Create the VCS service groups for Oracle.

   See Configuring the VCS service group for Oracle.

8. Bring the Oracle service group online.