DSXchange

Do we need Oracle client in the unix server to be able to load Oracle loading DS jobs in the server.

Both oracle Server & Datastage server are installed in the same AIX unix server ?

The error we are getting while running the DS oracle loading job is

main_program: Error loading "orchoracle": Could not load "orchoracle": Could not load module /opt/IBM/InformationServer/Server/DSComponents/bin/orchoracle.o.
Dependent module libclntsh.so could not be loaded.
Could not load module libclntsh.so.
System error: No such file or directory
Could not load module /opt/IBM/InformationServer/Server/DSComponents/bin/orchoracle.o.
Dependent module /opt/IBM/InformationServer/Server/DSComponents/bin/orchoracle.o could not be loaded..

Thanks,
PKV

pdv wrote:Do we need Oracle client in the unix server to be able to load Oracle loading DS jobs in the server.

Yes... as long as "the unix server" means the server that DataStage is installed on.

Thanks! But we already have oracle server installed in the same unix server and I am able to connect to the database via sqlplus

You asked, I answered. Nothing more than that.

Ask to your error, search the forums as it has been discussed in the past and there is even an ongoing post today on the same subject.

Vino - I pointed you to the other file as a reference, as a topic you could watch, not for you to hijack with your version of the issue. Let's keep any discussion of your errors here.

Have you located the "libclntsh.so" module? Have you ensured that where it lives is included in your "shared library path" environment variable?