Prerequist: tnsnames.ora file with the tnsalias to your database system and a sqlnet.ora configuration file.
See examples:
Please download the zip
Create directory d:\oracle\11_2_client
Unzip the content of the zip files in to this folder (NO SUBFOLDER instant client, all files in one directory)
Create directory d:\oracle\TNS_NAMES
Set the “Runtime Environment” system variable TNS_ADMIN to the Path of the folder d:\oracle\TNS_NAMES (TNS_ADMIN= d:\oracle\TNS_NAMES)
Edit the PATH Variable, add the path d:\oracle\11_2_client to the beginning of the path variable
Copy the attached file tnsnames.ora and sqlnet.ora to the directory d:\oracle\TNS_NAMES
Open the file tnsnames.ora and check the name/IP Adresse of the DB Server and the service name of the DB, adjust if necessary
Open cmd shell and test with “set” if the variable TNS_ADMIN is set to the directory d:\oracle\TNS_NAMES
Check the path variable, if in the path “d:\oracle\11_2_client “ is defined
Ping the name of the dbserver (or IP Adresse) used in the file tnsnames.ora if the DB server is reachable
With the the CMD Schell, go to the directory d:\oracle\11_2_client and start the “odbc_install.exe” program
Open Explorer and go the directory “c:\windows\syswow64”
Open the ODBC 32 Bit Manager “odbcad32.exe”
Create new System
DNS with the Oracle Driver “Oracle in instantclient_11_2„
From TNS SERVICE NAME check carefully that the TNS_ALIAS “ORA_MYDB” is visible over the drop down box “connection “ and select this value (if not the TNS_ADMIN parameter or the file tnsname.ora has a problem!)
Insert Username and password and check the connection