OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » db link issue (10.2.0.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

db link issue [message #548077]

Tue, 20 March 2012 04:32

andy huang
Messages: 498
Registered: July 2011

Senior Member

Dear all,
I create a db link named mytest,but i find the name is mytest.com in oracle view,why?

create database link mytest connect to strmadmin identified by strmadmin using 'standby';

SQL> select db_link from user_db_links;

DB_LINK
-------------
MYTEST.COM

[EDITED by LF: fixed topic title typo; was "dv link"]

[Updated on: Tue, 20 March 2012 04:51] by Moderator

Report message to a moderator

Re: dv link issue [message #548079 is a reply to message #548077]

Tue, 20 March 2012 04:36

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

show parameter db_domain

Regards
Michel

Report message to a moderator

Re: dv link issue [message #548080 is a reply to message #548079]

Tue, 20 March 2012 04:40

andy huang
Messages: 498
Registered: July 2011

Senior Member

Thanks Michel,

SQL> show parameters db_domain;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_domain                            string

Report message to a moderator

Re: dv link issue [message #548082 is a reply to message #548080]

Tue, 20 March 2012 04:42

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

sqlnet.ora -> names.default_domain

Regards
Michel

Report message to a moderator

Re: dv link issue [message #548223 is a reply to message #548082]

Tue, 20 March 2012 20:37

andy huang
Messages: 498
Registered: July 2011

Senior Member

Thanks,
There is a sqlnet.ora in samples directory.

[oracle@hxl u01]$ find . -name "sqlnet.ora"
find: ./lost+found: Permission denied
./app/oracle/product/10.2.0/db_1/network/admin/samples/sqlnet.ora

Report message to a moderator

Re: dv link issue [message #548224 is a reply to message #548223]

Tue, 20 March 2012 20:41

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

select * from global_name;

post results from SQL above

Report message to a moderator

Re: dv link issue [message #548225 is a reply to message #548224]

Tue, 20 March 2012 20:47

andy huang
Messages: 498
Registered: July 2011

Senior Member

Thanks,

select * from global_name;

GLOBAL_NAME
-----------------
TEST.COM

SQL>

Report message to a moderator

Re: dv link issue [message #548637 is a reply to message #548225]

Fri, 23 March 2012 12:22

giteshtrivedi
Messages: 4
Registered: August 2005
Location: Ahmedabad

Junior Member

Did you try to disable global_name parameter using alter system? Try first and inform us what is the result.

Report message to a moderator

Previous Topic:	Create table
Next Topic:	how to create db_link

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 23 06:36:46 CST 2025