471,047 Members | 1,217 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,047 software developers and data experts.

Federation issue, DB2 to Oracle

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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.