PLSQL Developer or Toad does not install the Oracle client to connect to the database. In order to simplify the use of Oracle on a personal computer and avoid occupying unnecessary resources, you can not install the Oracle client.
The method is to use Oracle InstantClient to connect to the oracle database www.2cto.com 1 to download the corresponding program. Listen (34,742,358 bytes) Then 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 Www.2cto.com 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 www.2cto.com LD_LIBRARY_PATH = D: \ region = D: \ instantclient_10_2 add D: \ instantclient_10_2 to the end of the Path variable (Note: different paths are separated by semicolons: \ instantclient_10_2 Add the following content to the file named tnsnames. ora 5 can download the separate Oracle SDK and Oracle SQL PLUS to the installation directory. decompress the package to run the file content and format tnsnames attached to www.2cto.com. ora # D:/instantclient_10_2/tnsname. ora www.2cto.com mydb1 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.47) (PORT = 1521) (CONNECT_DATA = (SERVER = dedicated) (SERVICE_NAME = mydb1) from JACKY. hao's column