Review the resource dependency graph and sample configuration of a service group involving multiple Oracle instance.
To configure multiple Oracle instances (multiple listeners)
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) ) )
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)) ) )
Create the VCS service groups for Oracle.