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@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@novalistech.com
http://www.novalistech.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Witold Iwaniec
INET: wiwaniec@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@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 Dec 10 2001 - 13:30:07 CST
