From jcarlson@cj.com Mon, 24 Sep 2001 11:42:32 -0700 From: "John Carlson" Date: Mon, 24 Sep 2001 11:42:32 -0700 Subject: Re: database link questions Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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@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" Sent: Monday, September 24, 2001 2:55 PMCan you be more specific?  I am curious also.  When I create a link to adatabase on 'xxx' it comes out 'xxx.cj.com' which is correct but I beganlooking around and I don't see how it is working.  In our initxxx.ora filewe have 'db_domain = WORLD'.  In the sqlnet.ora file we have#NAMES.DEFAULT_DOMAIN = world# NAMES.DEFAULT_DOMAIN = cj.comAs you can see, both are commented out.  We are on Sun Solaris and I didfind /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 levelthing.  And, since it has always worked for me, I never really questionedit.  Now that Kathy has asked about it, I am sure there are many of us whoare curious about it.One more thing, I couldn't find any reference to it in the installationguide.TIA,John>>> rgramolini@tax.state.vt.us 09/24/01 06:30AM >>>The extension on a database link is always the domain of the database it iscreated in.HTH,Ruth----- Original Message -----To: "Multiple recipients of list ORACLE-L" 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@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@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@tax.state.vt.usFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso 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@tax.state.vt.usFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).