1. Questions
Plsql has only 32-bit programs so far, and most desktop systems are basically using 64-bit Windows operating system, on 64-bit Windows, in most cases also installs the 64-bit Oracle client program, this combination causes Plsql to not recognize the Oracle_home directory, and cannot read the connection string in the Tnsnames.ora file
2. Solutions2.1 Configuring the ORACLE_HOME environment variable on Windows
Right click on "My Computer" click on the "Properties" menu, go to the "System Properties" dialog box, select the "Advanced" tab, click "Environment Variables", in the User variable box area, create a new variable name named ' Oracle_home, according to their own ORACLE actual installation directory to fill their values, for example, The Oracle_home value of the author's environment is "C:\oracle\product\12.1.0\dbhome_1"
2.2 References instantclient-basic-win32-10.2.0.5
Unzip the Instantclient-basic-win32-10.2.0.5.zip file, compress the file, and copy it to the product under Plsql Developer installation directory, such as 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 file, the author has been uploaded to the "System performance Optimization Professional Group" group Sharing for you to download.
2.3 Configuring the Oracle_home and OCI libraries in Plsql2.3.1 Configuration Oracle_home
On the Plsql main menu, click Tools, select the Preferences submenu, go to the Preferences Page dialog box, on the right side of the Connections tab, locate the Oracle home directory name (automatically detect null), and in this box, fill in the Oracle's home directory name, such as "C: \ Oracle\product\12.1.0\dbhome_1 "
2.3.2 Configuring the OCI library
On the Plsql main menu, click Tools, select the Preferences submenu, go to the Preferences Page dialog box, on the right side of the Connections tab, locate the OCI library (automatically detect empty), and fill in the box with an absolute path to the Oci.dll file, such as: "C:\oracle\ Product\instantclient-basic-win32-10.2.0.5\instantclient_10_2\oci.dll "
3. Results
Once the above four-step configuration is complete, restart Plsql to identify the oracle_home and to locate the database connection string in the Oracle client Tnsnames.ora file.
This article Li Junjie (Network Name: casing), engaged in "system architecture, operating systems, storage devices, databases, middleware, applications" six levels of systematic performance optimization work
Welcome to the System performance Optimization Professional group, to discuss performance optimization technology together. Group number: 258187244
Plsql Unrecognized Oracle_home solution on 64-bit Oracle Client