This content has been marked as final. Show 3 replies
OK let's start again with all you need to do as you don't clarify if you have done it or not:
1) Make sure you got a full Oracle 10g client installed (check with your DBA).
2) Make sure your Oracle 10g client has the OCI 32bits libraries installed (check in the ORACLE_HOME/lib32 directory that the libclntsh.so.10.1 library exists and it's size is bigger than 0 bytes).
3) Configure your OBIEE user.sh file to make sure your ORACLE_HOME and TNS_ADMIN variables are correctly set. You also need to set these two:
4) Restart all your OBIEE services and check that all variables are correctly set (type "env").
After you have done all that give it a test and let us know if it works.
I have oracle client installed.
i have ORACLE_HOME/lib32 in my bi home .profile
but its still not working
I think i have to find the user.sh script where can i find it