Installation and Use of Oracle and plsqldev in Win7-64bit

Symptom description:Installed successfully in Win7-64bitOracle_win64_11gr2_databaseAndPlsqldev715After
When plsqldev is started, it cannot recognize the Oracle instance

Main reasons:A 32-bit application PLSQL developer encountered an error when loading 64-bit OCI. dll !!

Solution:1. Download the Oracle Instant Client
Address http://www.oracle.com/technetwork/indexes/downloads/index.html
Click the Instant Client in the database column, and then click the Instant Client for Microsoft Windows (32-bit) link on the page.
On the new page, click the accept license agreementoption option, and then click the instantclient-basic-nt-11.2.0.2.0.zip download link.
The link is markedInstant Client package-Basic: All files required to run OCI, occi, and JDBC-OCI applications
ActuallyHttp://download.oracle.com/otn/nt/instantclient/112020/instantclient-basic-nt-11.2.0.2.0.zip
2. decompress the Oracle Instant Client
Decompress the downloaded instantclient-basic-nt-11.2.0.zip file of 47.9mbto your local device.
In principle, it can be extracted to any directory, but it is not recommended that the path name contain Chinese characters and spaces.Here I decompress it to the % ORACLE_HOME % \ product \ directory.
3. Copy tnsnames. ora to the instantclient_11_2 root directory.
In \ % ORACLE_HOME % \ product \ 11.2.0 \ dbhome_1 \ Network \ admin \,Copy tnsnames. ora to the instantclient_11_2 root directory.
You can also create the tnsnames. ora file by yourself. The template configuration is as follows:
System identifier SID =
(Description =
(Address = (Protocol = TCP) (host = Database Server IP address) (Port = port ))
(CONNECT_DATA =
(Server = dedicated)
(SERVICE_NAME = Database Service name) or (SID = Database Service name)
)
)
Note: even after the tnsnames. ora file is created in the instantclient_11_2 root directory, plsqldve occasionally cannot recognize Oracle instances.
So I simply copied the sqlnet. ora, listener. ora, and tnsnames. ora files to the instantclient_11_2 root directory.
Practice has found that after doing so, there will be no failure in plsqldev's identification of Oracle instances. For details, refer
4. configure system environment variables
Win7 --- computer --- properties --- advanced system settings --- environment variables --- add tns_admin and nls_lang variables to the System Variables
Tns_admin = % ORACLE_HOME % \ product \ instantclient_11_2
Nls_lang = american_america.al32utf8 or simplified chinese_china.zhs16gbk
American_america is fixed, because instantclient does not support other languages, and the last half of al32utf8 depends on the character set of the database.
5. Configure plsqldev connection Parameters
Start plsqldev --- tools --- preferences --- connection --- configure the path of Oracle Home and OCI Library
Oracle Home should navigate to the decompressed directory of instantclient, And the OCI library points to the OCI. dll under this directory.
Oracle Home = % ORACLE_HOME % \ product \ instantclient_11_2
OCI library = % ORACLE_HOME % \ product \ instantclient_11_2 \ OCI. dll
6. Restart plsqldev.

Supplement:You can also write a batch processing (*. BAT) file to automatically set the variables required to start plsqldev. As shown below
@ Echo off
Set tns_admin = D: \ develop \ oracle \ product \ instantclient_11_2
Set nls_lang = american_america.al32utf8
Start D: \ Program "" files \ PLSQL "" Developer \ plsqldev.exe