Does Transparent Application Failover work without Oracle Parallel Server?
Yes. Transparent Application Failover will work with a single instance configuration, any cluster failover product, or even geographically separate configurations like a standby database or a replicated database. However, only Oracle Parallel Server and replication support the pre-connect option of Transparent Application Failover. To use pre-connect, a user must be able to login to the backup instance at the time they connect to the primary instance.