About Plsql Landing oracle11g Unable to read Oracle database issues

As the landlord is a new WIN10 system, so some configuration environment is not configured well, it may be the configuration of the environment, or in the Oracle tool preferences in the home directory is not configured.

Original address: https://www.2cto.com/database/201503/386267.html

1. Questions

Plsql so far only 32-bit programs, and most of the desktop system is basically the use of 64-bit Windows operating system, on 64-bit Windows, most of the time is also installed 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. Solution 2.1 Configure 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 2.3.1 configuration in Plsql 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.

Original address: http://blog.csdn.net/netdevgirl/article/details/27818709

An alternative solution:

　　

64-bit Oracle 11g is installed, and the Oracle database cannot be read after you have configured it with Plsql developer.

Phenomena such as:

Combined with their own analysis and other information, summed up the solution.

1 because Plsql developer is 32-bit, all the clients that need to download oracle32 bits,

Address: http://www.oracle.com/technetwork/topics/winsoft-085727.html.

Instantclient-basic-nt-11.2.0.4.0.zip. Free installation version of the download down to unzip the Local on the line.

2 Assume: Oracle's installation home path is D:\oracle\product\11.2.0;

The client's decompression address is D:\oracle\instantclient_11_2.

3 Configuring Environment Variables: This step differs slightly from the other methods, where you can not copy the Tnsnames.ora file to the client directory.

(I believe this is not to mention how to configure the environment variables):

Tns_admin =d:\oracle\product\11.2.0\dbhome_1\network\admin

Nls_lang = Simplified Chinese_china. Zhs16gbk

Description: Tns_admin, refers to the directory name where the Tnsnames.ora file resides.

If you specify to the client directory, you must copy the Tnsnames.ora file.

Nls_lang environment variables, to be set to the same as the database side, you can query the character set information in Sqlplus

Sql> Select Userenv (' language ') Nls_lang from dual;
Nls_lang
----------------------------------------------------
Simplified Chinese_china. Zhs16gbk

4 The use of the client is here:

Set up Oracle Home for Oracle installation directory Home

Set the full path name of the Oci.dll file for the OCI library to the Oracle client.

Apply & Ok.

5 Turn off the Plsql and reboot. Look, now there's a

Here is the main point is two, the environment variable tns_admin configured to Tnsnames.ora file is located in the directory name;

The OCI library in Plsql is set to the Oci.dll of the Oracle client.

About Plsql Landing oracle11g Unable to read Oracle database issues