(GO) Configure Oracle 11g Green client and PLSQL environment

This article was reproduced from: http://my.oschina.net/jang/blog/83009

This approach is done by using the Oracle-provided lite client, which is a green, free-to-install client.

(The official editions are available here):
Clients used in Windows 32-bit systems
Clients that are used in other system environments

There are many versions of the Instant client: primarily basic and basic Lite. The basic version includes all of the files that support running OCI, OCCI, JDBC, Jdbc-oci, and multiple languages. Basic Lite is a lite version of the basic edition that includes only the error descriptions in English and only supports Unicode, ASCII, and European character sets. Therefore, if the database server is a Chinese character set, such as simplified Chinese_china. ZHS16GBK), you must download the basic version.

The configuration method is as follows:

First, the download of the basic version of the compressed package into a directory (the directory can be customized according to personal preferences, the author placed in D:\Program files\oracleclient);

Second, configure the environment variables:
(Open environment Variable Configuration Interface action: My Computer---properties---advanced---environment variables, new or edited in the System Variables section. Win7 and above operating system: computer---Advanced system setting--environment variable
1) variable name: oracle_home
Variable Value: D:\Program files\instantclient
2) variable name: tns_admin
Variable Value: D:\Program files\instantclient\
Description: This configuration item specifies the storage path of the Tnsnames.ora file. It is recommended that the value of the last ' \ ' symbol do not omit, otherwise it may affect the Plsql, the author in the configuration, the lack of ' \ ', the result plsql can not read the data in the file. But it does not seem to affect the use of sqlplus.
3) variable name: Nls_lang
Variable value: Simplified Chinese_china. Zhs16gbk
Description: This value defines the encoding used by the connected database, and other types can be viewed by the server themselves or looked up online.
4) Modify the path variable, and add D:\Program after the Files\instantclient

In the directory where you define the Tns_admin (the value of the variable name), the file name is Tnsnames.ora, and the file adds its own database alias configuration,
Examples are as follows:
Mydbname =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 172.16.1.16) (PORT = 1521))
(Connect_data =
(SERVER = dedicated)
(service_name = ora10g)
)
)
Mainly modifies the first ' = ' Alias, host is the IP address, and Service_Name is the instance name of the database server.

Iv. installation and use of Plsql. If there are no surprises, you can now connect to the database using Plsql or Sqlplus.

Uninstall method:

First, in the system variables, delete oracle_home, tns_admin, Nls_lang Three variables, modify the path variable, remove D:\Program files\instantclient_10_2 directory.

Second, delete the client storage directory, the author of the D:\Program files\oracleclient

Additional Configuration methods:
Use Plsql to connect to remote Oracle without installing an Oracle client

(GO) Configure Oracle 11g Green client and PLSQL environment