topic ORA 12154 TNS Problem in QlikView

ORA 12154 TNS Problem

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have tried to connect Qlikview with Oracle DB.Test connection is successful..When I choose to connect it'll show the ora 12154 error ..I have reinstalled the Oracle client Also.

Can Anyone Help me in this..its very urgent.

Thanks.

Re: ORA 12154 TNS Problem

devarasu07 — Tue, 20 Jun 2017 04:27:16 GMT

Hi,

Have you configured Environment Variables (TNS_ADMIN, tnsnames.ora, Path etc.)

Try make sure you have tnsnames.ora file under below location

c:\Oracle\installxxx\network\admin\

also check this,

http://techiedan.com/2010/08/12/linking-qlikview-and-oracle-using-odbc/

Thanks,Deva

Re: ORA 12154 TNS Problem

Anil_Babu_Samineni — Tue, 20 Jun 2017 04:28:33 GMT

This is Qlikview Forum, I think you need to create over Oracle community. Anyway you can remove your tnsnames.ora if there aren't other tns in it. and use netmanager

Managing Oracle Net Services

Re: ORA 12154 TNS Problem

Anonymous — Tue, 20 Jun 2017 05:50:29 GMT

Thanks For ur Reply..

Its Connected ..Server has restarted..Then it is connecting.

Re: ORA 12154 TNS Problem

Anil_Babu_Samineni — Tue, 20 Jun 2017 05:54:04 GMT

Mark your reply as correct answer.