CODEWITHSUNDEEP
oracle-databasetoad
pradeep
pradeep

Reputation: 330

Toad for Oracle, No valid Oracle clients found. You need at least one 64-bit client properly configured

I get this error when I launch Toad for Oracle.

No valid Oracle clients found. You need at least one 64-bit client properly configured.

This has been happening since I upgraded the Oracle Client to Oracle 12c from 11g.

enter image description here

Here is what I have done so far to try to resolve it based on internet research:

  1. I checked the path variable, it's currently set to C:\xyz\Oracle\ora12.1\client_2\bin, and there is an Oracle installation at this path.
  2. I checked the TNS_ADMIN variable, it is currently set to C:\xyz\Oracle\ora12.1\client_2\network\admin. This also appears to be valid and correct, there is a tnsnames.ora file under this path.

SQL Plus works without issues, and Oracle SQL Developer also works without issues.

Is there anything else I can try to resolve this issue? Unfortunately, uninstalling and reinstalling Toad is not an option at this point as I do not have access to a new setup.

Upvotes: 3

Views: 39380

Answers (2)

Saxon
Saxon

Reputation: 937

With TOAD you need to have oracle client installed on your computer and you must configure the related TNSNAMES.ORA to connect to the server. If you use SQLDeveloper you can do without oracle client installation.

Upvotes: 1

MechCoder
MechCoder

Reputation: 29

The issue is due to not having the Oracle Database installed on your computer.

You can download the database here: https://www.oracle.com/database/technologies/appdev/xe.html

Once the zip file is downloaded and extracted, run setup.exe. Once that is complete, the Oracle DB will be installed on your machine and the error will no longer appear.

Upvotes: 1

Related Questions