PL/SQL developer installation in win7 (64bit)

Win7 has gradually become the mainstream Windows operating system, and its 32-bit and 64-bit systems are equally different. However, no 64-bit PL/SQL developer is available yet. When 32-bit PL/SQL developer is directly used to connect win7 (64-bit) as the server's oracle, such errors always occur. You can find a method that can be used normally through online materials and self-testing.

 

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

Download 32-bit. This client is different from the standard Oracle client and does not need to be installed. Just unzip it to a certain path! For example, extract the package to the F: \ tools_app2 directory.

 

2. Configure the client

Install the two-tier network/Admin directory in the directory where the files are extracted in step 1, and create the tnsnames. ora file in Admin.
The connection string of the input dB in the file is as follows:
Sample =
(Description =
(Address_list =
(Address = (Protocol = TCP) (host = 192.168.1.120) (Port = 1521 ))
)
(CONNECT_DATA =
(SERVICE_NAME = dbname)
)
)
Configure the IP address and name of the database server. I believe that anyone who has used PL/SQL to connect to Oracle knows this connection file and will not detail it in detail.

 

3. Download and install PL/SQL developer

You can download the official or cracked PL/SQL, and install it directly.Note: The installation path cannot contain parentheses. Do not install it in the c: \ Program Files (x86) directory.

 

4. Configure PL/SQL

4.1 enable PL/SQL when no user logs on
4.2 open the preference menu item through the Tools menu

 

4.3 modify the path of Oracle Home and OCI library, for example:

 

Oracle Home and OCI library are set based on their own decompression path.

 

5. After the preceding four steps are configured, re-open PL/SQL and the following logon screen will appear. Enter the user name and password and you will be able to log on normally.