To configure the ORACLE 11g green client and PLSQL environment, you can use the lite version client officially provided by ORACLE, that is, the green installation-free client. (The official versions are provided here ):
Clients used in Windows 32-bit Systems
There are many versions of the client Instant client used in other system environments: Basic and Basic Lite. The Basic version includes all the files that support running OCI, OCCI, JDBC, JDBC-OCI and support for multiple languages. Basic Lite is a Basic Lite version that only contains English Error Descriptions 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 for www.2cto.com is as follows: 1. Extract the downloaded Basic compressed package to a directory (this directory can be customized according to your preferences, and I will put it in D: \ Program Files \ oracleclient ); 2. Configure environment variables: (open the environment variable configuration interface. Operation: My computer --- properties --- advanced --- environment variables. Create or edit the environment variables in the system variables section. Win7: The above operating system is: Computer -- Property -- 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 \ Note: This configuration item specifies the storage path of the tnsnames. ora file. We recommend that you do not omit the '\' symbol at the end of the value, otherwise it may affect PLSQL. When I configure it, '\' is missing and 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 used by the connected database. For other types, you can go to the server and check it online. 4) modify the Path variable and add D: \ Program Files \ instantclient. 3. In the TNS_ADMIN directory you defined, the file name is tnsnames. add your own database alias configuration in the file. For example: MyDBName = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 172.16.1.16) (PORT = 1521 )) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ora10g) is used to modify the alias before the first '=', Host is the IP address, and SERVICE_NAME is the Instance name of the database SERVER. Www.2cto.com 4. install and use PLSQL. If no problem occurs, you can use PLSQL or SQLPLUS to connect to the database. Uninstall method: 1. In system variables, delete ORACLE_HOME, TNS_ADMIN, and NLS_LANG, modify the path variable, and remove the D: \ Program Files \ instantclient_10_2 directory. 2. Delete the client storage directory. The author's other configuration methods are D: \ Program Files \ oracleclient:
You can use plsql to connect to a remote oracle database without installing the oracle client.
Http://www.bkjia.com/database/201210/160958.html