Toad How to connect Oracle without Oracle Client

Toad How to connect Oracle without Oracle Client

The original connection to Oracle is always installed Oracle client, it is very troublesome, on the one hand to bring the Oracle disk, on the other hand, it is very uncomfortable to install such a big thing.

Oracle seems to have provided instantclient to Windows from 10, to address the above issues. Happened to meet the recent machine reload, so go online down this stuff.

Initially found quite difficult to match, after some twists and turns, finally come out, a little summary (Instantclient does not seem to support Oracle 9 previous version)
1) to Oracle download instantclient,:http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html , note download the corresponding version, and unzip to F:\Programes\instantclient11
2) Copy the Bin,network,ocommon,oracore,plsql from Oracle to this directory

3) Copy the Tnsnames.ora and Sqlnet.ora two configuration files that are actually required to use in the Network/admin directory
If you do not have these two files, you can go to the Oracle server to obtain, or directly edit the files in the Network/admin/sample directory

4) settings in System variables: (can also be written to the registry)
Path (add in variable) F:\Programes\instantclient11
Ld_library_path (this variable may be omitted) F:\Programes\instantclient11
Nls_lang (note the space, which is the setting language, can be configured as appropriate) simplified Chinese_china. Zhs16gbk
Oracle_home F:\Programes\instantclient11
Sql_path F:\Programes\instantclient11
Tns_admin F:\Programes\instantclient11\network\ADMIN
5) connect the database with Toad, OK

Toad How to connect Oracle without Oracle Client