DS to Oracle Table Loading job

pdv · Post by **pdv** » Thu Aug 04, 2011 6:08 am

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

chulett · Post by **chulett** » Thu Aug 04, 2011 7:18 am

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.

pdv · Post by **pdv** » Thu Aug 04, 2011 7:32 am

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

chulett · Post by **chulett** » Thu Aug 04, 2011 7:37 am

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.

chulett · Post by **chulett** » Thu Aug 04, 2011 8:16 am

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?