Connect to a 64-bit database using a 32-bit plsql through a 64-bit Oracle Client

Oracle client: 11.0.2 (64-bit, official website)

Plsql:plsqldev1104.zip is a Baidu looking for the installation package

Reference Tutorial:

A:http://jingyan.baidu.com/article/fb48e8be4c7c206e622e1491.html

B:https://jingyan.baidu.com/album/49ad8bce4f934e5834d8faa8.html?picindex=7

1. Install the client, configure TNS under D:\app\Administrator\product\11.2.0\client_1\network\admin after installation is complete

2. Test, from the Start menu, locate the sqlplus that you installed in the client directory to open the test user: [email protected] (TNS with TestDB), Password: * * * Connect successfully to the next step, otherwise continue to study

3. Install Plsql, almost the next step in the next rhythm to complete

4. Open Plsql can first try to log in to see if you can log in, I mean the OCI file related issues

5. Download the 32-bit client file referenced in tutorial A to copy the Oci.dll file to D:\app\Administrator\product\11.2.0\client_1\bin, (I'm all copied in, Just replaced the duplicate oci.dll)

6. Open Plsql, try to login, success has been, not successfully cancel login into the open Plsql interface then tools (Tools)---preferen ... (That is, the first option, preferences)--------find where Oraclehome and OCI are configured, home is configured to

D:\app\Administrator\product\11.2.0\client_1\bin OCI configured as D:\app\Administrator\product\11.2.0\client_1\bin\oci.dll Then OK, close, can try to login again, successfully stop otherwise continue

7. Add the configuration environment variable: Tns_admin value: D:\app\Administrator\product\11.2.0\client_1\network\admin and then try to log in Plsql (my success here)

8. If you do not successfully check the problem according to the error, but also need to configure the encoding set, or else may appear in Chinese garbled situation, reference tutorials have methods, you can refer to the test

Connect to a 64-bit database using a 32-bit plsql through a 64-bit Oracle Client