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