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

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.