Sample multiple Oracle instances (single listener) configuration
Prev Appendix B. Sample configurations Next

Sample multiple Oracle instances (single listener) configuration

Figure: Two Oracle instances sharing a listener describes a typical VCS configuration to monitor two Oracle instances sharing a listener. This configuration has a service group for each Oracle instance. The Listener too is configured in a separate service group.

Figure: Two Oracle instances sharing a listener

Two Oracle instances sharing a listener

The Oracle service groups are made dependent on the Listener service group using an Online Local Firm dependency.

Figure: Dependency graph for one of the Oracle instances shows the dependency graph for one of the Oracle instances in the VCS configuration. In the Oracle service group, the shared disk groups and volumes in the cluster are configured as resources of type DiskGroup and Volume respectively. The volumes are mounted using the Mount agent.

Figure: Dependency graph for one of the Oracle instances

Dependency graph for one of the Oracle instances

Figure: Dependency graph for the single listener shows the dependency graph for the listener that the two Oracle instances share in the VCS configuration. In the Listener service group, the virtual IP address is configured using the IP and NIC resource types. The Listener can be started after the IP and NIC resources are brought online.

Figure: Dependency graph for the single listener

Dependency graph for the single listener

The Oracle server can be started after the Listener service group and the resources in the Oracle service group are brought online.

Note:

In this case, make sure you have modified all proper system files, such as /etc/passwd and /etc/group to support multiple databases. Pay particular attention to system requirements like physical memory and shared memory segment availability. Also ensure a single system is capable of sustaining a multiple instance load in the event of a server failure and extended operation on the backup server.
Prev Up Next
Sample VCS configuration file for single Oracle instance Home Sample VCS configuration file for multiple Oracle instances (single listener)