Oracle远程连接简析
首先到Oracle官网下载需要的配置
https://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
www.2cto.com
配置服务器tnsnames.ora文件，如果本机上没有安装oracle，可以从安装了oracle的机上拷贝一个(tnsnames.ora文件)放在指定目录下。
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
oracle账号 )
)
添加一个环境变量，名为TNS_ADMIN，值为tnsnames.ora文件所在路径（如：D:\oraclient）就可以了。
www.2cto.com
如果不能连接可能以下原因:
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))
)
)