Federation issue, DB2 to Oracle

[bspdan]

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

[Larry]

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

[Harold]

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