PL/SQL Developer how to connect a 64-bit Oracle plot

Original: PL/SQL Developer how to connect a 64-bit Oracle plot

Due to the continuous updating of hardware technology, Win7 system gradually become mainstream, and computer memory gradually increased, in order to make full use of memory resources (because 32 of the system can only use up to 3G of memory), improve system performance, many people began to use the Win7 (64Bit) system. A 64-bit Oracle database is installed on a 64-bit system, but there is no corresponding 64-bit PL/SQL Developer, and it is not possible to use PL/SQL Developer for direct connection, so the connection needs to be done in other ways. Here's how to implement a connection.

First, download the Oracle client

: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html, click Connect to enter the following page appears.

Select the first instant Client for Microsoft Windows (32-bit) to download it, please do not download 64bit, I tried, can not implement the connection.

Second, configure the Oracle client

After download, unzip it, do not need to install, such as extract to ... \tools_app directory, and then in the Instantclient_11_2 directory, create a new Layer two folder \NETWORK\ADMIN, Then build a tnsnames.ora file under the Admin folder and add the following to the file:

ORACLE = (  DESCRIPTION = (    ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))    (Connect_data =      (SERV ER = dedicated)      (service_name = ORACLE)    )  listener_oracle =  (ADDRESS = (PROTOCOL = TCP) (HOST = localhost ) (PORT = 1521)) Oraclr_connection_data =  (DESCRIPTION = (    address_list = (      ADDRESS = (PROTOCOL = IPC) (KEY = EXT PROC1521))    )    (Connect_data =      (SID = Clrextproc)      (PRESENTATION = RO)  ))

The above content can be copied in this place: E:\OracleDB\app\MuLing\ product\11.2.0\dbhome_1\network\admin\Tnsnames.ora 。

III. installation of PL/SQL Developer

Install the previously downloaded PL/SQL Developer (not downloaded on-line), but you need to emphasize that there are no brackets in the installation path and do not install under the C:\Program Files (x86) directory .

Four, the configuration of PL/SQL Developer:

After the installation is complete, run PL/SQL Developer, the login form that appears cannot log in, click the Calcel button, you will enter without login.

Configure the appropriate information to configure the previous decompression package information:

v. Restart PL/SQL developer for login.

Enter the appropriate information to connect to the login.

VI. Verify that you are really connected to Oracle

Write an SQL statement to verify that the query can see the following effect, indicating that the connection was successful.

PL/SQL Developer how to connect a 64-bit Oracle plot