Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Database links
try
create database link testfin.world connect.......
Regards
Phil West - Impex IT ltd
Unix Sys Admin and Oracle Financials DBA Services
[ all opinions - unless otherwise stated - may be ill-informed and will be defended as such! ]
-----Original Message-----
From: Newton, Jeff [mailto:Jeff.Newton_at_joondalup.wa.gov.au]
Sent: 11 July 2000 10:09
To: Multiple recipients of list ORACLE-L
Subject: Database links
Sun E2500
Solaris 2.6
Oracle 7.3.4
Oracle Financials 10.7
SqlNet v2
Help .........
I have been asked to setup a database link between 2 of our Financials
instances.
I have read the Oracle7 Server Admin Guide: Managing Database links, but
still can't get it to work.
Global_Name in both instances is not set, hence defaults to false.
our tnsnames.ora file on the client for the 2 instances look like this:
fintest.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = cojsun01)
(Port = 1521)
) (ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = cojsun01)
(Port = 1526)
)
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = cojsun01)
(Port = 1521)
) (ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = cojsun01)
(Port = 1526)
)
![]() |
![]() |