I have two Oracle 11g r2 databases on separate linux servers (primary/physical standby) with data guard 11g r2 configured to switch over between the two. This is just a priimary database and its standby with no RAC configured.
I have an API server running in Windows using IIS which connects to the primary database via Oracle 11g client. Initially there is a simple entry in tnsnames to connect to the primary database.
There is much discussion above on application failover. I would like to know:
1. Do I have to configure a new service on each database server using srvctl to provide automatic application connection to the database on failover?
2. When this is done I suppose by configuring tnsnames with the same new service name the application will be automatically switched to the open database on switchover?
3. What steps do I have to carry out to achive this?
Thanks,
Lloyd