Installing and Configuring PL/SQL Developer from scratch

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)
3. 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