Summary of 64-bit installation of Oracle instantclient for Windows 7 and PL/SQL developer

Operating System: Windows 7 64-bit flagship

Required. Install PL/SQL developer for development.

First. Download the simplified green version of Oracle

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

Note that you need to download a 32-bit version, because PL/SQL developer currently only has a 32-bit version.

Second. install and configure instantclient

Decompress the package to D: \ oracle \ instantclient_11_2.

Create Directory D: \ oracle \ instantclient_11_2 \ Network \ admin

Put tnsnames. ora in the following format:

# Tnsnames. ora network configuration file: % ORACLE_HOME % \ 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)
)
)

Notes:

It seems that SERVICE_NAME can also be written as Sid.

Pay attention to top-level writing for all characters. Otherwise, unexpected problems may occur.

Set the following environment variables

ORACLE_HOME = D: \ oracle \ instantclient_11_2

Tns_admin = % ORACLE_HOME % \ Network \ admin

Nls_lang = simplified chinese_china.zhs16gbk

Add % ORACLE_HOME % at the beginning of the PATH variable;

Third. Install PL/SQL developer and configure

:

Http://download.allroundautomations.com/plsqldev1001.exe

Http://download.allroundautomations.com/plsqldev906.exe

Note that the installation cannot be performed in folders with (x86 ).

In PLSQL developer, set ORACLE_HOME and OCI Library:
Tools-> preferences-> Oracle-> connection:
ORACLE_HOME: D: \ oracle \ instantclient_11_2
OCI Library: D: \ oracle \ instantclient_11_2 \ OCI. dll

How to extend the trial period of PLSQL developer, delete the registry once every 30 days
Delete the following registry content:
HKEY_CURRENT_USER \ Software \ allround Automations
HKEY_CURRENT_USER \ Software \ Microsoft \ Security

Finally, if you do not want to configure environment variables, you can write a batch.

You can create a. BAT file in the directory where PL/SQL developer is located. The content of the file is as follows (refer to the self-installed client path ):

@ 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