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
>>> [EMAIL PROTECTED] 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
>>> [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: Mario Alberto Ramos Arellano
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).
