PL/SQL developer or toad does not install the Oracle client to connect to the database

Use Oracle instantclient to connect to the Oracle database

1. Download the correspondingProgramI got a 10204 instantclient-basic-win32-10.2.0.4.zip.(34,742,358 bytes)

Http://www.oracle.com/technology/global/cn/software/tech/oci/instantclient/htdocs/winsoft.html? _ Template =/ocom/print

Http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html

2. decompress the Oracle instatnt client to D: \ instantclient_10_2.
3. Decompress Oracle ODBC to D: \ instantclient_10_2.
4 "Control Panel"-"System"-"advanced"-"environment variable"-"system variable" 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 to the end of the path variable (Note: Use semicolons for different paths; interval)
5. Add the following content in D: \ instantclient_10_2. The file name isTnsnames. ora
6. Go to the installation directory on the console and run odbc_install to install the ODBC driver.
7. You can download the separate Oracle SDK and Oracle SQL plus to the installation directory, decompress the package, and run

Add ora file content 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)
)
)

Note:
1. If ODBC cannot be connected, modify or delete the nls_lang name under HKLM \ sofeware \ oracle in the registry.
2. If you use a JDBC connection, upload the instantclient-jdbc-win32-10.1.0.4.zip: contains the JDBC driver package to the official website.

The meaning of another article is the same, but it is more detailed.