CONNECTION to ORACLE from DataStage AIX 7.5

[killbill1]

Hi All,

This question is regarding using Oracle native connection and importing the table defination using "Plug in metadate defination" from the manager.

We added a new entry in tnsnames.ora file and tested if the connection is working fine( by running the job using the new entry), and its does work fine. But the problem is that when we want to import the table definations using the "Plug in metadate definations " from the manager, we don't see the new entry in the drop down box. Although, we see most of the entries which are in tnsnames.ora file, few of them are missing. I'm not sure if thr are some scripts which we have to run before we can see them from the import table definations option.
Any help on where to look at or the actual solution is greatly appreciated

Thanks.

[ray.wurlod]

Try View > Refresh. It may or may not work. Otherwise, open a new Manager, which will force the tnsnames.ora file to be re-read.

[chulett]

That drop-down list is a little "buggy" and won't always show you the tnsname entries correctly, especially if you maintain them by hand.

Simple solution is to type the tnsname you want to use, there's no need to actually pick it from the list.

[killbill1]

Thanks for the quick response Craig... Works perfectly fine as you said.