OLEDB Connection error (ORA 12541: TNS No Listener)

[siddharth_kulka]

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

[Clever_Anjos]

TNSPING NYAMFID1.us.db.com

returns what?

[siddharth_kulka]

[maxgro]

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?

[ToniKautto]

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?

[siddharth_kulka]

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?

[siddharth_kulka]

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.

[ToniKautto]

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

[siddharth_kulka]

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.

[Clever_Anjos · Accepted solution]

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)