Configure Oracle 10g or 11g Green client and Plsql environments

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
There are many versions of client Instant clients that are used in other system environments: 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. Www.2cto.com 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 the D:\Program files\oracleclient); Second, configure Environment variables: (Open environment Variable Configuration interface Polygon operations: My Computer---properties---advanced---environment variables, which can be created or edited in the System Variables section. Win7 that the above operating system is: computer--Advanced system settings--environment variables 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 that is used by the connected database, and other types can be viewed by the server themselves or looked up online. 4) Modify the path variable, add D:\Program files\instantclient after you define the Tns_admin (the value of the variable name) directory, the file name is Tnsnames.ora, 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 ' = ' preceding alias, the host is the IP address, and the service_name is the instance name of the database server. Www.2cto.com Four, install and use Plsql.   If there are no surprises, you can now connect to the database using Plsql or Sqlplus.   Unload method: First, in the system variable, delete oracle_home, tns_admin, Nls_lang three variables, modify path variable, remove D:\Program files\instantclient_10_2 directory. Second, delete the client storage directory, the author of the D:\Program files\oracleclient other configuration methods:
  Use Plsql to connect to remote Oracle without installing an Oracle client