i have tested failover and switchover (manually) succesfully in my test environment, and its working fine
i just want to know, after applying failover/switchover should i change my ip's and hostname,listener file,parameter file in both machines??
my primary db has got 9 ip
and secondary db got 10 ip
my applications are running in 9 ip which is my primary db
after applying switchover/failover i cant work on my applications which are connected in 9 ip, i cant connect my applications
i just change my IP's,hostname,bash_profile,listener and parameter file in both machines, after changing it i can access my applications
i just wont to know should i change these files ??? is this the best way ???
You should use Transparent Application Failover (TAF). This is a SQL*Net configuration that wraps both databases in to a service. The application points to the service, and SQL*Net handles re-routing the connection when you do a failover or switchover.
The short answer is no. Handle this with Net80.
(ADDRESS = (PROTOCOL = TCP)(HOST = primary.server)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = standby.server)(PORT = 1521))
(SERVICE_NAME = ernie)
You can create a service like this:
For additional information see :
The second link show auto failover information, but the setup of Net80 works for manual too.
Another good example