PLSQL Developer or Toad does not install the Oracle client to connect to the database

To simplify the use of Oracle on personal computers and avoid occupying unnecessary resources, you do not need to install the Oracle client. Method: use Oracle InstantClient to connect to the oracle database

1. Download the corresponding program, for example, 34,742,358 instantclient-basic-win32-10.2.0.4.zip (bytes)

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. decompress the Oracle Instatnt Client. For example, to D:/instantclient_10_2

3. environment variable configuration: "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)

4. Add the following file in D: \ instantclient_10_2, with the file name tnsnames. ora

5. 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)
)
)

For more information about Oracle, see Oracle topics page http://www.bkjia.com/topicnews.aspx? Tid = 12