How to create a db link without the . world attached to it?

Hi experts.
How to create a db link without the . world attached to it?

Oracle Enterprise Edition version 10.2.0.3

SQL> sho parameter global

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------
global_context_pool_size             string
global_names                         boolean     FALSE
SQL>

tstdb:/home/app/oracle/product/10.2.0/network/admin> cat sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES)
SQLNET.INBOUND_CONNECT_TIMEOUT = 0
LVL 8
LindaCAsked:
Who is Participating?
 
johnsoneConnect With a Mentor Senior Oracle DBACommented:
Yes, the domain is automatically appended.  If you unset the db_domain parameter, you should get what you are looking for.

Be aware that if the link is created with the .world, then when accessing the link, you don't need to add that.  The domain will automatically be added as part of the lookup.

So, if you have a database link with the name TSTCTI.WORLD, you can access that as <table_name>@TSTCTI or <table_name>@TSTCTI.WORLD.  Either way should work just fine.
0
 
slightwv (䄆 Netminder) Commented:
You should just  be able to create the link with the same name as the alias specified in the tnsnames.ora file.  Create an alias in the tnsnames.ora file without .world.

You also need to check the global_name on the database:
select * from global_name;

You might need to change the global name of the database:
http://docs.oracle.com/cd/E11882_01/server.112/e25494/ds_admin001.htm#ADMIN12147

Worst case, set the default domain in the sqlnet.ora file:
http://docs.oracle.com/cd/E11882_01/network.112/e10835/sqlnet.htm#CIHJDJHD
0
 
LindaCAuthor Commented:
SQL> select * from global_name;

GLOBAL_NAME
------------------------------------------
STARTST.WORLD

So this parameters needs to be changes in the init.ora of the database and then recycle the database?

db_name                          =  STARTST
db_domain                        =  WORLD
service_names                    =  STARTST.WORLD
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
slightwv (䄆 Netminder) Commented:
>>So this parameters needs to be changes in the init.ora of the database and then recycle the database?

I would change these paramters but the dblink only follows what is in the tnsnames.ora file not what is in the database.
0
 
LindaCAuthor Commented:
But, strange, this is what I have in the tnsnames.ora:

This is the name of the remote database that it is being used in the creation of the db-link:

This will be created TEST.WORLD:

CREATE PUBLIC DATABASE LINK "TEST"
 CONNECT TO CTIUAPP32
 IDENTIFIED BY CTIUAPP32
 USING 'TSTCTI';


TSTCTI=
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.13.31.22)(PORT = 1531))
    )
    (CONNECT_DATA =
      (SID = TSTCTI11)
    )
  )
0
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
I've not done a lot with database domains.  I guess maybe the db_domain is automatically appended to the link name.

Try unsetting db_domain and check the link.
0
 
LindaCAuthor Commented:
Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.