Connect to the Oracle database with Plsql by using a thin client that does not require installation

Connect to the Oracle database with Plsql by using a thin client that does not require an installed client.

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
Find the instant client in the middle of this page and select the appropriate version to download in 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> the folder Network/admin under this path, the Tnsnames.ora file is created under the C:/instantclient/network/admin folder, and the file content 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)
)
)

In fact, you can also directly copy the server's network files to the Instantclient folder
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_lang
Variable value: Simplified Chinese_china. Zhs16gbk
Add 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 can be the main interface, click Tools->preferences, in connection need to configure the following two parameters, select the path
Oracle home:c:\instantclient
OCI Library:c:\instantclient\oci.dll

Connect to the Oracle database with Plsql by using a thin client that does not require installation