Plsql Developer or Toad do not install Oracle Client connection database
To simplify Oracle's use of personal computers, avoid consuming unnecessary resources, and you can not install Oracle clients. By using Oracle Instantclient to connect to the Oracle database
1 Download the appropriate program, as 10204 instantclient-basic-win32-10.2.0.4.zip (34,742,358 bytes)
or Instantclient-basic-win32-10.2.0.3-20061115.zip.
WIN64-bit system download Link: http://www.oracle.com/technology/global/cn/software/tech/oci/instantclient/htdocs/winsoft.html?_ Template=/ocom/print 2 Extracts the Oracle INSTATNT client. For example, to D:/instantclient_10_2
3 environment variable Configuration: Control Panel-system-advanced-environment variables-System variables add
Nls_lang = American_america. ZHS16GBK (or simplified Chinese_china. ZHS16GBK) Tns_admin = D:\instantclient_10_2 Ld_library_path = D:\instantclient_10_2 SQLPath = D:\instantclient_10_2
Add D:\instantclient_10_2 at the end of the path variable (note: Different paths with half-width semicolons; interval)
4 in D:\instantclient_10_2, add the following file, the file name is Tnsnames.ora
5 can download separate Oracle SDK and Oracle SQL Plus to the installation directory, unzip to run
Attached ora file contents and format Tnsnames.ora #D:/instantclient_10_2/tnsname.ora
MYDB1 = (DESCRIPTION = (Address_list = (ADDRESS = (PROTOCOL = TCP) (HOST =192.168.0.47) (PORT = 1521)) ( Connect_data = (SERVER = dedicated) (service_name = mydb1)))
Do not install Oracle Client connection to Oracle database