Pl-sql Developer Configuration using Oracle client connections

Source: Internet
Author: User

Users who do not have Oracle installed locally must download a instantclient (even the client), and the path points to it for normal use

Download Instantclient-basic-nt-11.2.0.3.0.zip

Unzip to D:\Oracle\instantclient_11_2

First open the Plsql interface pop-up login box This time you very impulsive entered the correct user name password, as well as the IP address port number, But when you click OK, it pops up as shown in the first figure below. This means that you do not have an Oracle client installed on your computer or that the Plsql tool preferences are not configured correctly. So the direct point cancellation, Plsql will automatically open the software as shown in the second figure. You'll see the top left tip of the software is not logged in.

Oracle client does not have correct installation prompts

Click Cancel without logging into the software interface

Click →connection→ to fill in the following two things:

Oracle Home: Fill out the Client installation directory
OCI Library: Complete the client installation directory Oci.dll



Also add a Tnsnames.ora configuration
In the immediate client directory, create a new folder network, the network in the new admin, in the admin directory, a suffix named. ora file: Tnsnames.ora

\instantclient_11_2\network\admin\tnsnames.ora

Notepad opens and the content is added as follows:

# Tnsnames.ora Network Configuration File:d:\oracle\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.


ORCL =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521))
)
(Connect_data =
(service_name = ORCL)
)
)


Test-name =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.10) (PORT = 1521))
)
(Connect_data =
(service_name = ORCL)
)
)

One of the following test-name changes to the name you want to see in the Login display box, and the host changes to the IP of the database you want to connect to

Pl-sql Developer Configuration using Oracle client connections

Related Article

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.