| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: database link questions
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" <ORACLE-L_at_fatcity.com>
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
>>> 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 is created 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:
>
>
>
>
>
>> To REMOVE yourself from this mailing list, send an E-Mail message
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: rgramolini_at_tax.state.vt.us 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: http://www.orafaq.com -- Author: Ruth Gramolini INET: rgramolini_at_tax.state.vt.us 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). 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).Received on Mon Sep 24 2001 - 13:39:47 CDT
 |
 |