关于Oracle客户端连接远程服务器的书写方法
任意名字 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IP地址或者主机名)(PORT = 端口号))
)
(CONNECT_DATA =
(SERVICE_NAME = 服务名)
)
)
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IP地址或者主机名)(PORT = 端口号))
)
(CONNECT_DATA =
(SERVICE_NAME = 服务名)
)
)
配置目录
Windows例:
C:/oracle/product/10.2.0/client_1/network/admin/tnsnames.ora
Linux例:
$ORACLE_HOME/network/admin
記述例:
tnsnames.ora
- MyOracle1 =
- (DESCRIPTION =
- (ADDRESS_LIST =
- (ADDRESS = (PROTOCOL = TCP)(HOST = 192.133.0.131)(PORT = 1521))
- )
- (CONNECT_DATA =
- (SERVICE_NAME = myservice1)
- )
- )
- MyOracle2 =
- (DESCRIPTION =
- (ADDRESS_LIST =
- (ADDRESS = (PROTOCOL = TCP)(HOST = 192.133.0.121)(PORT = 1521))
- )
- (CONNECT_DATA =
- (SERVICE_NAME = myservice2)
- )
- )