PLSQL has only 32-bit programs so far, and most desktop systems use 64-bit Windows operating systems. In 64-bit Windows
PLSQL has only 32-bit programs so far, and most desktop systems use 64-bit Windows operating systems. In 64-bit Windows
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. Solutions
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 libraries in PLSQL
2.3.1 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 of the "Connections" 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.
After Oracle 10g is installed, restart the system. If PLSQL is used for connection, no listening is reported.
ORA-03114 PLSQL process compilation disconnection Error
Simple configuration of PLSQL connection to Oracle
Detailed description on Performance Improvement of PLSQL batch Forall operations
Use Oracle SQLDeveloper to connect to the database and create a user
Oracle PL/SQL Developer import and export data
Install the Oracle 11g and Oracle SQL Developer clients in 64-bit Windows 7
This article permanently updates the link address: