RE: Database links

From: Philip West <P.West_at_g-icap.com>
Date: Tue, 11 Jul 2000 09:26:54 +0100
Message-Id: <10555.111635@fatcity.com>

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)

        )

    )
    (CONNECT_DATA = (SID = fintest)
    )
  )
fineval.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS = 


          (COMMUNITY = tcp.world)

          (PROTOCOL = TCP)

          (Host = cojsun01)

          (Port = 1521)

        )
        (ADDRESS = 


          (COMMUNITY = tcp.world)

          (PROTOCOL = TCP)

          (Host = cojsun01)

          (Port = 1526)

        )

    )
    (CONNECT_DATA = (SID = fineval)
    )
  )
The apps user in both instances have 'grant create database link to apps' set via user sys Received on Tue Jul 11 2000 - 03:26:54 CDT