ORA-12541: TNS:no listener

ORA-12541: TNS:no listener

Postby Hellthor » Tue 08 Aug 2006 08:41

Hi all,

I'm testing some reporting tools, such as Report Manager.
This program, RM, uses dbExpress in order to connect a remote Oracle database.
When I choose to connect, it shows a window where I have to fill some fields:
Code: Select all
Oracle TransIsolation=ReadCommited

I'm using SID (DUNE) as DataBase field, and when I click to establish the connection, I get this error: ORA-12541: TNS:no listener
Could someone tell me if I am wrongly filling the DataBase field? Or maybe the problem is with this remote Oracle database?
I've connect to it thru' JDBC and I didn't get this error.

Posts: 2
Joined: Tue 08 Aug 2006 08:25

Postby Challenger » Tue 08 Aug 2006 13:02

According to Oracle documentation you should ensure that the supplied destination address matches one of the addresses used by the listener. To do this please compare the TNSNAMES.ORA entry with the appropriate LISTENER.ORA file. Make sure that the listener is started on the remote machine.
Devart Team
Posts: 925
Joined: Thu 17 Nov 2005 10:53

Postby Hellthor » Wed 09 Aug 2006 07:31

Ok, I'll try something like that.
I will post the solution, if I finally get a connection.

Thanks a lot.
Posts: 2
Joined: Tue 08 Aug 2006 08:25

Return to dbExpress driver for Oracle