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)
)
)