Home » RDBMS Server » Networking and Gateways » db links domain extension.
db links domain extension. [message #269079] Thu, 20 September 2007 12:16 Go to next message
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
Senior Member

when i create a db link ..it by default appends a .world extension .. i checked my sqlnet.ora and it has nothing..also checked the global_name parameter in init.ora is set to true.

Can you please let me know how to avoid that. .

-Sai J
Re: db links domain extension. [message #269081 is a reply to message #269079] Thu, 20 September 2007 12:22 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Whats the value of DB_DOMAIN parameter...
Re: db links domain extension. [message #269083 is a reply to message #269081] Thu, 20 September 2007 12:23 Go to previous messageGo to next message
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
Senior Member

Set to nothing
SQL> show parameter db_domain

NAME TYPE VALUE
------------------------------------ ------- ------------------------------
db_domain string
Re: db links domain extension. [message #269084 is a reply to message #269083] Thu, 20 September 2007 12:25 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
What command do you use to create the db link?

	 
CREATE DATABASE LINK DEV01_MYDB
CONNECT TO  username
IDENTIFIED BY  password
USING 'MYDB.abc.xyz.com';
Re: db links domain extension. [message #269085 is a reply to message #269084] Thu, 20 September 2007 12:26 Go to previous messageGo to next message
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
Senior Member

yes ..

SQL> CREATE DATABASE LINK DEV01_MYDB
CONNECT TO username
IDENTIFIED BY password
USING 'MYDB.abc.xyz.com'; 2 3 4

Database link created.

SQL> select db_link from dba_db_links where db_link like 'DEV01_MYDB%';

DB_LINK
--------------------------------------------------------------------------------
DEV01_MYDB.WORLD

SQL>
Re: db links domain extension. [message #269087 is a reply to message #269085] Thu, 20 September 2007 12:28 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
I guess .WORLD is using on place for DB_DOMAIN.

Whats the value of SERVICE_NAME parameter.
Re: db links domain extension. [message #269088 is a reply to message #269079] Thu, 20 September 2007 12:29 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
select * from global_name;


I bet will return a string containing "WORLD".
Re: db links domain extension. [message #269094 is a reply to message #269088] Thu, 20 September 2007 12:37 Go to previous messageGo to next message
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
Senior Member

yes it does .. but how to avoid it .. ?
Re: db links domain extension. [message #269097 is a reply to message #269079] Thu, 20 September 2007 12:41 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>yes it does .. but how to avoid it .. ?
The only way I know is to change the string so it does NOT include the 5 characters "WORLD".
Re: db links domain extension. [message #269102 is a reply to message #269097] Thu, 20 September 2007 12:48 Go to previous messageGo to next message
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
Senior Member

Change the string where?
Re: db links domain extension. [message #269104 is a reply to message #269079] Thu, 20 September 2007 12:52 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>Change the string where?
The string you just SELECTed.

If you do change it all existing DBLINKs will break.

>the global_name parameter in init.ora is set to true.
Alternatively you could change above to be false.
Previous Topic: connecting to database under DSL
Next Topic: Net configuration assistant
Goto Forum:
  


Current Time: Sat Dec 10 18:21:56 CST 2016

Total time taken to generate the page: 0.11324 seconds