Pl/SQL is configured to connect to the remote database oracle. The local oracle database is not installed.

First download instantclient. You can download it from the oracle official website. To register an account, you must download the corresponding version. Otherwise, it will fail. For 10G and 11G versions, I have already uploaded it. Free Download: uploading... please wait for the configuration file tnsnames. ora is usually stored in one place (networkADMIN), only in plsql ----- tools -- proferences

First download instantclient. You can download it from the oracle official website. To register an account, you must download the corresponding version. Otherwise, it will fail. For 10G and 11G versions, I have already uploaded it. Free Download: uploading... please wait for the configuration file tnsnames. ora is usually stored in one place (network/ADMIN), only in pl/SQL ----- tools -- proferences

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