Skip to Main Content
  • Questions

  • WHy Some Database Envirenment I must user .world??

Breadcrumb

Question and Answer

Tom Kyte

Thanks for the question, Somrut.

Asked: May 11, 2003 - 10:29 pm UTC

Last updated: April 28, 2012 - 8:08 am UTC

Version: 8.1.7

Viewed 10K+ times! This question is

You Asked

I have some confuse about Database TNS.
Cause Some Database I must use .world after connection name to connect to database. If I not enter .world it error "can't resolve service name"

and Tom said...

look in the sqlnet.ora on the client.

in the tnsnames.ora (another client file) they must have xxx.world. In the sqlnet.ora, they must NOT have a default domain setup.


for example, in my sqlnet.ora i have:


NAMES.DEFAULT_DOMAIN = us.oracle.com


In my tnsnames.ora I have entries like:

ORA920.US.ORACLE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = tkyte-pc)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ora920)
)
)


Now, since my default domain is us.oracle.com, I can either

sqlplus scott/tiger@ora920

OR

sqlplus scott/tiger@ora920.us.oracle.com


the .us.oracle.com is supplied for me if I do not use it.

Rating

  (7 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Good !

A reader, May 12, 2003 - 10:57 am UTC

This has been bugging since I began working with Oracle. Thanks for the answer.

A reader, May 12, 2003 - 12:19 pm UTC


My SQLnet.ora Only contain .. this

Somrut, May 28, 2003 - 11:57 am UTC

SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

Can I have two NAMES.DEFAULT_DOMAIN?

Ravi, July 28, 2009 - 5:03 pm UTC

Tom,
In your example you have NAMES.DEFAULT_DOMAIN = us.oracle.com. Is it possible to have something like this?
NAMES.DEFAULT_DOMAINS = (us.oracle.com, canada.oracle.com)
If not, is there any other workaround?

Thanks.
Tom Kyte
July 28, 2009 - 9:03 pm UTC

how can you have two default domains?

the default is used when you don't supply one. So, I give you a domain 'foobar'

is that foobar.us.oracle.com or foobar.ca.oracle.com?


http://docs.oracle.com/docs/cd/B19306_01/network.102/b14213/sqlnet.htm#sthref401




Thanks

Ravi, July 28, 2009 - 10:48 pm UTC

Thanks for your feedback on this. I was thinking in terms of NAMES.DIRECTORY_PATH= (TNSNAMES, LDAP)where it resolves the service name in the order specified. Apparently this is not applicable for NAMES.DEFAULT_DOMAIN. And thanks for the link.

Did not understand

Gonza, July 29, 2009 - 11:40 am UTC

I didn't understand why is .world needed.
In my work I must put .world otherwise It doesn`t work

Thanks
Tom Kyte
August 03, 2009 - 4:52 pm UTC

because the domain must be set to world...

and your default is something other than world...

connecting to different domains

kishore, April 27, 2012 - 12:20 pm UTC

Hi Tom,

We have default_domain specified to us.oracle.com in sqlnet.ora file. Most of the databases(10) we are connecting to have the same domain, however I have one database that has different domain ds.oracle.com. Since it resolves the domain from sqlnet.ora file, I couldn't be able to get it work. If I comment the default_domain from sqlnet.ora file it works. But since I have other databases that resolves this default_domain, I couldn't comment that.

Could you please help me here.

Thanks for all your help.
Tom Kyte
April 28, 2012 - 8:08 am UTC

*what* doesn't work?
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.