1.在系统环境变量中配置TNS_ADMIN指向tnsnames.ora文件所在的目录;
2.在系统环境变量path中加入instantclient-win32的路径;
tnsnames.ora内容格式:
orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IP )(PORT = 7521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl )
)
)