Plsqloracle_home solution cannot be identified by plsql on 64-bit ORACLE clients

Source: Internet
Author: User

Plsqloracle_home solution cannot be identified by plsql on 64-bit ORACLE clients
1. Problems

Plsql has only 32-bit programs so far, and most desktop systems use 64-bit windows operating systems. On 64-bit windows, in most cases, the 64-bit ORACLE client program is installed. This combination causes plsql to not identify the ORACLE_HOME directory and cannot read tnsnames. connection string in the ora File

2. Solution 2.1 configure ORACLE_HOME environment variables on windows

Right-click "my computer" and click "properties" to go to the "System Properties" dialog box. Select "advanced" and click "environment variables". In the "user variables" box, create a variable named 'oracle _ HOME, and fill in the value according to the actual installation directory of your ORACLE. For example, the value of ORACLE_HOME in my environment is "C: \ oracle \ product \ 12.1.0 \ dbhome_1"

2.2 reference instantclient-basic-win32-10.2.0.5

Decompress the instantclient-basic-win32-10.2.0.5.zip file and copy the compressed file to the product directory in the installation directory of PLSQL Developer, for example, C: \ oracle \ product \. The final instantclient directory is C: \ oracle \ product \ C: \ oracle \ product \ instantclient-basic-win32-10.2.0.5 \ instantclient_10_2

Instantclient-basic-win32-10.2.0.5.zip files, the author has been uploaded to the "System Performance Optimization professional group" group sharing for you to download.

2.3 configure ORACLE_HOME and OCI database 2.3.1 in PLSQL to configure ORACLE_HOME

On the PLSQL Main Menu, Click Tools and select the Preferences sub-menu to go to the "preferred page" dialog box. On the right side of the "connection" tab, find "Oracle main directory name (empty for automatic detection )", enter the oracle home directory name in this box, for example, "C: \ oracle \ product \ 12.1.0 \ dbhome_1"

2.3.2 configure the OCI Library

On the PLSQL Main Menu, Click Tools and select the Preferences sub-menu to go to the "preferred page" dialog box. On the right side of the "connection" tab, find "OCI Library (empty for automatic detection )", enter oci in this box. dll file absolute path, such as: "C: \ oracle \ product \ instantclient-basic-win32-10.2.0.5 \ instantclient_10_2 \ oci. dll"

3. Results

After completing the preceding four steps, restart PLSQL to identify ORACLE_HOME and find the database connection string in the tnsnames. ora file of the ORACLE client.


 

Author: LI Junjie (Network Name: Step-by-Step), engaged in "system architecture, operating system, storage device, database, middleware, application" six levels of systematic performance optimization work

Join the system performance optimization professional group to discuss performance optimization technologies. GROUP: 258187244

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.