4 Replies Latest reply on Oct 19, 2015 7:51 AM by rmoff

    How to setup oracle odbc connection on linux machine to get data in obiee.?


      Hi Expertise,


      I have Oracle DB on windows machine and obiee on linux redhat 6. I am trying to get the data from oracle db.

      it is showing ODBC error.


      I have configured tnsNames.ora file located in /home/oracle/uo1/app/oracle/product/11.2.0/dbhome_1/network/admin , below is the data i have added in tnsnames file

      EDWHCMB =


          (ADDRESS_LIST =

            (ADDRESS = (PROTOCOL = TCP)(HOST = = 1521))


          (CONNECT_DATA =

            (SERVICE_NAME = EDWHCMB)




      later i tried to ping using "tnsping edwhcmb" it is been pinging correctly

      Is anything more I am missing


      the screenshot of the error is :


      I am bit new to the Linux, so can anyone help me in solving this problem.