When pl/SQL is configured to connect to the remote database oracle, the local oracle database is not installed

First, you can download the instantclient from the oracle official website. To register an account, you must download the corresponding version. Otherwise, it will fail,

I have uploaded the 10G and 11G versions. It is free to download: Uploading. Please wait.

Configuration File tnsnames. ora is usually put in this place (network/ADMIN), only in pl/SQL -----> tools --> proferences... ------> connection ----> oracle home (empty is autodetect) Write tnsnames. ora path (change the relevant path to your own)

ORCL2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 172.16.100.183) (PORT = 1521 ))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)

Export lr_connection_data =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521 ))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

Set the environment variable (change the directory to your own)

TNS_ADMIN = D: \ soft \ oarcleclient \ instantclient_11_2
NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK
Path = D: \ soft \ oarcleclient \ instantclient_11_2