RE: Database links

Thanks for everybodies input,
Anita hit the nail on the head with her suggestion of putting the tnsnames.ora file
on the server, i did this, and all now works, from the apps user in fineval, i called

create database link fintest connect to apps identified by pwd using 'fintest.world' ;

Thanks again .......

Jeff Newton
Information Services
City of Joondalup

> -----Original Message-----
> From: A. Bardeen [SMTP:abardeen1_at_yahoo.com]
> Sent: Tuesday, July 11, 2000 8:03 PM
> To: ORACLE-L_at_fatcity.com; Jeff.Newton_at_joondalup.wa.gov.au;
> pkj_01_at_yahoo.com
> Subject: Re: Database links
>
> Jeff & Prakash,
>
> The issue isn't global_names. You've created the
> entry in the tnsnames.ora on the client, but the
> connection to the remote db is made from the local db,
> not your client.
>
> You need to update the tnsnames.ora on the server with
> this connect string information.
>
> HTH,
>
> -- Anita
>
> --- PK J <pkj_01_at_yahoo.com> wrote:
> > Jeff,
> >
> > Documentation says default values for GLOBAL_NAMES
> > is
> > TRUE, please check that and try once more.
> >
> > HTH,
> >
> > 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
> > >
> >
> --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an
> > > E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > > 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB
> > > ORACLE-L
> > > (or the name of mailing list you want to be
> > removed
> > > from). You may
> > > also send the HELP command for other information
> > > (like subscribing).
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Get Yahoo! Mail - Free email you can access from
> > anywhere!
> > http://mail.yahoo.com/
> > --
> > Author: PK J
> > INET: pkj_01_at_yahoo.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX:
> > (858) 538-5051
> > San Diego, California -- Public Internet
> > access / Mailing Lists
> >
> --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from). You may
> > also send the HELP command for other information
> > (like subscribing).
Received on Wed Jul 12 2000 - 19:04:05 CDT