Review the resource dependency graph and sample configuration.
To configure Oracle with shared server support
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) ) )
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)) ) )
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)"
local_listener=listener_alias
This listener alias gets appended by the default domain set in the file sqlnet.ora.
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))
Create the VCS service groups for Oracle.