SQL> select name, value from v$parameter where name like '%domain%';
NAME
----------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
db_domain
I have nothing set in my init.ora. I do not have a sqlnet.ora.
If I look at my etc/resolv.conf, I have DOMAIN belkin.com.
I did a find / -name us.oracle.com -print and came up with nothing.
So still dazed and confused. Can't find this anywhere. Real head scratcher.
Kathy
-----Original Message-----
Sent: Monday, September 24, 2001 12:20 PM
To: Multiple recipients of list ORACLE-L
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).
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).
