OraFAQ Forum: Networking and Gateways » db links domain extension.

Home » RDBMS Server » Networking and Gateways » db links domain extension.

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

db links domain extension. [message #269079]

Thu, 20 September 2007 12:16

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

Report message to a moderator

Re: db links domain extension. [message #269081 is a reply to message #269079]

Thu, 20 September 2007 12:22

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Whats the value of DB_DOMAIN parameter...

Report message to a moderator

Re: db links domain extension. [message #269083 is a reply to message #269081]

Thu, 20 September 2007 12:23

vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad

Senior Member

Set to nothing
SQL> show parameter db_domain

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

Report message to a moderator

Re: db links domain extension. [message #269084 is a reply to message #269083]

Thu, 20 September 2007 12:25

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';

Report message to a moderator

Re: db links domain extension. [message #269085 is a reply to message #269084]

Thu, 20 September 2007 12:26

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>

Report message to a moderator

Re: db links domain extension. [message #269087 is a reply to message #269085]

Thu, 20 September 2007 12:28

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.

Report message to a moderator

Re: db links domain extension. [message #269088 is a reply to message #269079]

Thu, 20 September 2007 12:29

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

select * from global_name;

I bet will return a string containing "WORLD".

Report message to a moderator

Re: db links domain extension. [message #269094 is a reply to message #269088]

Thu, 20 September 2007 12:37

vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad

Senior Member

yes it does .. but how to avoid it .. ?

Report message to a moderator

Re: db links domain extension. [message #269097 is a reply to message #269079]

Thu, 20 September 2007 12:41

BlackSwan
Messages: 26766
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".

Report message to a moderator

Re: db links domain extension. [message #269102 is a reply to message #269097]

Thu, 20 September 2007 12:48

vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad

Senior Member

Change the string where?

Report message to a moderator

Re: db links domain extension. [message #269104 is a reply to message #269079]

Thu, 20 September 2007 12:52

BlackSwan
Messages: 26766
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.

Report message to a moderator

Previous Topic:	connecting to database under DSL
Next Topic:	Net configuration assistant

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 19:35:27 CST 2024