ORACLE Enterprise Stage in IBM Information Server V 8.1

RaviReena · Post by **RaviReena** » Sun Mar 15, 2009 9:24 am

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.

chulett · Post by **chulett** » Sun Mar 15, 2009 10:08 am

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'.

RaviReena · Post by **RaviReena** » Sun Mar 15, 2009 10:38 am

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.

chulett · Post by **chulett** » Sun Mar 15, 2009 10:41 am

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.

RaviReena · Post by **RaviReena** » Sun Mar 15, 2009 11:00 am

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?

Mike · Post by **Mike** » Sun Mar 15, 2009 11:12 am

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

chulett · Post by **chulett** » Sun Mar 15, 2009 11:15 am

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.

RaviReena · Post by **RaviReena** » Sun Mar 15, 2009 1:15 pm

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?

chulett · Post by **chulett** » Sun Mar 15, 2009 2:19 pm

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.

RaviReena · Post by **RaviReena** » Tue Mar 17, 2009 7:31 am

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.

RaviReena · Post by **RaviReena** » Tue Mar 17, 2009 7:33 am

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.

RaviReena · Post by **RaviReena** » Mon Apr 13, 2009 9:00 am

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

chulett · Post by **chulett** » Mon Apr 13, 2009 9:35 am

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