修改<oraclehome>\network\ADMIN\tnsnames.ora
下面是例子:
high =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dragon)(PORT = 1521))
)
(CONNECT_DATA = (SERVICE_NAME = high))
)
其中high是将要建立的service name, HOST 需要等于主机名
SERVICE_NAME需要等于数据库名重新启动tnslisener的服务。
下面是例子:
high =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dragon)(PORT = 1521))
)
(CONNECT_DATA = (SERVICE_NAME = high))
)
其中high是将要建立的service name, HOST 需要等于主机名
SERVICE_NAME需要等于数据库名重新启动tnslisener的服务。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货