我现在是在内网,有3台机器,ip分别是192.168.0.1,192.168.0.2,192.168.0.3
我是用.1的机器,只装了客户端~~~
在.2和.3上都装oracle10g,sid都是orc1
请问,我现在想创建dblink到这两台机要怎么办??
现在只能连接到.3的机器,在tnsnames.ora删掉了.3的参数也不行
请高手教路
我是用.1的机器,只装了客户端~~~
在.2和.3上都装oracle10g,sid都是orc1
请问,我现在想创建dblink到这两台机要怎么办??
现在只能连接到.3的机器,在tnsnames.ora删掉了.3的参数也不行
请高手教路
orc2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orc1)
)
)orc3 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.3)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orc1)
)
)连接时orc2名连192.168.0.2上的oracle10g,orc3名连192.168.0.3上的oracle10g
orc2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521))
)
(CONNECT_DATA =
(SID = orc1)
(SERVER = ???)
)
) orc3 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.3)(PORT = 1521))
)
(CONNECT_DATA =
(SID = orc1)
(SERVER = ###)
)
)
根据不同的ip地址去不同的服务器名字
然后正常create public database link
ora2
ora3
接着用
CREATE [PUBLIC] DATABASE LINK <link_name>
CONNECT TO <user_name>
IDENTIFIED BY <password>
USING '<service_name>';
就可以了service_name可以ora2、ora3
我这边只能用sid,是不是ALTER SYSTEM SET GLOBAL_NAMEs=才可以,而且我的服务器不能重启