Cannot connect to a Oracle Database

[#1]

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

[maxgro]

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

[#3]

Thank you Massimo.

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

[rido1421]

Maybe try a TNS PING?

[maxgro]

I think with

tnsping DBName

you should get the same error