Windows 64-bit installation of Oracle 11g,plsql Developer configuration issues, the perfect solution for the database display blank (graphics tutorial) _oracle

When the PL SQL is installed, the database at the following figure is empty. You need to install a 32-bit client, stating that PL SQL does not support 64-bit client connections.

Solution:

1. Download the 32-bit Oracle client and install

2, set up Plsql Developer

Open PL SQL in Tools-preferences-connections, set the OCI library (that is, Oracle 32-bit installation location)

D:\app\Administrator\product\11.2.0\client_1\oci.dll

The following figure:

3. Add Environment variables

Add the following variable to the system variable:

The first is the directory where the TNS file resides, which is the directory of the 64-bit Oracle TNS files that you installed. The TNS file is the file that holds the connection information.

Tns_admin:d:\app\administrator\product\11.2.0\dbhome_1\network\admin

The second is to specify the encoding used by the database to avoid garbled characters.

Nls_lang:simplified Chinese_china. Zhs16gbk

The third is path, the first value is more important, can not be mistaken, it is the client location, it affects the use of PL SQL, the general default is normal.

Path:d:\app\administrator\product\11.2.0\client_1;d:\app\administrator\product\11.2.0\dbhome_1\bin; ...

The fourth is Oracle_sid (ORCL instance name, which is the name of the database at installation time)

Oracle_sid:orcl

The fifth one is oracle_home.

Oracle_home: You can not set, if the settings must be correct, otherwise can not be used.

If you forget the instance name at Oracle installation, you can open the registration view, as shown in the following figure:

After the above settings, PL SQL can be used normally.

Note: After setting the environment variable, you may have to log off or restart the computer before it takes effect!

The above is a small set to introduce the Windows 64-bit install Oracle 11g,plsql Developer configuration problem, the database shows a blank perfect solution (graphics and text tutorial), I hope to help you, if you have any questions please leave me a message, Small series will promptly reply to everyone. Here also thank you very much for the cloud Habitat Community website support!