By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,812 Members | 1,288 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,812 IT Pros & Developers. It's quick & easy.

Federation issue, DB2 to Oracle

P: n/a
Hi - I'm having some federation difficulties and am looking for some
help. On AIX 5.3, I'm running DB2 ESE 8.2 FP12 with Federation
enabled. Oracle client 10.2.0.2. I can connect to a remote oracle
instance using sqlplus, so I'm pretty confident the Oracle client is
OK. I'm able to create a NET8 wrapper, and to create a Server using
that wrapper. Control Center is able to discover all instances listed
in my tnsnames.ora, so I'm pretty sure it's able to find and parse
through it OK. I create my user mappings between local account and
oracle account without a problem. However, after I run set passthru
CTFOQ and try to run a query against it, I get an error "ORA-12154:
TNS:could not resolve the connect identifier specified". Again, using
the same id, I can resolve it just fine using sqlplus from the
command-line.

Any ideas/suggestions?

Thanks,
Dan

Nov 2 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Did you purchase and install Information Integrator with an Oracle
Wrapper or the new Information Server product?

Larry Edelstein

bspdan wrote:
Hi - I'm having some federation difficulties and am looking for some
help. On AIX 5.3, I'm running DB2 ESE 8.2 FP12 with Federation
enabled. Oracle client 10.2.0.2. I can connect to a remote oracle
instance using sqlplus, so I'm pretty confident the Oracle client is
OK. I'm able to create a NET8 wrapper, and to create a Server using
that wrapper. Control Center is able to discover all instances listed
in my tnsnames.ora, so I'm pretty sure it's able to find and parse
through it OK. I create my user mappings between local account and
oracle account without a problem. However, after I run set passthru
CTFOQ and try to run a query against it, I get an error "ORA-12154:
TNS:could not resolve the connect identifier specified". Again, using
the same id, I can resolve it just fine using sqlplus from the
command-line.

Any ideas/suggestions?

Thanks,
Dan
Nov 2 '06 #2

P: n/a
bspdan wrote:
........ However, after I run set passthru
CTFOQ and try to run a query against it, I get an error "ORA-12154:
TNS:could not resolve the connect identifier specified". Again, using
the same id, I can resolve it just fine using sqlplus from the
command-line.

Any ideas/suggestions?
Hi Dan,

The first sanity check I usually do is to check the NODE for the server
in the DB2 catalog and make sure it is correct. Try something like this
to check it out:

select varchar(servername,40) as server, servertype,
varchar(setting,40) as node
from syscat.serveroptions
where option = 'NODE';

If that's not it, maybe the wrapper and the discovery code are finding
two different tnsnames.ora files. Are you using the TNS_ADMIN
environment variable? If so, make sure you also set it to the same
value in your instance's sqllib/cfg/db2dj.ini file.

-Harold

Nov 3 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.