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