About the settings for toad/plsql using instantclient

To download Oracle Instant client to Oracle website, pay attention to select x86 platform, Toad only 32-bit Oracle Instant client. As for the version number, there is no special requirement and the version is backwards compatible.

On the desktop, right-click on "My Computer", select "Properties", select "Environment variables" in the "Advanced" page, and in the system variables, modify the following

Variable name: oracle_home
Variable Value: D:\Program files\instantclient_11_2
Variable name: tns_admin
Variable Value: D:\Program files\instantclient_11_2
Variable name: Nls_lang
Variable value: Simplified Chinese_china. Zhs16gbk
Modify the path variable and add the D:\Program files\instantclient_11_2 later

Create a new text file in D:\Program files\instantclient_11_2 with the file name Tnsnames.ora and Sqlnet.ora

#orcl可以自定义替换
#HOST修改为Oracle server Address
#SERVICE_NAME修改为Oracle实例名
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.30.85) (PORT = 1521))
(Connect_data =
(SERVER = dedicated)
(service_name = ORCL)
)
)

# This file was actually generated by NETCA. But if customers choose to
# install ' Software only ', this file wont exist and without the native
# Authentication, they'll is not being able to connect to the database on NT.

Sqlnet. Authentication_services = (All)
#NAMES. Directory_path= (Ezconnect)
NAMES. Directory_path= (TNSNames)

About the settings for toad/plsql using instantclient