Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
'Invalid Oracle Home' error when connecting with an Oracle Instant Client
설명
When using an Oracle instant client and the Instant Client files are in a folder that's in a \bin subfolder - e.g. C:\instantclient19c\bin and when that folder is also added in the Path variable, Toad doesn't connect to the database, and shows the 'Invalid Oracle Home' error. With the SQL*Plus module of the instant client, it connects ok when in the \bin subfolder.
As soon as you move all the instant client files to C:\instantclient19c , (or even for example C:\instantclient19c\xbin) , and amend the path variable, Toad connects. The issue occurs when specifically a \bin folder contains the instant client files.
해결 방안
WORKAROUND: Please ensure the Oracle instant client files are not in a folder with the name of 'bin' and update the PATH variable to reflect the updated location of the instant client files.
STATUS: Waiting for fix in a future release of Toad for Oracle
