64-bit Oracle PLSQL Installation

Ii. PL/SQL developer Installation

1. Download and install

Http://allroundautomations.swmirror.com/plsqldev802.exe

The registration code is self-searched, and many of them have registration machines.

Note: Do not install it in the default c: \ Program Files (x86) directory. Otherwise, an error is reported because the path with () cannot be parsed.

2. the following error is reported when PL/SQL developer is started.

The reason is OCI. the DLL is 64-bit, and the 32-bit application PLSQL developer cannot load it. I searched the internet for a solution: I can install a 32-bit Oracle client, I usually don't use the client function, so I don't want to install it if it's too big. Later, I referred to this article to Avoid installing the Oracle client software-using PL/SQL configuration to log on.

3. DownloadOracle client packageHttp://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html

Download instantclient-basic-win32-10.2.0.4.zip.

4. decompress the package to c: \ oracle_client. The OCI directory is c: \ oracle_client \ instantclient_10_2.

5. Start PL/SQL developer, click Cancel, and do not log on to tools \ perferences.
Configure ORACLE_HOME and OCI library in connection, as follows:

Oraclehome: oradb10g_home1

OCI Library: C: \ oracle_client \ instantclient_10_2 \ OCI. dll

6. Set system environment variables

Tns_admin = c: \ oracle \ product \ 10.2.0 \ db_1 \ Network \ admin

Nls_lang = american_america.zhs16gbk

Note: The first half of nls_lang must be american_america, Because instant client does not support other languages. The latter half can be adjusted based on the character set of your database. If the database uses al32utf8, you can set al32utf8.

7. Start PL/SQL developer. OK is okay.