Win7 64-bit Ultimate installation PL/SQL Developer error solution

Win7 is gradually becoming the mainstream Windows operating system
, its 32- and 64-bit systems are equally divided. However, when there is no 64-bit PL/SQL Developer available, when using 32-bit PL/SQL Developer to connect Win7 (64-bit) as the server's Oracle, there will always be such errors, through online information and self-testing. Find a way to use it normally.

1. Download the oracle client (http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html)

Download 32-bit ones. This client is different from the standard client of oracle. It does not need to be installed. It can be decompressed to a certain path! For example, extract it to the F:\\TOOLS_APP2 directory.

2, configure the client

Install the folder NETWORK/ADMIN two-level directory under the directory where the files are extracted in step 1, and create the tnsnames.ora file in ADMIN

Enter the connection string for the DB in the file:

SAMPLE =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP )(HOST = 192.168.1.120)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = dbname)

)

)

Mainly configure the IP address and DB name of the DB server. I believe that friends who have used PL /SQL connection oracle know this connection file, will not be detailed.

3, download and install PL /SQL Developer

Download the official version or crack version of PL /SQL can be installed directly. Note: There should be no parentheses in the installation path. Do not install it in the C:\\Program Files (x86) directory.

4. Configure PL/SQL

4.1. Open PL/without user login. SQL

4.2, open the Preference menu item through the TOOLS menu

4.3, modify the Oracle Home and OCI Library path as shown below:

Oracle Home and OCI Library are set up according to their own decompression path.

5, after configuring the above four steps, re-open PL /SQL, the following login screen will appear, enter the user name and password, you should be able to log in normally.

6. If there is a condition that NLS_LANG is not configured (I will appear), you can configure it by entering the command in the cmd window:

set NLS_LANG=american_america.AL32UTF8