instantclient_12_1环境变量配置

1）配置系统环境变量

TNS_ADMIN=C:\instantclient_12_1\network\admin
PATH=%PATH%;C:\instantclient_12_1
ORACLE_HOME=C:\instantclient_12_1
LD_LIBRARY_PATH=C:\instantclient_12_1
SQLPATH=C:\instantclient_12_1 (可选)
NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK (可选)

2. 在D:\instantclient_10_2中用添加如下内容的文件,文件名为tnsnames.ora
3. 附ORA文件内容与格式
tnsnames.ora
#D:/instantclient_10_2/tnsname.ora（instantclient_12_1\network\admin）
mydb1 =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.0.47)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = dedicated)
      (SERVICE_NAME =ORCL)
    )
)