Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

database link between the databases with the same name

209473Jun 25 2010 — edited Jun 25 2010
Hi,
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.
This post has been answered by mseberg on Jun 25 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 23 2010
Added on Jun 25 2010
7 comments
2,039 views