We are working on an infrastructure upgrade project. We're moving from a single 12c database to a dual database RAV configuration using DB version 19. I was given the following TNS Name entry from the DBA. Hostname has been replaced for redaction to foo.bar.com, the hostname of the load balancer. Toad does not even see this entry when trying to select it when logging in. Version 19 client is installed and works with SQL Plus, however SQL Plus doesn't connect to this TNS Entry either. I have a ticket open with Oracle Support as well.
- Does Toad 14 support Oracle Client and DB 19?
- Does Toad 14 support Oracle RAC configuration? If so - is the any other special settings that need to be done in the listener or in Toad to allow this failover to happen?
Any help would be greatly appreciated!
(FAILOVER = on)
(LOAD_BALANCE = on)
(ADDRESS = (PROTOCOL = TCP)(HOST = foo.bar.com)(PORT = 1521))
(SERVICE_NAME = PROD)
(METHOD = BASIC)
(TYPE = SELECT)
(RETRIES = 18)
(DELAY = 1)