topic Re: OLEDB Connection error (ORA 12541: TNS No Listener) in QlikView

OLEDB Connection error (ORA 12541: TNS No Listener)

siddharth_kulka — Tue, 19 May 2015 19:59:08 GMT

Getting below error when testing an OLEDB connection on desktop.

Facts:

1. Trying to connect to Oracle DB on DEV server using OLEDB

2. The connection works when logged into actual DEV server but fails from desktop

3. Using

4. 64 Bit Driver installed on desktop

5. TNSNAMES.ORA with correct entries copied at the required location (Working for others)

6. Tried re-installing oracle client and driver to negate corrupt driver issue if any, but to no avail

Any idea, what else might be causing this? Any experiences?

Thanks,

Sid

Re: OLEDB Connection error (ORA 12541: TNS No Listener)

Clever_Anjos — Tue, 19 May 2015 20:11:50 GMT

TNSPING NYAMFID1.us.db.com

returns what?

Re: OLEDB Connection error (ORA 12541: TNS No Listener)

siddharth_kulka — Tue, 19 May 2015 21:19:19 GMT

Re: OLEDB Connection error (ORA 12541: TNS No Listener)

maxgro — Tue, 19 May 2015 22:26:55 GMT

there is no service_name in your alias

compare the tnsping result on the desktop and on the server

what is different? oracle version? sqlnet.ora? tnsnames.ora?

Re: OLEDB Connection error (ORA 12541: TNS No Listener)

ToniKautto — Tue, 19 May 2015 22:44:10 GMT

I would say this is not specific to you Oracle connection form QlikView, but would be a problem from any client connection on the same machine. You might be able to find quicker and more detailed help from Oracle forums or help pages.

I found these pages that have some suggestions and reasoning on what the problem might be;

ORA-12541: TNS: no listener

http://www.orafaq.com/wiki/ORA-12541

Would these help you resolve the issue?

Re: OLEDB Connection error (ORA 12541: TNS No Listener)

siddharth_kulka — Tue, 19 May 2015 22:50:28 GMT

Massimo,

I only have TSANAMES.ORA in the required folder on the desktop. I do not have sqlnet.ora copied over? Is sqlnet.ora required?

Also, I did not get your comment "there is no service_name in your alias". Could you pls clarify, so that I can resolve this?

Re: OLEDB Connection error (ORA 12541: TNS No Listener)

siddharth_kulka — Tue, 19 May 2015 22:54:08 GMT

Toni,

I have SQL Developer on my desktop and I am able to connect using it. So for the same database, Qlikview is giving a problem but SQL Developer works fine.

Re: OLEDB Connection error (ORA 12541: TNS No Listener)

ToniKautto — Tue, 19 May 2015 23:20:21 GMT

That sounds a bit surprising to me. Are you using exactly the same credentials and driver?

Re: OLEDB Connection error (ORA 12541: TNS No Listener)

siddharth_kulka — Tue, 19 May 2015 23:32:12 GMT

For SQL Developer, we use different credentials but the same driver.

Regardless, the point is:

1. The credentials AND/OR OLEDB URL that is being used by Qlikview works fine when logged in to the server

2. Except for another developer (like me), no one has this issue (Desktop).

So my best guess is- There is something that I may be missing here. A trivial setting or a file similar to (TNSNAMES.ORA) that needs to be copied over.

Re: OLEDB Connection error (ORA 12541: TNS No Listener)

Clever_Anjos — Wed, 20 May 2015 01:02:03 GMT

As I can see, you can´t "see" your host

Please copy slqnet.ora and tnsnames.ora from an working station (or your DSV server)

Re: OLEDB Connection error (ORA 12541: TNS No Listener)

maxgro — Wed, 20 May 2015 07:39:44 GMT

in your alias you have

SERVICE_NAME=

so service_name is blank

is it the same when you try the tnsping .... on the server?

Re: OLEDB Connection error (ORA 12541: TNS No Listener)

Wed, 20 May 2015 07:46:41 GMT

I had a similar problem when I first started using Qlikview, it was the drivers that hadn't installed properly.

Re installed it and hey presto it worked again!

Re: OLEDB Connection error (ORA 12541: TNS No Listener)

ToniKautto — Wed, 20 May 2015 09:24:17 GMT

I have not found any other clue in our support knowledge, it always seems to boil down to Oracle installation or config

Did you check the links I posted earlier?

Re: OLEDB Connection error (ORA 12541: TNS No Listener)

siddharth_kulka — Wed, 20 May 2015 13:39:55 GMT

The issue was resolved after copying over tnsnames.ora directly from the server.

Can't say it is was different from the one previously used, but somehow fixed the issue. Sadly, no rational behind the fix.

Thanks All!