Hello
We are trying to implement an application failover solution on Azure by adding a Load Balancer in front of the Application, so in case of Database failover to the other node - all the traffic can be diverted to the standby node (new primary). As we cannot change anything on the application, so our options are limited and one way is to do it through load balancer on Azure itself.
As the load balancer ping both the nodes and cannot differentiate between active and passive node - so I am thinking to add another listener which will be only started if the database is the primary active one, so in case of database failover to the other node, the listener will be started on the new primary node and the Load Balancer can divert the traffic there.
The question is - how do we achieve this. Do we need to create an oracle service and then create a database trigger to start and stop the service but I am not sure if this would stop the listener as well as we want that listener running just on the active node. How do we stop and start the second listener by defining the database role. Is there a clean and better way to achieve this or is there any other option available, maybe Oracle restart but that is suppose to be not available in Oracle 12c.
Any ideas would be useful, many Thanks,