Home » RDBMS Server » Server Administration » db link issue (10.2.0.1)
db link issue [message #548077] Tue, 20 March 2012 04:32 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
show parameter db_domain


Regards
Michel
Re: dv link issue [message #548080 is a reply to message #548079] Tue, 20 March 2012 04:40 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks Michel,

SQL> show parameters db_domain;

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

Re: dv link issue [message #548082 is a reply to message #548080] Tue, 20 March 2012 04:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
sqlnet.ora -> names.default_domain

Regards
Michel
Re: dv link issue [message #548223 is a reply to message #548082] Tue, 20 March 2012 20:37 Go to previous messageGo to next message
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

Re: dv link issue [message #548224 is a reply to message #548223] Tue, 20 March 2012 20:41 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
select * from global_name;

post results from SQL above
Re: dv link issue [message #548225 is a reply to message #548224] Tue, 20 March 2012 20:47 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks,

select * from global_name;

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

SQL> 

Re: dv link issue [message #548637 is a reply to message #548225] Fri, 23 March 2012 12:22 Go to previous message
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.
Previous Topic: Create table
Next Topic: how to create db_link
Goto Forum:
  


Current Time: Thu Mar 28 12:28:38 CDT 2024