Re: Database link

From: Witold Iwaniec <wiwaniec_at_novalistech.com>
Date: Tue, 11 Dec 2001 04:56:48 -0800
Message-ID: <F001.003D9A15.20011211041518@fatcity.com>

db_domain in init.ora is commented out in both cases. I also set it to:
db_domain = ""

but it didn't make any difference.

Setting GLOBAL_NAMES to false helped but someone mentioned that it is not a good practice. Can anybody explain little bit why?

Thanks

Witold

On 10 Dec 2001 at 21:50, Nikunj Gupta wrote:

> Check for DB_DOMAIN.. in INIT.ORA
> else
> Set GLOBAL_NAMES to FALSE
> ALTER SYSTEM SET GLOBAL_NAMES=FALSE;
>
> HTH
>
>
> ------------------------------------
> Make a FREE long distance call from your PC!
> http://www.eboom.com/free/
> ----- Original Message -----
> From: Witold Iwaniec
> To: Multiple recipients of list ORACLE-L
> Sent: Monday, December 10, 2001 11:00 AM
> Subject: Database link
>
>
> Hi DBAs
>
>
> I have a problem with database links in one of the databases - the name of the
>link gets us.oracle.com appended to it.
>
>
> create database link test
> connect to test_user identified by test_pwd using 'test_db'
>
>
> When I execute:
>
>
> select * from my_table_at_test
>
>
> I get the ORA-02085 error message the the link test.us.oracle.com connects to test.
>
>
> When I execute:
> select * from global_name;
>
>
> in the target database the result is:
>
>
> TEST
>
>
> but in the database where I created the link the database name has the suffix:
>
>
> NOVALIS.US.ORACLE.COM
>
>
> I have no problem with database links in the TEST database but would like to know
>which parameter causes the suffix to be appended in the NOVALIS database.
>
>
> In both init.ora files the global_names is set to true and db_domain is commented
>out.
> In both databases the command
> show parameters;
>
>
> returns the db_domain as blank.
>
>
> Actually both databases are on the same server - Oracle 8.1.6.
>
>
> What should I change to remove the US.ORACLE.COM suffix. I don't care too much
>about the database, it's my test only, but don't want it appended in the links and
>maybe other objects...
>
>
> Thanks
>
>
> Witold
> ==================================
> Witold Iwaniec
> Sr Software Developer
> NovaLIS Technologies
> wiwaniec_at_novalistech.com
> http://www.novalistech.com
> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold
>Iwaniec INET: wiwaniec_at_novalistech.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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Witold Iwaniec
  INET: wiwaniec_at_novalistech.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 Tue Dec 11 2001 - 06:56:48 CST