Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

SanthoshSreshtaAug 24 2015 — edited Oct 19 2015

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 :

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

Thanks,

Santhosh

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 16 2015

Added on Aug 24 2015

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

4 comments

322 views