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).