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