RE: database link questions

If you specify the domain name when you create the link it will use that. Otherwise it just picks what your domain is if you have global names set to false. I always create mine with the .world extension. Why? Why not?
I only deal internally so its no big deal. However, if I forget to put the .world it will always put .gmd.fujtisu.com.

-----Original Message-----
Sent: Monday, September 24, 2001 1:54 PM To: Multiple recipients of list ORACLE-L

When I create a db_link it always takes the name of the domain for that database. I don't know what's going on either. Sorry!

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

As I stated, the initxxx.ora contains 'db_domain = WORLD'. In fact, all our databases init.ora files contain the same 'db_domain = WORLD' and yet all links and global names come out with 'cj.com' on 8 different physical boxes. Is there someplace else you are asking about? I don't know where else to look.

John

>>> rgramolini_at_tax.state.vt.us 09/24/01 12:20PM >>>
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).


-- 
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: Kimberly Smith
  INET: kimberly.smith_at_gmd.fujitsu.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).