RE: Problem with database link

From: Kirsh, Gary <gary.kirsh_at_gs.com>
Date: Thu, 12 Apr 2001 08:55:31 -0700
Message-ID: <F001.002E83A0.20010412084027@fatcity.com>

I've found that it is the global_name, not the db_domain, which gets appended to the dblink. You can check the global_name by select * from global_name
I've had problems with dblinks if the global_name is not the same as the db_domain. In that case, describing over a dblink fails. HTH,
Gary

Gary Kirsh
Next Extent, Inc

-----Original Message-----
Sent: Thursday, April 12, 2001 12:01 PM
To: Multiple recipients of list ORACLE-L

You could try setting GLOBAL_NAMES to FALSE in your init.ora file. By default, it's set to TRUE. Once I set mine to FALSE, I was able to create public database links easily.

• Dana
  • Michal Zaschke <zaschke_at_suas.cz> wrote:
    > AFAIK, parameter DB_DOMAIN is what appends to the database link name
    > (which must be DB_NAME of your remote database).
    >
    > SQLWKS> show parameter db_domain
    > NAME TYPE VALUE
    > ------------------------------ ------- ------------------------------
    > db_domain string WORLD
    >
    >
    >
    > Helmut Daiminger wrote:
    > >
    > > Hi there!
    > >
    > > I'm having a problem with database links here.
    > >
    > > I am on my SPEEDY database and want to create a link that points to
    > another
    > > database called SAM.
    > >
    > > create database link SAM connect to user identified by pasword
    > using 'SAM';
    > >
    > > Then I try and issue that statement:
    > >
    > > select view_name from user_views_at_SAM
    > > *
    > > ERROR at line 2:
    > > ORA-02085: database link SAM.VIVONET.COM connects to SAM
    > >
    > > Where does our domain name appendix (vivonet.com) come from???? I
    > looked in
    > > all the possible config files (e.g. sqlnet.ora etc.) and couldn't
    > find
    > > anything. In both databases the init.ora parameter is set to
    > global_names =
    > > true.
    > >
    > > Any idea?
    > >
    > > This is 8.1.6 on Win2k.
    > >
    > > Thanks,
    > > Helmut
    > >
    > > --
    > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
    > > --
    > > Author: Helmut Daiminger
    > > INET: hdaiminger_at_vivonet.com
    

    ---

Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: dana
  INET: danamn2000_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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kirsh, Gary
  INET: gary.kirsh_at_gs.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 Thu Apr 12 2001 - 10:55:31 CDT