Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: database link questions
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 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>
--------------------------------------------------------------------> ToREMOVE 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
Lists--------------------------------------------------------------------ToREMOVE 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 - 12:47:18 CDT
![]() |
![]() |