Is it possible to install the Control-M using Oracle Database Server with Data Guard or Golden Gate Data Replication?

Version 1
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    Control-M/Enterprise Manager


    COMPONENT:

    Control-M/Enterprise Manager


    APPLIES TO:

    All versions of Control-M/Enterprise Manager and Control-M/Server for UNIX and Microsoft Windows



    QUESTION:

    - Does Control-M/Enterprise Manager and Control-M/Server support Oracle Database Server with Data Guard or Golden Gate Data Replication?
    - Is it possible to install the Control-M using Oracle Database Server with Data Guard or Golden Gate Data Replication?


    ANSWER:

    - Control-M solution is transparent to type of data replication between Oracle sites.
    - The activation of the Oracle Database Data Guard or Golden Gate Data Replication should be done by the customer.
    - Control-M/Enterprise Manager and Control-M/Server connect to an alias represented by environment variable $ORACLE_SID, the failover should be configured in the tnsnames.ora file.
    - From Control-M application point of view nothing changes, all the logs and other files are written to the same location.

    Control-M Server
    - Regarding the automatic failover of the Oracle Database Server, in case of database sessions disconnect the CONTROL-M/Server will try to reconnect the database 90 times with a delay of 1 second between the attempts.
    - After 90 re-connection failures, Control-M/Server will be shut down.
    - Control-M/Server have 90 seconds to complete a failover.
    - If the failover takes more than 90 seconds, will be necessary to start the CONTROL-M/Server manually.

      

    Control-M Enterprise Manager (EM)
    - In case of Control-M/EM database disconnection, will be necessary to restart all Control-M/EM components to reestablish the connections.

    Additional Information:
    - Does Control-M support Oracle Dataguard in Maximum Performance Mode?
    Control-M/Server in this mode may loose transaction in case of a primary crash, therefore for Disaster Recover scenario this configuration may be acceptable. 
    For Control-M High Availability configuration, Maximum Performance mode is not recommended.

    Control-M/Enterprise Manager supports Maximum Performance mode in both DR and HA scenario.
     

     


    Article Number:

    000021902


    Article Type:

    FAQ/Procedural



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles