Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Database links
Jeff,
Sorry for the earlier mail, I referred to the Oracle 8i doc.
Regards,
Prakash
--- "Newton, Jeff" <Jeff.Newton_at_joondalup.wa.gov.au>
wrote:
> 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
> The apps user in both instances have create session
> privs.
>
> From the apps/apps_at_fineval i called
> create database link testfin connect to apps
> identified by pwd using
> 'fintest' ;
>
> yet when i call the command
>
> select count(*) from fnd_user_at_testfin
>
> i get
>
> ORA-12154: TNS:could not resolve service name
>
> Could somebody please tell me what i've got wrong?
>
> Regards
>
> Jeff Newton
> Information Services
> City of Joondalup
>
>
>
> --
> Author: Newton, Jeff
> INET: Jeff.Newton_at_joondalup.wa.gov.au
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
![]() |
![]() |