Shulou(Shulou.com)06/01 Report--

The solution of not connecting 64-bit Oracle with PLSQL developer

The referencing function is turned off.

Oracle 11g 64-bit is downloaded from Windows 64-bit. The following problems occur when using PLSQL Developer:

1. The Database drop-down box is empty:

2. Enter a user name, password and Database forcefully, and log in and pop up:

Quote

Initialzation error

Could not initialize

"...."

Make sure you have the 32 bits Oracle Client installed.

OracleHomeKey:

OracleHomeDir:...

Found:oci.dll

Using:

...

Loadlibrary (...)

Returned 0

Indicates that PLSQL Developer does not support Oracle 64-bit client connections.

Solution:

1. Download 32-bit Oracle client

Actually, you can download the installation-free version, http://www.oracle.com/technetwork/topics/winsoft-085727.html.

I downloaded the first one: http://download.oracle.com/otn/nt/instantclient/112030/instantclient-basic-nt-11.2.0.3.0.zip

Download needs to log in, you have to register an account in Oracle before you can download it!

2. Decompression

Unpack the downloaded file, such as I extracted it to E:\ app\ instantclient_11_2

3. Set PLSQL Developer

In tools-preferences, connections, OCI Library input

E:\ app\ instantclient_11_2\ oci.dll

As shown below:

4. Add environment variables

Add environment variabl

Add 2 to the system variable:

The first one points to the directory where the TNS file is located, which is the directory where you installed the 64-bit version of Oracle's TNS file. The TNS file is the file that saves the connection information.

TNS_ADMIN value: e:\ app\ OYK\ product\ 11.2.0\ dbhome_1\ NETWORK\ ADMIN

The second is to specify the encoding used by the database. If it is not set to the following value, then after connecting to the database, all the Chinese content you see will be garbled and a bunch of question marks.

NLS_LANG value: SIMPLIFIED CHINESE_CHINA.ZHS16GBK

Note: after setting the environment variable, be sure to log out or restart the computer to take effect!

The above passed the test under Win7X64. Through the 4-step setting, you can connect the Oracle database of this machine and other machines normally. \

\

Method 2:

Change the PL/SQL develop installation address (do not (86), do not C disk) can!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.