Cannot get Toad to recognize or resolve the entries in my tnsnames.ora file. Trying to connect to an Oracle DB via VPN connection, and for one instance, can connect, but for another cannot.
Wait a moment and try to connect a second time.
- Check which instances are currently known by the listener by executing: lsnrctl services <listener name>
- Check that the INSTANCE_NAME parameter in the connect descriptor specifies an instance name known by the listener.
- Check for an event in the listener.log file.
- Check with DBA to confirm tnsnames.ora entry and info in the Listener.ora are in sync.