1、你连接别人不行,是因为你没有配置Net Configuration,所以在你的机器中的tnsnames.ora文件中没有到别人的连接,自然连接不上了。
2、你看看这个tnsnames.ora,每个连接都是有地址的,别人的SID与你相同,但地址不同(host,可以是主机名称,也可以是IP地址),连接就没有问题。
3、你不需要在.net中修改连接字符串,在这个文件中改就可以了。BXHAPL4 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = CNABB-ATPM-WSK)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = BXHAPL4.ABB.COM)
(SID = BXHAPL4)
)
)MASTER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = cnabb-atpm-wsk)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = master)
)
)INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = cnabb-atpm-wsk)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
2、你看看这个tnsnames.ora,每个连接都是有地址的,别人的SID与你相同,但地址不同(host,可以是主机名称,也可以是IP地址),连接就没有问题。
3、你不需要在.net中修改连接字符串,在这个文件中改就可以了。BXHAPL4 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = CNABB-ATPM-WSK)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = BXHAPL4.ABB.COM)
(SID = BXHAPL4)
)
)MASTER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = cnabb-atpm-wsk)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = master)
)
)INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = cnabb-atpm-wsk)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货