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

PLSQL Developer 11.06Chinese Green Registration Edition (Oracle11g-free client)

Download link: http://pan.baidu.com/s/1qYapNNe password: momh

The context of the problem

Installing PLSQL DEVELOPER 11 and Oracle 11g X64 Client (64-bit) in a Win 7 x 64-bit environment cannot be successfully installed.

The cause of the problem

The whole problem is that PLSQL DEVELOPER 11 cannot execute 64-bit OCI.DLL, but Win7 X64 can only install 64-bit Oracle client X64.

Instead, you need to download one more Oracle Instant client X32, assign the OCI.DLL of the header to PLSQL DEVELOPER 11, and set some environment variables before it can be executed properly.

The solution to the problem

Here are the steps:

Go to the Oracle official website to download Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (x64), and then install it according to the following steps:

a. Execute win64_11gR2_client\ client\ setup.exe to install, at first there is a black detection screen, and then go to the installation screen after disappearing.

b. After entering the installation screen, select the items you want to install, and here you can choose [General running Program version] to install.

C. [execution language] use default values: [simplified Chinese], [English].

D. Enter D:\ Oracl11_64 into the Oracle basic directory.

e. Next, press "next" until [finish].

Download PLSQL Developer 11 and extract it to a specific directory.

PLSQL Developer download link: http://pan.baidu.com/s/1kUF1lC7

Password: toeo

Go to the Oracle official website to download Instant Client for Microsoft Windows (32-bit), select instantclient-basic-nt-11.2.0.2.0.zip, and extract the instantclient_11_2 to the directory D:\ Oracl11_32.

Enter [console] → [system Security Settings] → [system] → [Advanced system Settings], and the following window pops up:

Click [Environmental variables].

Point user variable, click [Edit] to modify. The following are the environment variables to modify:

Variable name: TNS_ADMIN

Value: d:\ Oracl11_64\ product\ 11.2.0\ client_1\ network\ admin

Variable name: NLS_LANG

Value: SIMPLIFIED CHINESE_CHINA.ZHS16GBK

This value can be queried using SQLPlus, as follows:

a. Open SQLPlus, enter the account number: XX@DB string, password: XXX.

b. Enter the SQL instruction: select userenv ('language') from dual.

Variable name: PATH

Value: add D:\ Oracl11_32\ instantclient_11_2 so that the OCI Library setting of PLSQL Developer 11 can be selected to oci.dll.

Enter [PLSQL Developer 8] → [Tools] → [preference], and modify the connection settings:

[Oracle_HOME]: point to D:\ Oracl11_32\ instantclient_11_2.

[OCI]: click the black box on the left side of OCI library to turn into a green box and point to D:\ Oracl11_32\ instantclient_11_2\ oci.dll.

Copy the tnsnames.ora to the D:\ Oracl11_64\ product\ 11.2.0\ client_1\ network\ admin path.

Reopen PLSQL Developer and you can start using it.

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.