database link between the databases with the same name
209473Jun 25 2010 — edited Jun 25 2010Hi,
I need to establish a db link between two databases that are named the same way on two different servers.
server 1 has a database dev1 and server2 has a database dev1. The tnsnames on server2:
DEV1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DEV1)
)
)
DEV1_server1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = dev1)
)
)
Can anyone let me know a way to create a database link between the two above?
Thanks.