Windows 64 bit installation of Oracle 11g, PLSQL developer configuration problems, database display blank perfect solution (text tutorial)

Time:2020-7-10

After installing PL SQL, if the database in the figure below is empty. A 32-bit client needs to be installed, indicating that PL SQL does not support 64 bit client connections.

terms of settlement:

1. Download and install the 32-bit Oracle client

2. Setting up PLSQL developer

Open PL SQL and set the OCI Library (i.e. the installation location of Oracle 32-bit) in tools, preferences and connection

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

As shown in the figure below:

3. Add environment variable

Add the following variables to the system variable:

The first one points to the directory where the TNS files are located. This directory is the directory where the TNS files of the 64 bit version of Oracle you installed are located. The TNS file is the file that stores 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 code.

NLS_LANG:SIMPLIFIED CHINESE_CHINA.ZHS16GBK

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

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, that is, the name of the database at the time of installation)

oracle_sid:orcl

The fifth is Oracle_ home

oracle_ Home: it can not be set. If it is set correctly, it cannot be used.

If you forget the instance name of Oracle installation, you can open the registration to 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 to take effect!

The above is the introduction of windows 64 bit installation of Oracle 11g, PLSQL developer configuration problems, database display blank perfect solution (text tutorial), I hope to help you, if you have any questions, please leave me a message, the editor will reply you in time. Thank you very much for your support to the developeppaer website!

Recommended Today

The company has a new 20K test, which let me see what the real test ceiling is

Today’s morning meeting at work was a meeting ceremony for new people. I heard that a very powerful boss came. He left his last company and his salary has reached the medium level. Many people are curious. It shouldn’t be easy to get this salary. Sure enough, when I introduced myself, I was surprised to […]