This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.
Control-M/Enterprise Manager 9.0.00 Control-M/Server for UNIX and Microsoft Windows 9.0.00 Database: Oracle Database
- Please advise on the permitted configuration of the Oracle Database (DB) High Availability (HA) in both these instances (Control-M/Enterprise Manager 9.0.00 and Control-M/Server for Unix and Windows 9.0.00)
- What features of Oracle DB can be used here to further strengthen the resilience of the installation?
- Can features such as Oracle Data Guard, Oracle RAC, Oracle GoldenGate be incorporated in this design, and if so are they compatible with the HA implementation ? If used are they transparent to Control-M?
BMC HA solution uses primary and secondary machines. The database connections properties on those machines is identical, that means that if Oracle is used as an example, the tnsnames.ora file on primary and secondary machine should be identical. There is another file called DBU_params.dat that contains database connection properties and it should be identical as well.
All that means that one creates the connection from the primary or the secondary to the hostname specified in the tnsnames.ora and this is the user’s responsibility to define this hostname correctly. If RAC is used, users should handle the listener using SCAN address, this is Oracle’s feature for handling RAC connections. In case one node fails the SCAN address specified in the tnsnames.ora will create the connection to the “alive” node.
If Data Guard is used, there are primary database (read,write) and stand by database which is in read only mode. All the connections from our primary and secondary must be directed to the primary database. In case there is a primary database failure and please open the standby database for writing all the connections should established to it till its stand will be built again.