Oracle Database Discussions

hi,

i)what is the cwbcfg program to be executed you have mentioned.

ii) I executed caths.sql

iii) In tnsnames.ora how to specify the dsn that you create for db2 database.

for example if I have created a dsn for db2 naming it kishore_dsn, how do i specify that in tnsnames.ora file.

and by what sid is the iniths_sid.ora to be created. is it the dsn you create for db2 database. for ex. if dsn name is kishore_dsn, should the file be initkishore_dsn.ora, or it should be the name of local oracle database service.


DESIGN.FORESEEINDIA.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = compaq6)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = design)
)
)

KISHORE_DSN =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = compaq6)(PORT = 1521))
)
(CONNECT_DATA = (SERVICE_NAME = KISHORE_DSN)
)
(HS = OK)
)

I am getting ora-12154 tns could not resolve service name, while tring to access db2 after creating public links.

I would appreciate if you can send me step by step generic connectivity ,connecting db2 from oracle.


Prabhath.