DSXchange

We installed IBM Information Server V 8.1 on Unix Sun Solaris SPARC 64 bit and We installed Oracle client libraries and updated the path in dsenv file as well as stop and start the Datastage server.
We are testing the oracle connectivity using Oracle Enterprise stage and we are getting the below error message in Datastage Director.

main_program: Error loading "orchoracle": Could not load "orchoracle": ld.so.1: osh: fatal: /opt/Oracle/10.2.0/client_1/lib/libclntsh.so.10.1: Permission denied.

Here is my dsenv entries.

PATH=$APT_ORCHHOME/bin:$PATH;export PATH
LD_LIBRARY_PATH=$APT_ORCHHOME/lib:$LD_LIBRARY_PATH;export LD_LIBRARY_PATH
#ORACLE DATABASE
ORACLE_HOME=/opt/Oracle/10.2.0/client_1; export ORACLE_HOME
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib;export LD_LIBRARY_PATH
PATH=$PATH:$ORACLE_HOME/bin; export PATH


can any one please suggest what could be the problem for connecting the oracle using ORACLE Enterprise stage in this scenario.

Make sure you are pointing to the 32bit Oracle libraries in your environment variables. That would typically mean changing '$ORACLE_HOME/lib' to '$ORACLE_HOME/lib32'.

Craig,

I tried changing the lib to lib32 and again got the same error message.

main_program: Error loading "orchoracle": Could not load "orchoracle": ld.so.1: osh: fatal: /opt/Oracle/10.2.0/client_1/lib32/libclntsh.so.10.1: Permission denied.

It is saying permission denied, do we need to change any permissions ?
we are running the job using an id belongs to dstage group.

I would say so - what are the permissions on that file? Sounds like you will need to have your DBA open things up a bit.

Criag,

At the /opt/Oracle/10.2.0/client_1/lib32 level here is the permissions.

-rwxrwxr-x 1 testid staff 20369280 Mar 13 10:33 libclntsh.so.10.1

At the /opt/Oracle level here is the permissions.

drwxrwx--- 3 testid staff 512 Mar 13 10:31 10.2.0

do you think i need to change any permissions here?

I think version 8.1 might be the first version to use 64bit database client libraries... at least in the case of DB2, IBM support told me version 8.0.1 still requires 32bit libraries while version 8.1 will work with 64bit libraries.

Mike

Interesting, that would definitely be something to check on for Oracle as well.

RaviReena - yes, definitely. Chat with your DBA as they should be the ones making any kind of change like that.

Criag,

I changed the permission on the opt/Oracle folder level and rerun the job pointing to $ORACLE_HOME/lib32 and it failed with EFCLASS32 error and changed the path to $ORACLE_HOME/lib it failed with below error.

Oracle_Enterprise_0: Connect failed: ORA-12514: TNS:listener does not currently know of service requested i

I added ORACLE_SID user defined environment variable in Adminstartor and rerun job again but failed with same listenere error.

How should i take care of Oracle SID?I don't have tnsnames.ora file any where on my unix box. I want to use ORACLE_SID to resolve this issue?

RaviReena wrote:How should i take care of Oracle SID? I don't have tnsnames.ora file any where on my unix box.

You don't need $ORACLE_SID set for this to work. You do, however, need a tnsnames.ora file somewhere on the server. It will look for one in $ORACLE_HOME/network/admin by default or you can set $TNS_ADMIN to override the default location.

Thank you Criag for your input, I am waiting to get my tnsnames.ora file. I will post the result when I am done with my testing.

Thank you Criag for your input, I am waiting to get my tnsnames.ora file. I will post the result when I am done with my testing.

Finally we got the tnnames.ora file and everything working fine.
Thanks Criag for your Input.

Great! Now time to mark your post as Resolved using the button at the top of the page.