This content has been marked as final. Show 3 replies
Please follow the steps.
1) Make sure you got a FULL Oracle 10g client installed (check with your DBA). Oracle INSTANT CLIENT is NOT SUPPORTED.
2) Make sure the OBIEE user that you use to run the OBIEE services has read and execute permissions on all files under ORACLE_HOME for the Oracle client that you wish to use. Even better if you install the Oracle client with the same user as the OBIEE uses to run it's services.
3) 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). OBIEE uses the 32bits libraries.
4) Configure your OBIEE /OracleBI/setup/user.sh file to make sure your ORACLE_HOME and TNS_ADMIN variables are correctly set to the correct values. You also need to set these two:
5) Export all the above 4 variables in your current session and test that you can resolve your database name(s) by doing "tnsping DB_NAME".
6) 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.
obiee oci driver loading problem
Hope this help's
Thanks for the response but this is not where my problem is. My problem is that, it didn't work when I initially had the Selinux enabled. It threw those errors..
A: When I changed it to 'permissive', the OBIEE works. When I then change the Selinux back to 'enforeced', it still works.
B: In another environment since I can't change the Selinux setting, I just restarted OBIEE component without touching Selinux, after restarting, it works.
My question is, have you experienced these behaviors and is there a way to better understand such behaviors?