Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: database link questions
This is what I eventually did and this fixed my database link problem.
I could have done it like another list member suggested to use the whole edi.belkin.com in the database link name, but then I would have had to remember to do this for any future database links, so the one time alter of the global names fixed the problem.
I did open a tar with Metalink and they don't seem to know the answer to why I would
see us.oracle.com in the global name when service_name, db_domain, etc are all set in
the init.ora.
The us.oracle.com I assume was probably typed in the domain area during installation.
Where it is stored for the global name to use, no one seems to know.
Now onto more fun... ODBC driver connection problem with Interdev, 8.1.7 Oracle to an IIS server. Will the fun never end?
Kathy
-----Original Message-----
Sent: Tuesday, September 25, 2001 6:30 PM
To: Multiple recipients of list ORACLE-L
Try updating directly to the global_name table:
update global_name
set global_name='MY_DB_NAME';
commit;
Mario Alberto Ramos
>>> jcarlson_at_cj.com 24/09/01 13:55 >>>
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: Mario Alberto Ramos Arellano INET: alramos_at_capufe.gob.mx 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 Wed Sep 26 2001 - 11:14:05 CDT
![]() |
![]() |