[Oracle] [Toad] how to connect toad to Oracle without installing the Oracle client

How to connect toad to Oracle without installing the Oracle client

In the past, it was quite troublesome to install the Oracle client when connecting to Oracle. On the one hand, it was difficult to install such a large volume of data.

Oracle seems to have provided instantclient for Windows starting from 10 to solve the above problems. It happened that the machine was recently reinstalled, So I went online to get this stuff.

It was difficult to configure the instance at the beginning. After some twists and turns, the configuration was finally made. Here is a summary (instantclient does not seem to support versions earlier than Oracle 9)
1) to Oracle download instantclient,: http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html, pay attention to download the corresponding version, and decompress to F:/programes/instantclient11 under
2) Copy bin, network, ocommon, oracore, and PLSQL from Oracle to this directory.

(I finally sorted out a package for the above two items. If you need it, contact me. It may be about 50 MB-it should be simplified, but I am not interested)

3) copy the tnsnames. ora and sqlnet. ora configuration files to the network/Admin directory.
If you do not have these two files, you can go to the Oracle server or directly edit the files in the Network/admin/sample directory.

4) set in system variables: (you can also write data to the Registry)
PATH (add to variable) F:/programes/instantclient11
LD_LIBRARY_PATH (this variable may be omitted) F:/programes/instantclient11
Nls_lang (note the space. This is the setting language and can be configured as needed) Simplified chinese_china.zhs16gbk
ORACLE_HOME F:/programes/instantclient11
SQL _path F:/programes/instantclient11
Tns_admin F:/programes/instantclient11/Network/admin
5) use toad to connect to the database. OK

You can also refer to here: http://blog.csdn.net/xys_777/archive/2010/08/03/5784295.aspx