asked on

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

slightwv (䄆 Netminder)

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

LindaC

ASKER

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

slightwv (䄆 Netminder)

>>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.

LindaC

ASKER

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)
)
)

SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

johnsone

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

LindaC

ASKER

Thank you.