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