To capture data from Oracle’s Real Application Cluster (RAC), each individual cluster member (instance) must be treated as a database host. The approach to capturing data using Acquire is the same as a standalone host by logging into the Oracle database as a read only user; it then executes SQL statements and stores the resulting output into data files.
In the case of Oracle RAC, each member (instance) of the cluster needs to have an Acquire installed and configured, thus each member of the cluster, needs to have a dedicated independent local user account setup for the same database.
The following example along with associated steps looks at how to configure Syncsort Capacity Management to capture and collect data from a 2-node Oracle RAC, with members (instances) called RAC1 and RAC2 and hosting databases ORCL and DBCS.
- Create unique local user accounts for each cluster member; e.g., orarac1 (RAC1), orarac2 (RAC2).
- Install the UNIX Acquire into each local user account.
- Configure the Acquire with database select permissions, as described in Database Administration Tasks.
- In System Manager, create a UNIX hosted Oracle target for each instance and
database combination. In this example there should be 4 targets:
- RAC1+ORCL
- RAC1+DBCS
- RAC2+ORCL
- RAC2+DBCS
- Check each target connection parameters are set correctly. The UNIX Acquire will use these to connect to each database.
- Apply Oracle capture and collection profiles to the targets to start Oracle target capture.
This approach provides redundancy by allowing for information from available cluster instances and hosted databases to be captured by the UNIX Acquire whereas if an Acquire on a single host was used to capture information from the GV$ views and that instance became unavailable, all data capture would be lost for the cluster for that period of time.
For further information on how to setup UNIX-hosted Oracle targets, refer to the System Manager online help.