1. Unzip the Instantclient_12_1-x32.rar file and extract it below Instantclient_12_1-x32\network\admin\tnsnames.ora, Find Tnsnames.ora This file, configure the details in this file
If the client is not installed locally, you can configure it as follows
Eisp =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.111.86) (PORT = 1521))
)
(Connect_data =
(service_name = JNCCRM)
)
)
It can be changed according to different needs.
2. Configure Environment variables
New environment variable Nls_lang simplified Chinese_china. Zhs16gbk
Oracle_home
Tns_admin E:\instantclient_12_1-x32\network\admin
3. Enter plsql--Tool--preferences--Connect--oracle home directory name (automatically detect null), import path E:\instantclient_12_1-x32
OCI Library (Automatic detection is empty), import path E:\instantclient_12_1-x32\oci.dll
The configuration is successful and the Plsql can be remotely connected to the database by rebooting
Oracle--plsql detailed steps to remotely connect to a database