oracle客户端连接tnsnames.ora

示例：

oracelTest = (   
  DESCRIPTION = (
      ADDRESS_LIST = (
        ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521)
      )
    )
  (CONNECT_DATA = (SERVICE_NAME = xe) (SERVER = DEDICATED))
)

详细：

## ADDRESS_LIST 部分包含了远程数据库服务器的监听地址信息,也就是要告诉TNS远程数据库可通过哪些地址和CLIENT通讯
## CONNECT_DATA 定义了CLIENT要连接的数据库,还有数据库的连接方式,(专用或共享)

XXX =  ## 名字随便起，客户端是通过这个名字来获得服务器的登录信息的
	(DESCRIPTION =
		(ADDRESS_LIST =
## PROTOCOL是指定的通信协议，oracle是通过TCP/IP通信的。所以这里写TCP就好
## HOST的话如果客户端和数据库在同一台电脑可以用localhost也可以用IP。如果不同电脑就必须用oracle服务器所在电脑的IP
			(ADDRESS = (PROTOCOL = TCP)(HOST = localhost?ip)(PORT = XXX))
	)
	(CONNECT_DATA =
		(SERVICE_NAME = mayp)    ## 此处为数据库服务器的SID，和那个SID重名匹配那个
		(SERVER = DEDICATED)    ## 连接方式：专用或共享
	)
)     

## 在一个多IP环境中，TNS也可以配置多个远程IP地址:CGDB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.55)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.56)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = CGDB) (SERVER = DEDICATED) ) )

其他

适用于 Microsoft Windows (x64) 64 位的 Oracle Instant Client 下载
https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html