Use Oracle Instant Client to remotely connect to the database without installing a client using PLSQL

First download the Instant Client Program: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

After downloading, compress the file to D: \ oracle \ instantclient_11_2

Configure the system environment variables and add the following content to the existing environment variables:

Path = D: \ oracle \ instantclient_11_1

Tns_admin = D: \ oracle \ instantclient_11_1
LD_LIBRARY_PATH = D: \ oracle \ instantclient_11_1
Sqlpath = D: \ oracle \ instantclient_11_1
Nls_lang = simplified chinese_china.zhs16gbk

After the environment variable is configured, copy the tnsnames. ora file to the D: \ oracle \ instantclient_11_2 directory.

 

Open plsqldev, select "preferences..." in the "Tools" menu, and set the parameters on the options page:
Oracle Home = D: \ oracle
OCI library = D: \ oracle \ OCI. dll

 

Note: If you encounter a ora-01460 error during operations, it may be that the character set settings are inconsistent with the server. You can open the SQL window in plsqldev and execute select userenv ('language') from dual to get the character set settings of the database to be connected, then set nls_lang = <server Character Set> in the local environment variable to solve the problem.

 

NOTE: Refer to the following two documents:

Http://www.cnblogs.com/dba001/archive/2011/02/27/1966188.html

Http://blog.chinaunix.net/uid-257761-id-2458150.html