Am 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".
Any ideas/suggestions?
Thanks,
Dan
He who loses honor can lose nothing else.
identifier specified".
Any ideas/suggestions?
Thanks,
Dan
He who loses honor can lose nothing else.