Using Oracle's heterogenous services also known as HS, we can make a connection to non-Oracle databases and access the data remotely. I used MS SQL server as the target non-Oracle database on Windows and used HS to access from Oracle database residing on Linux. Here, we'll see step by step instructions on how to set up a connection from Oracle database to Microsoft SQL server.

Data Guard broker helps to efficiently manage a dataguard configuration through a client connection to any database in the configuration and it's very easy to switchover/failover with one command thereby minimizing overall downtime associated with planned/unplanned outage. It's also integrated with CRS so that database role changes occur smoothly and seamlessly. Here, we'll see how easy it is to setup using command line interface DGMGRL with an example.