I have two Oracle 11g r2 databases on separate servers (primary/physical standby) with data guard 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 IIS which connects to the primary database via Oracle 11g client. 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 applicatiion connection to the database?
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?