Fail Over server - Switching

system · January 17, 2019, 8:29pm

Hello All,

Currently we have 2 Server 1.Primary 2.FailOver

Primary Server runs on TPC
Fail Over Server runs on CNJ

Both of the TNS Entries are already part of TNSName.ora file in BO Server.
My question is; Is there a way to have one connection for both of the server so system can dynamically switch over to failover server if the Primary Server goes down?

Your help is appreciated.

kamran.bobj (BOB member since 2011-12-20)

system · January 18, 2019, 12:36pm

So you have an Oracle Datbase Server configured for Failover and want BusObjects to use the Failover Oracle Server?

Well, Failover (e.g. Oracle) should be transparent for an outside application (eg. BusObjects), so you should look into Oracle’s configuration of Failover, perhaps?

Andreas (BOB member since 2002-06-20)

system · January 29, 2019, 4:10pm

Thank you… Your answer help…
DBA confirmed the Switch should happen at the database level we just needed to update the TNS Entries.

kamran.bobj (BOB member since 2011-12-20)