db link issue [message #548077] |
Tue, 20 March 2012 04:32 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #548080 is a reply to message #548079] |
Tue, 20 March 2012 04:40 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #548223 is a reply to message #548082] |
Tue, 20 March 2012 20:37 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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
|
|
|
|
|
|