Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Gateway between ORacle and as400

488266May 20 2008 — edited Jun 13 2008

Hello All,
I am tring to set agateway between Oracle 9i and as400/db2.
the drda gateway was intalled on the 9i on different oracle_hiome then the database( both on same machine) .
configured the listener.
and tnsping works!
when I try to access the as400/db2 from the oracle using dblink
i get "ORA-12154: TNS:could not resolve service name"
could anyone shade some light on this ? - does this mena my init<sid>.ora
is not configured correctly?
obviously I was not able to install the package since can not access the as400.

does any of you guys know how I can check for the db2 - database name?
since on the site I am working they can not help me with that, and I am not a db2 / as400 guy. ( I think that the parameter i have for that is wrong) .

thanks

S.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 11 2008

Added on May 20 2008

#heterogeneous-connectivity

8 comments

3,382 views