Correct installation of oracle11g Plsql under Win7-64bit

Source: Internet
Author: User

I installed the Oracle 11g version of the database service on the PC, and I always connect to the database through PL/SQL.becausePlsqlNo --bit version, through32bitof thePlsqlConnection -bit ofOracleerror, the first one needs to install a +bit ofOracleClient Toolsinstantclientfor conversion, the second typePlsqlcannot install to a directory name that contains parentheses()directory, otherwise the operation is unsuccessful. Below is a detailed description of the installation environment.

After the oracle11g is properly installed, you also install the ORACLE10G Client tool. There are two ways to solve this:

A Download the installation version

Download the oracle10g client, or download the oracle10g installation Client tool,

Then install, when the installation is complete, copy the oracle11g D:\oralce11g\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora to the oracle10g installation directory D:\ Oracle\product\10.2.0\client_1\network\admin\ under, if any, overwrite. \

then configure plsql to open the tools-->preferences window to configure Oracle Home and Oracle library, because Plsql does not display, I just described under the text, configure the Oci.dll library, open plsql, do not need to login, window--preferences/ Preferences--oracle (upper left corner of the window)---Connect to the/connection--configuration to the right of the Oracle directory to the oracle10g installation directory, OCI Library executes the Oci.dll file under the Oracle Directory Bin (when the directory is configured, the Oci.dll File selection dropdown box can be automatically identified)


Second, download the green version

1 , download Oracle Client

Download Instantclient-basic-win32-10.2.0.5.zip ,: http://www.oracle.com/technetwork/topics/winsoft-085727.html

2 , installation instantclient

Unpacking the installation package Instantclient-basic-win32-10.2.0.5.zip , unzip the directory: D:\Program files\destination files\oracleclient

then create a directory D:\Program files\destination files\oracleclient\network\admin

3 , copy Tnsnames.ora

will be D:\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN under the directory Tnsnames.ora files are copied to D:\ProgramFiles\destination files\oracleclient\network\admin under

4. Configure the Plsql Oracle directory and the Oci.dll file.

Since Plsql does not display, I will describe the text, configure the Oci.dll library, open plsql, do not need to login, window--preferences/preferences--oracle (upper left corner of the window)---connection/connection--configuration to the right of The Oracle directory points to the installation directory of the oracle10g, and the OCI library executes the Oci.dll file under the Oracle Directory Bin (when the directory is configured, the Oci.dll File selection dropdown box is automatically recognized)


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.