When trying to connect to Oracle via SQL Optimizer, the following error occurs:
ORA-12154: TNS:could not resolve the connect identifier specified
Even if Toad for Oracle connects using the same connection setup, carrying it over causes the same error in SQL Optimizer. When trying to create a direct connection in SQL Optimizer the following error occurs:
ORA-06413: Connection not open
If using an Oracle 18.104.22.168 client, download and install a 22.214.171.124 Instant Client and use to make a connection with SQL Optimizer.
Download from Oracle: