首先到Oracle官网下载需要的配置
http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
配置服务器tnsnames.ora文件,如果本机上没有安装oracle,可以从安装了oracle的机上拷贝一个(tnsnames.ora文件)放在指定目录下。
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
添加一个环境变量,名为TNS_ADMIN,值为tnsnames.ora文件所在路径(如:D:\oraclient)就可以了。如果发现数据库数据乱码了,再添加
NLS_LANG:SIMPLIFIED CHINESE_CHINA.ZHS16GBK环境变量就可以了
如果不能连接可能以下原因:
1、windows防火墙(关闭防火墙或者提供一个可以访问的端口号)
2、服务器未配置监听(修改listener.ora)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.101)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)