1. Download instantclient-basic-win32-11.2.0.1.0
(Oracle official Website:http://www.oracle.com/technetwork/topics/winsoft-085727.html, 2:http://download.csdn.net/ detail/czw2010/5732241)
2. Unzip the instantclient-basic-win32-11.2.0.1.0 and place it under the product of the Oracle installation directory (where no mandatory placement is required and can be placed at will), such as:
3. Copy the Tnsnames.ora file under D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN to Instantclient_11_2.
4. Open Plsql Developer, select Tools, perference, Connection, configure the Oracle home and OCI library entries as shown in:
Among them, Oracle home:d:\app\administrator\product\instantclient_11_2
OCI Library:d:\app\administrator\product\instantclient_11_2\oci.dll
5. Configuring System Environment Variables
Right-click My Computer-Properties-advanced-environment variables-system environment variables:
1> Select "Path"-click "Edit" to add "D:\app\Administrator\product\instantclient_11_2;"
2> Click "New", the variable name is set to "Tns_admin", the variable value is set to "D:\app\Administrator\product\instantclient_11_2;", click "OK";
3> Click "New" and the variable name is set to "Nls_lang" and the variable value is set to "simplified Chinese_china. ZHS16GBK ", click" OK ";
Plsql Connecting Oracle Database Configuration