一.本地安装了Oracle数据库
进入Oracle安装目录,如
二.本地未安装Oracle数据库
1.去Oracle官网下载instant client-basic包,http://www.oracle.com/technetwork/topics/winsoft-085727.html;然后解压到磁盘"D:\instantclient_12_2"
2
3.打开编辑tnsnames.ora文件
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.3)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
HOST修改为你需要连接的ip地址,注意SERVICE_NAME的值为远程数据库的名称。
4.配置环境变量
新建环境变量
变量名:TNS_ADMIN
变量值:tnsnames.ora文件的安装目录,如“D:\instantclient_12_2\network\admin”
新建环境变量
变量名:NLS_LANG
变量值:SIMPLIFIED CHINESE_CHINA.ZHS16GBK