Win7 gradually became the current mainstream Windows operating system, with its 32 and 64-bit systems evenly tied. However, there is no 64-bit pl/sql developer come out, directly with 32-bit Pl/sql developer Connection Win7 (64-bit) as Oracle of the server, there is always such a mistake, through online data and their own testing, Find a way to work properly.
1. Download Oracle Client (http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html)
Download the 32-bit on it. This client and Oracle's standard client has a certain difference, do not need to install, decompression to a certain path under it! such as extract into the F:\TOOLS_APP2 directory.
2, configure the client
Install the folder network/admin two-level directory in the directory where you unzipped the files in step 1, and create Tnsnames.ora files in admin
Enter the connection string for db in the file as:
SAMPLE =
(DESCRIPTION =
(Address_list =
(address = (PROTOCOL = TCP) (HOST = 192.168.1.120) (PORT = 1521))
)
(Connect_data =
(service_name = dbname)
)
)
The primary configuration is the IP address and DB name of the DB server. It is believed that a friend who has used Pl/sql to connect to Oracle knows the connection file and is no longer in detail.
3. Download and install Pl/sql Developer
Download the official version or crack version of the pl/sql can be directly installed on it. Note: The installation path must not have parentheses, do not install under the C:\Program Files (x86) directory
4. Configure Pl/sql
4.1, no user login state to open Pl/sql
4.2, through the Tools menu, open preference items