Get the App
SLTechnology News&Howtos  ›  Database  › 

PL/SQL Developer connection OracleX64

Shulou Source: shulou.com Published: 2022-06-01 11:42:55 10月03日 Update

Because PL/SQL can only connect to 32-bit Oracle, it takes a little bit of trouble to connect 64-bit ones. Installing oracle client software directly is a bit of a hassle, so there are the following official methods. Use PL/SQL Developer to connect to OracleX64 version: 1. Download 32-bit Oracle InstantClient (instantclient-basic-nt-11.2.0.2.0) and expand to a directory, such as C:\ instantclient-basic-nt-11.2.0.2.0;2. Copy the tnsnames.ora of the system to this directory; 3. Set Oracle_Home and OCI Library in PLSQL Developer: ToolsPreferencesOracleConnection:Oracle_Home:C:\ instantclient-basic-nt-11.2.0.2.0OCI Library:C:\ instantclient-basic-nt-11.2.0.2.0\ oci.dll

Tags: Directory trouble official customer client copy method version system Software Central Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno macOS vpn Docker NVidia MariaDB