Re: database link questions

[John Carlson]

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 >>> [EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> 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 >>> [EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).