Normally, connecting Oracle with PL/SQL developer requires the installation of Oracle client software, which means that your hard drive will take up about 1g-2g of space, and you will have some more boot-enabled services for the Windows operating system. Of course, for most people, you don't apply the database you create on your own machine, but just want to connect to the database on the server through some of his configuration.
In fact, Oracle provides us with the Lightweight tool Oracle Instantclient package, also known as "Oracle Instant Client". With this tool, we can access databases that exist on other computers without the Oracle client software installed.
Download the installation package First
Download the Oracle Instantclient Basic package on the ORALCE official website. The address is as follows: Http://www.oracle.com/technology htdocs/winsoft.html, find instant client in the middle of this page, in Instant client Select the appropriate version to download in the downloads.
Step Two: Unzip the installation package
1> after the download is complete, unzip the compressed file to a local path, such as C:\instantclient.
2> in this path to create a folder Network/admin, under the ADMIN folder to create Tnsnames.ora files, the file content is the database you want to connect TNS information. For example:
WORCL =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.4) (PORT = 1521))
)
(Connect_data =
(service_name = ORCL)
)
)
Step Three: Configure PL/SQL developer
Start PL/SQL Developer, in the Login window interface, click the Cancel button to proceed to the main interface, click Tools->preferences, in connection need to configure the following two parameters:
Oracle home:c:\instantclient
OCI Library:c:\instantclient\oci.dll
Rr.png
Now that the configuration is complete, PL/SQL developer can be used normally
You can also use PL/SQL developer without installing an Oracle client