Return
-
Title
Launching Toad. "No valid Oracle Clients found" error message when opening or starting Toad. -
Description
When starting the Toad application or trying to connect to a database, Toad for Oracle returns the following error:"No valid Oracle Client found. Please note that Toad only supports 32-bit Oracle Client installations."OR"No valid Oracle clients found. You need at least one 32-bit client properly configured."OR
"No valid Oracle clients found. You need at least one 64-bit client properly configured." -
Cause
1)The Toad for Oracle product’s bit version does not match the Oracle Client’s bit version.2)The machine does not have any Oracle Client software installed locally. -
Resolution
RESOLUTION:1)Verify the Toad bit version (32-bit or 64-bit) installed, and verify the bit of the Oracle Client installed. The bit version of the Oracle Client must match with the Toad bit version installed.2)- If you do not have any Oracle Client software installed on your PC, please install one. See the Oracle download pages below.* Please review the Toad for Oracle Release Notes for the most current system requirements.
===========================================================Below are the Oracle download links for Oracle Client 19c software:Oracle Database 19c Client (19.3) for Microsoft Windows x64 (64-bit)OrOracle Database 19c Client (19.3) for Microsoft Windows (32-bit)https://www.oracle.com/database/technologies/oracle19c-windows-downloads.html============================================================Previous Database Release SoftwareOracle Database Enterprise Edition 10.2, 11.x, 12.x, and 18c are available as a media or FTP request for those customers who own a valid Oracle Database product license for any edition.To request access to these releases, follow the instructions in Oracle Support Document 1071023.1 (Requesting Physical Shipment or Download URL for Software Media) from My Oracle Support.NOTE: for Oracle Database 10.2, you should request 10.2.0.1 even if you want to install a later patch set. Once you install 10.2.0.1 you can then apply any 10.2 patch set.Similarly, for 11.1 request 11.1.0.6 which must be applied before installing 11.1.0.7. Patch sets can be downloaded from the Patches and Updates tab on My Oracle Support.Oracle request form link = https://support.oracle.com/epmos/faces/ui/km/DocumentDisplay.jspx?id=1071023.1***Please contact Oracle support if you required any version prior of the version 19c******************************************************************ORACLE CLIENT SOFTWARE INSTALLATION NOTES:************************************************************>>>>>>> IMPORTANT NOTES: <<<<<<<<- In the Oracle Client installation wizard, click on the “ADMINISTRATOR” radio button (this is not automatically selected).- Ensure the “bit” of Toad and Oracle Client matches i.e. both 32-bit or both 64-bit or else Toad would not work.- Download ‘directly’ to your “DESKTOP” location (and run it from there too). This can avoid potential download and installation problems.- Un-Zip the downloaded file. Do not run the Oracle Setup from within the ZIP program or Zipped folder.- Ensure your Windows User has Administrator Rights before installing an Oracle Client (or Toad).- The above 32-bit client will work on 64-bit Windows OS’s.- Ensure you copy over your TNSNAMES.ORA file (this file usually comes from your company). The usual default location ‘to put’ this file in is:11g: C:\app\<YOUR_USER>\product\11.2.0\client_1\NETWORK\ADMIN\12c: C:\app\client\<YOUR_USER>\product\12.1.0\client_1\NETWORK\ADMIN\NOTE: After installing the new client, ensure you select it in Toad’s login screen, under “Connect Using:” (ensure you are NOT connected to any database for this setting to be available).***************************************** -
Additional Information
For common Oracle connection problems in Toad for Oracle 10.x and above, review SOL64853