Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: database link questions

Re: database link questions

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Mon, 24 Sep 2001 11:15:59 -0700
Message-ID: <F001.00396AC8.20010924112021@fatcity.com>

What is the domain of the database in which you are creating the link?

Ruth
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, September 24, 2001 2:55 PM

Can you be more specific? I am curious also. When I create a link to a database on 'xxx' it comes out 'xxx.cj.com' which is correct but I began looking around and I don't see how it is working. In our initxxx.ora file we have 'db_domain = WORLD'. In the sqlnet.ora file we have #NAMES.DEFAULT_DOMAIN = world
# NAMES.DEFAULT_DOMAIN = cj.com
As you can see, both are commented out. We are on Sun Solaris and I did find /etc/resolve.conf with:
domain cj.com.
search cj.com.

Is that where it is coming from or is there some other place to look.

Also, if I change the global name like:
alter database rename global_name to test; Then is comes out as 'TEST.CJ.COM'.

Since it is clearly ignoring my oracle parameters, it must be an OS level thing. And, since it has always worked for me, I never really questioned it. Now that Kathy has asked about it, I am sure there are many of us who are curious about it.

One more thing, I couldn't find any reference to it in the installation guide.

TIA,
John

>>> rgramolini_at_tax.state.vt.us 09/24/01 06:30AM >>>
The extension on a database link is always the domain of the database it is created in.

HTH,
Ruth
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, September 21, 2001 6:16 PM

> I try to create a database link named Custom, it ends up as:
>
> Custom.us.oracle.com when I query the dba_db_links table.
>
> I don't want the .us.oracle.com extension.
> What can I do, where does this extension come from? Global Names?
> I see that my global name is TEST.US.ORACLE.COM
> Do I need to alter global names so I don't get this extension?
> Is there something else I can do?
>
> Thanks,
>
> Kathy
>
> Confidential
> This e-mail and any files transmitted with it are the property
> of Belkin Components and/or its affiliates, are confidential,
> and are intended solely for the use of the individual or
> entity to whom this e-mail is addressed. If you are not one
> of the named recipients or otherwise have reason to believe
> that you have received this e-mail in error, please notify the
> sender and delete this message immediately from your computer.
> Any other use, retention, dissemination, forwarding, printing
> or copying of this e-mail is strictly prohibited.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kathy Duret
> INET: KathyD_at_belkin.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: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us

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: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us

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 Mon Sep 24 2001 - 13:15:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US