Configure Oracle 11g Green client and Plsql remote connection environment

Configure Oracle 11g Green client and PLSQL environment

This approach is done by using the Oracle-provided lite client, which is a green, free-to-install client. 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 to a directory (the directory can be customized according to personal preferences, placed in D:\Program Files (x86) \instantclient_11_2); Configure Environment variables: (Open environment Variable Configuration Interface actions: My Computer---properties---advanced---environment variables, you can create new or edit them in the System Variables section. Win7 The above operating system is: computer--attribute-Advanced system settings-environment variables 1) variable name: Oracle_home (if the machine does not have a server, test can be omitted) variable value: D:\Program Files (x86) \instantclient_11 _2
2) variable name: Tns_admin variable Value: D:\Program files (x86) \instantclient_11_2\ Description: This configuration item specifies the storage path of the Tnsnames.ora file. It is recommended that the last ' \ ' symbol of this value not be omitted, otherwise it may affect the plsql, the test is configured, missing ' \ ', the result plsql cannot 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 (x86) \instantclient_11_2 Three, in the Tns_admin (the value of the variable name) directory you defined, copy the file name Tnsnames.ora, and add your own database alias configuration in the file, examples are as follows:

Fsfsdb =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.70.128) (PORT = 1521))
(Connect_data =
(SERVER = dedicated)
(service_name = fsfsdb)
)
)

Mainly modifies the first = previous 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. Unload method: In the system variable, delete oracle_home, tns_admin, Nls_lang Three variables, modify the path variable, remove D:\Program Files (x86) \instantclient_11_2 directory.

Configure Oracle 11g Green client and Plsql remote connection environment