Monday, January 13, 2014

No valid Oracle Clients found :...at least one 32-bit client ...

We got the challenges: "No valid Oracle clients found. You need at least one 32-bit client properly configured." After research, https://support.software.dell.com/kb/SOL71545 ********************************************** ORACLE CLIENT SOFTWARE INSTALLATION NOTES: - Download ‘directly’ to your “DESKTOP” location (and run it from there too). This can avoid many potential download and installation problems. - Ensure that your Windows User has Administrator Rights before installing an Oracle Client (or Toad). - Toad for Oracle 11.5.1 and lower supports 32-bit Oracle Clients only. - The above 32-bit client will work on a 64-bit Windows OS’s. - During the Oracle Client installation, choose “Full” or “Administrator” installation type (this is not automatically selected). - Ensure you apply or copy over your TNSNAMES.ORA file (this file usually comes from your company). The default location for this file in 10g and 11g is: 10g - C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN\ 11g - C:\app\\product\11.2.0\client_1\NETWORK\ADMIN\ NOTE: After installing the new client, ensure you select it in Toad’s / SQL Navigator’s login screen | under “Connect Using:” / “Oracle Home/Client:” (ensure you are NOT connected to any database for this setting to be available). ================================================================== It does work.

No comments:

Post a Comment