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

    SanthoshSreshta

      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 =

      (DESCRIPTION =

          (ADDRESS_LIST =

            (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.0.14)(PORT = 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 :

      error.png

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

       

      Thanks,

      Santhosh