Oracle BIEE Connectivity Errors in Linux

goodmm

原文地址：http://oracletechapp.blogspot.com/2008/05/obiee-connectivity-errors.html　　I recently was testing my new OBIEE setup in a Linux environment.

　　After the Repository creation (.rpd) file and successful export from Windows OBIEE Admin environment to the Linux environment, (more on some of the issues I>　　Upon connecting to my Presentation Server, I try to pick some data points from my Presentation Catalog and when I tried to execute the report, I got:

http://blog.51cto.com/wuliguo/../attachment/200907/200907181247912645115.jpg

　　Upon reviewing my system settings, user profiles, environment variables I discovered the following to fix the problem. Obiee is the user that owns OBI binaries and ora10db owns the Oracle 10gR2 DB server binaries. The issue really had to do with the group settings for both the binary owners and also the LD_LIBRARY_PATH settings.
[ora10db@linux1 ~]$>uid=504(ora10db) gid=503(dba) groups=100(users),503(dba) LD_LIBRARY_PATH=/apps/10g/ora10db/product/10g/lib:/apps/obiee/OracleBI/server/BinPATH=$PATH:/apps/10g/ora10db/product/10g/binwhere /apps/10g/ora10db/product/10g/lib is pointing to the ORACLE_DB_SERVER_HOME lib, and/apps/obiee/OracleBI/server/Bin points to the OBIEE installation pathAndobiee (user that owns OBIEE) was set to following group permissions
　　[obiee@linux1 ~]$>uid=505(obiee) gid=100(users) groups=100(users),503(dba)LD_LIBRARY_PATH=/apps/obiee/OracleBI/server/Bin:/apps/10g/ora10db/product/10g/libPATH=/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/obiee/bin.　　As a sidenote, if you encounter the following error:

http://blog.51cto.com/wuliguo/../attachment/200907/200907181247912677429.jpg

　　Check and make sure that you have the service name entries properly defined in the TNS_ADMIN location in the (db server) ORACLE_HOME/network/admin.