Plsql developer in Win7 64-bit computer installation method, installation files are in my Baidu cloud, to prevent forgetting

1) Install Oracle 11g 64-bit 2) Installing the 32-bit Oracle Client (instantclient-basic-win32-11.2.0.1.0) : Http://www.oracle.com/technetwor ... oft-095945-zhs.html Download Instantclient-basic-win32-11.2.0.1.0.zip (must be 32-bit, do not make the wrong version, the Oracle website has downloaded), Unzip it to product under the Oracle installation directory (this machine is named: instantclient_11_2): D:\Oracle\app\YM\product\instantclient_11_2. Copy a directory under the root directory of the database installation D:\Oracle\app\YM\product\11.2.0\dbhome_1\NETWORK to the Oracle client directory D:\Oracle\app\YM\product\ Instantclient_11_2 (in fact only need Network\admin\tnsnames.ora) 3) Install PL/SQL Developer Install PL/SQL Developer, set up OCI library and Oracle_home in Perference->connection, for example, native settings: Oracle home:d:\oracle\app\ym\product\instantclient_11_2 OCI Library:d:\oracle\app\ym\product\instantclient_11_2\oci.dll 4) Set Environment variables (modify path and tns_admin environment variables) For Nls_lang environment variables, it is best to set to the same as the database side, first query the character set information from the database side: Sql> Select Userenv (' language ') Nls_lang from dual; Nls_lang ---------------------------------------------------- Simplified Chinese_china. Zhs16gbk Right-click My Computer-Properties-advanced-environment variables-system environment variables: 1> Select "Path"-click "Edit" to add "D:\Oracle\app\YM\product\instantclient_11_2;" 2> Click "New", the variable name is set to "Tns_admin", the variable value is set to "D:\Oracle\app\YM\product\instantclient_11_2;", click "OK"; 3> Click "New" and the variable name is set to "Nls_lang" and the variable value is set to "simplified Chinese_china. ZHS16GBK ", click" OK "; Finally click "OK" to exit. Start PL/SQL Developer and run without problems.

1. Log in to PL/SQL Developer

This omits the installation steps for the Oracle database and PL/SQL Developer, and note that when you install the PL/SQL Developer software, do not install it under the program Files (x86) directory or you cannot start PL/SQL Developer.

Wonder why the database TNS is not chosen here? I installed the database first and then installed PL/SQL Developer. When the PL/SQL developer is installed, Oracle home and OCI Libaray have been identified. What about it? Log in to PL/SQL Developer with non-login first, set up Oracle home and OCI Libaray.

The Oracle home directory is not automatically recognized under Oracle home, and the Oracle home path is manually specified.

Click "OK" to exit PL/SQL Developer and log in again.

Or choose not to database TNS, try to log in without a database to see what errors are reported.

Finally found the key point of the problem, the installation of PL/SQL Deleloper can only recognize the 32 oci.dll. It seems to be a 64-bit PL/SQL Deleloper, so search the web for PL/SQL Deleloper 64-bit version. However the Discovery PL/SQL Deleloper does not differentiate between 64-bit and 32-bit. It seems that we can only start with Oci.dll. According to the above error message, it appears that just install a 32-bit version of Oracle Client.

2. Install Oracle Clinet

First download an Oracle 11g Client to the Oracle website, but you will need to apply for an Oracle account before you can download it.

Current: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

This is a green version of Oracle Client, so as long as it needs to be decompressed, it can be. Unzip the downloaded Oracle client file Instantclient-basic-win32-11.2.0.1.0.zip to the C drive (note!). Cannot be under 64-bit). Then create a new network\admin directory under the extracted C:\instantclient_11_2 directory, create a new Tnsnames.ora file in the Admin directory, and add the database TNS.

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = chiclewu-pc) (PORT = 1521))
(Connect_data =
(SERVER = dedicated)
(service_name = ORCL)
)
)

(Note: The Tnsnames.ora file can also be copied from the Network\admin directory of the Oracle database home directory, as well as the Sqlnet.ora.) Then determine whether the host configuration is correct, if host is the hostname, you need to remove the domain name after the hostname)

3. Configuring the Oracle Home and OCI libaray for PL/SQL developer

Enter the PL/SQL Developer in non-logon mode, designate the Oracle home path as the Oracle Client directory (C:\instantclient_11_2), and the OCI Libaray path to Oracle The Oci.dll (C:\instantclient_11_2\oci.dll) of the client directory.

Click "OK" and now the configuration is complete, here is the time to wait for a miracle. Exit PL/SQL Developer.

4. Verifying Oracle Client

Open a new PL/SQL Developer, enter the user name and password, under the database option, you can see the TNS that has just been configured.

Waiting for the miracle moment ....

After a few seconds of waiting, the miracle time has finally arrived, you can login, you can login ...

Check to see if the data can be queried.

Query data no problem, finally finished.

Plsql developer in Win7 64-bit computer installation method, installation files are in my Baidu cloud, to prevent forgetting