Plsqldeveloper Configuration Guide for Oracle-free clients

Plsqldeveloper Configuration Guide for Oracle-free clients

The first step:

Download instantclient-basic-win32-10.2.0.5.zip to this machine from Oracle website, then unzip and create a new Oracle in the C packing Directory folder, copy all the extracted files to the C:\oracle directory, and then create a new network folder in the C:\oracle directory, followed by the network Folder to create the Admin folder, under the Admin folder to create the tnsnames.ora file, the content format is as follows

ORACLE =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))

(Connect_data =

(SERVER = dedicated)

(service_name = Oracle)

)

)

In the format above, fill in the Oracle configuration you want to connect to.

Part II

Download the plsqldeveloper software, then install, run the software,

Click Cancel, go to the main screen, click Tools, Preferences, appear as shown

Fill in the C:\oracle directory that you just created in Oracle home directory name

Fill in the OCI library C:\oracle\oci.dll

When you are done, rewrite the plsqldeveloper.

Plsqldeveloper Configuration Guide for Oracle-free clients