Windows 64-bit installation Oracle Instantclient official Green Edition and PL/SQL Developer summary

Original: http://blog.csdn.net/kimsoft/article/details/8751267

Operating system: Windows 7 64-bit flagship

requirements, install PL/SQL developer for development

First, download the official Oracle Lite Green Edition

Http://www.oracle.com/technetwork/topics/winsoft-085727.html

Special note To download the 32-bit, because PL/SQL developer currently has only 32-bit versions

Second, installation configuration instantclient

After downloading, unzip to D:\Oracle\instantclient_11_2 (especially note that this directory can only be a combination of alphanumeric underscores, otherwise problems may occur)

Create Directory D:\Oracle\instantclient_11_2\network\admin

Put a Tnsnames.ora, the contents are as follows:

# TNSNames. ORA Network Configuration File:%oracle_home%\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
eoa_249 =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.3.249) (PORT = 1521))
)
(Connect_data =
(service_name = devdb)
)
)

Note the points:

Service_Name as Sid seems to be possible.

All the characters note shelf write, otherwise there may be unexpected problems

Set the following environment variables

Oracle_home=d:\oracle\instantclient_11_2

Tns_admin=%oracle_home%\network\admin

Nls_lang=simplified Chinese_china. Zhs16gbk

The path variable is prefixed with%oracle_home%;

III. installation of PL/SQL Developer and Configuration

：

http://allroundautomations.com/

Special note that installation cannot be installed in a folder with (x86)

Set up the Oracle_home and OCI Library in Plsql Developer:
Connection, Oracle, Tools-Preferences
Oracle_home:d:\oracle\instantclient_11_2
OCI Library:d:\oracle\instantclient_11_2\oci.dll

Plsql Developer Extension Probation method, 30 days Delete registry
Delete the following registry content:
Hkey_current_user\software\allround automations
Hkey_current_user\software\microsoft\security

Finally, a friend who doesn't want to configure environment variables can write a batch

You can create a. bat file in the same directory as the PL/SQL developer, as follows (the path references the client path that you installed):


@echo off

Set Oracle_home=d:\oracle\instantclient_11_2
Set path=%oracle_home%;%path%;
Set Tns_admin=%oracle_home%\network\admin
Set Nls_lang=simplified Chinese_china. Zhs16gbk
Start Plsqldev.exe

Windows 64-bit installation Oracle Instantclient official Green Edition and PL/SQL Developer summary