I think you are required to have a domain for each link. The domain is
determined at database creation time. The way to check it is:
select * from global_name;
If you want to change it simply use this:
alter database rename global_name to test.mydomain;
Now, if you want to change the name simply type this:
alter database rename global_name to newtest;
This assumes the same domain so the new name is newtest.mydomain. I
couldn't figure out a way to totally get rid of the domain altogether.
Anybody know how?
--Michael
-----Original Message-----
Sent: Monday, September 24, 2001 4:03 PM
To: Multiple recipients of list ORACLE-L
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jenkins, Michael
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).
