topic Re: Cannot connect to a Oracle Database in QlikView

Cannot connect to a Oracle Database

Fri, 12 Sep 2014 11:37:57 GMT

Hello everyone,

I am trying to connect to a oracle database using OL EDB. I have entered the name of the data source, the username and the password and I get the error :

ORA 12541 : TNS: No listenning process (translated from French)

Yet, I have added the following lines in the tnsnames.ora file.

DBName =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = [IP] )(PORT = 1561))

)

(CONNECT_DATA =

(SERVICE_NAME = DBName)

)

And I can ping the IP.

Any ideas ?

Thanks for your help

Re: Cannot connect to a Oracle Database

maxgro — Fri, 12 Sep 2014 11:44:30 GMT

ping IP means you can reach the server (host), not the oracle database

it seems you have to start the oracle listener, ask your dba

Re: Cannot connect to a Oracle Database

Fri, 12 Sep 2014 12:01:14 GMT

Thank you Massimo.

I was told I need to open some flows. I'll see once it will be done if it works.

Re: Cannot connect to a Oracle Database

rido1421 — Fri, 12 Sep 2014 12:04:50 GMT

Maybe try a TNS PING?

Re: Cannot connect to a Oracle Database

maxgro — Fri, 12 Sep 2014 12:21:34 GMT

I think with

tnsping DBName

you should get the same error