Plsql Connecting Oracle

Transfer from http://blog.csdn.net/chen_zw/article/details/9292455

Recently changed a 64bit computer, so the Oracle database has been replaced by 64bit, but the problem also arose, because Plsql developer temporarily no 64bit version, so can not connect to the 64bit of Oracle, after a toss, Finally successfully connected to the database, the configuration process is now recorded for viewing.

1. Download instantclient-basic-win32-11.2.0.1.0 (Oracle 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 E:\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:e:\app\administrator\product\instantclient_11_2

OCI Library:e:\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 "E:\app\Administrator\product\instantclient_11_2;"
2> Click "New", the variable name is set to "Tns_admin", the variable value is set to "E:\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