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 22.214.171.124 client, download and install a 126.96.36.199 Instant Client and use to make a connection with SQL Optimizer.
Download from Oracle: