Installing and Configuring PL/SQL Developer from scratch

Source: Internet
Author: User

Original address: http://lightguide.blog.51cto.com/3121539/1140588

Because of their own installation and configuration to go a lot of detours, search online documents Most of them do not contain ORALCE client installation and the corresponding configuration, so write it alone once.

This example applies to the Oralce client without the need to install the Instantclient basic package instead.

-Required Packages:

-pl/sql Developer

You can go to Google by yourself.

-instantclient-basic-nt-11.2.0.3.0

--(You need to log in with an Oracle account, you can register yourself):

    1. Http://www.oracle.com/technetwork/topics/winsoft-085727.html

--:

Need to click "Accept License Agreement" in front of the radio box before you can download.

--Because the Instantclient basic package is directly decompression can, so the order in the front after all does not matter, the PL/SQL Developer installation, because is the classic next step, also no longer explained.

-one point to mention is that some files mention PL/SQL Developer installation path can not have spaces, but I installed the version is 9.0.6.1665, directly installed in the D-Drive Program Files folder, no problem.

--Install after open, a start because did not set, so also can not login, click Cancel go in, then Point Tools-preferences, in the inside set instantclient Basic Package decompression path.

-In my case, set the following two items:

    1. Oracle Home (Empty is AutoDetect)
    2. D:\instantclient_11_2
    3. OCI Library (Empty is AutoDetect)
    4. D:\instantclient_11_2\oci.dll

Setup is complete, click OK.

--Configuration file:

Create a new two file under the Instantclient Basic Package directory, which reads as follows:

Sqlnet.ora (Note the position of the blackbody part TNSNames):

    1. Sqlnet. Authentication_services= (NTS)
    2. NAMES. Directory_path= (tnsnames, Ezconnect)

TNSNames. ORA (This is one of the tags that can be set up in multiple such that the black italic part is needed to change):

    1. PODS =
    2. (description=
    3. (address_list=
    4. (address=
    5. (PROTOCOL=TCP)
    6. (host=192.168.0.113)
    7. (port=1521)
    8. )
    9. )
    10. (Connect_data=
    11. (sid=PODS)
    12. )
    13. )

--Set environment variables:

To add an environment variable:

    1. Tns_admin = D:\instantclient_11_2

Now open PL/SQL developer to log in.

Complete.

This article is from the "Light" blog, make sure to keep this source http://lightguide.blog.51cto.com/3121539/1140588

Installing and Configuring PL/SQL Developer from scratch

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.