• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2861
  • Last Modified:

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
0
LindaC
Asked:
LindaC
  • 3
  • 3
2 Solutions
 
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
 
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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) 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
 
johnsoneSenior 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
 
LindaCAuthor Commented:
Thank you.
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now