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 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_at_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" <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: <A
href="
http://www.orafaq.com">
http://www.orafaq.com--Author: Ruth
Gramolini INET: rgramolini_at_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_at_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_at_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_at_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).
Received on Mon Sep 24 2001 - 13:42:32 CDT
