connecting to Oracle often requires the installation of hundreds of megabytes of Oracle clients, which can be cumbersome. This first describes how to connect to an Oracle database with Plsql by using a thin client that does not require installation. In fact, these operations are very simple, written here, it is a knowledge management bar, later forgot how to configure, open this blog.
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/technetwork/database/features/instant-client/index-097480.html, found in the middle of this page instant Client, select the appropriate version to download in the Instant client 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> Create a folder under this path network/admin, c:/instantclient/network/ The Admin folder establishes the Tnsnames.ora file, which is the TNS information for the database that you want to connect to. For example:
WORCL =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.4) (PORT = 1521))
)
(Connect_data =
(service_name = ORCL)
)
)
where the Red font section is my personal settings, the Oracle database server IP is 192.168.1.4, and the database service is named ORCL. If you do not know the service name, you can use the following command to view:Show Parameter Service_Name
Step Three: Set environment variables
New in User variables:variable name: Nls_langvariable value: Simplified Chinese_china. ZHS16GBKadd C:\instantclient to the system variable path
Fourth Step: 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.dllNow that the configuration is complete, PL/SQL developer can be used normally
Do not install Oracle client using Plsql