Hi,
Whenever i’m trying to connect to the database, i’m receiving this error “No valid Oracle clients found. You need at least one 64-bit client properly configured.” . Kindly help me fix it.
Regards
Hello,
Yes there is a solution for your error. This error occurs when we try to connect an Oracle database, through a Client like Toad for Oracle etc… The error clearly says an 64-bit Oracle client need to be installed properly inorder to access the database.
Download and install Client from given link.
http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
The required software link is “Instant Client for Microsoft Windows (x64)”.
http://www.oracle.com/technetwork/topics/winx64soft-089540.html
Unzip the files to your Oracle installation folder. e.g: C:/oracle or C:/oraclehome. So the client installation is completed. Then we need to configure the client.
For that first set up the TNS_ADMIN environment variable and later confure the tnsnames.ora.
-
How to setup up the environment variables
Open the Control Panel –> click, System (Classic View) –> select, Advanced tab –>click, Environment Variables –> click, New (User variables) –> enter Variable Name as “TNS_ADMIN” and Variable Value as the location path of file “tnsnames.ora”, which comes in C:/oracle….Networ/Admin, now click, New (System variables) –> enter Variable Name as “Path” and Variable Value as the Oracle client folder path. If Variable Value already exists then append a semi-colon ; to the list and update the new path, then Click OK. -
Now open the “tnsnames.ora” and enter database configuration information.
1
2
3
4
5
6
7
8
OracleDatabaseName_Custom =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname or ipaddress)(PORT = portnum))
) (CONNECT_DATA =
(SID = XE) (SERVER = DEDICATED)
)
)
That’s it. Now open your client and access the database.
Credits: Stopdebugging