Plsql developer installing, configuring, connecting to an Oracle database

0. Resource Preparation

1) Plsql Developer installation package (cannot be uploaded because the installation package is more than 10M, please download it yourself)

2) Instantclient_11_2 installation package (cannot be uploaded due to installation package exceeding 10M, please download it yourself)

1. Install Plsql Developer

My version is Plsql Developer10.0.3.1701, the installation path is D:\Program files\plsql Developer

2, Configuration Instantclient_11_2

1) instantclient_11_2 decompression and put into the D:\Program files\plsql Developer directory (can be placed at will, do not need to be placed in the Plsql Developer installation directory)

2) At this time the Instantclient_11_2 directory is: D:\Program files\plsql developer\instantclient_11_2

3) Edit the Tnsnames.ora file under the D:\Program files\plsql developer\instantclient_11_2 directory (if not, create it yourself) as follows

　　

3, Configuration Plsql Developer

1) Open Plsql Developer, first do not connect to the DB instance, select Cancel

2) Enter Plsql developer view, select Tools->perferences, configure Oracle Home and OCI Library

Absolute path to the Oracle home instantclient_11_2 directory, the absolute path of oci.dll files in the OCI library fill instantclient_11_2

In my installation environment

Oracle Home:d:\program Files\plsql developer\instantclient_11_2

OCI Library:d:\program Files\plsql Developer\instantclient_11_2\oci.dll

3) Restart Plsql Developer,

4. Successful Login

　　

"Note" Issues that may occur

1) Open Plsql Developer, no connect as option

Reason:

• No instantclient_11_2 installed
• Oracle Home and OCI Library with no Plsql develope->tools->perferences configured

　　

2) Open Plsql developer,database no options

Reason

• Tnsnames.ora File Not Configured

　　

Plsql developer installing, configuring, connecting to an Oracle database