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

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.