(64-bit Oracle uses 32-bit plsql) to install 64-bit Oracle database software using a 32-bit Plsql Developer Connection method

Source: Internet
Author: User

As Plsql developer did not provide 64-bit, so according to the information on the Internet to do a bit of finishing, sent up

1. Download and install the Oracle 11g R2 64-bit, ignoring the hardware detection failure information when installing on the server;

2, download the Oracle 11g R2 32-bit client, unzip it to the D:\app\Jack\product directory, and named Instantclient;
Client download can go Baidu: Instantclient-basic-nt-11.2.0.2.0.zip must be able to find, remember is the next 32 bit

3, download and install PL/SQL 9.0 (or above), the installation process PL/SQL will automatically detect the client directory, loading the corresponding DLLs, respectively: Oracle home=d:\app\jack\product\instantclient; OCI Library=d:\app\jack\product\instantclient\oci.dll. If there is no automatic detection of the situation, in the absence of landing tools->preferences connection set up the Oracle home and OCI Library;

4. Key step: Copy a directory under the root directory of the database installation D:\app\Jack\product\11.2.0\dbhome_1\NETWORK to the Oracle client directory D:\app\Jack\product\ instantclient;

5, Start Oracle database service Oracleoradb11g_home1tnslistener and ORACLESERVICEORCL, user login, connect PL/SQL Success!

6, another to get a Chinese bar, or some Chinese support is not very good, such as stored procedures, etc.

Environment variable: nls_lang= "simplified Chinese_china. ZHS16GBK "

(64-bit Oracle uses 32-bit plsql) to install 64-bit Oracle database software using a 32-bit Plsql Developer Connection method

Related Article

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.