ORA-12541: TNS:no listener

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for Oracle in Delphi and C++Builder
Post Reply
Posts: 2
Joined: Tue 08 Aug 2006 08:25

ORA-12541: TNS:no listener

Post by 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.


Devart Team
Posts: 925
Joined: Thu 17 Nov 2005 10:53

Post by 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.

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

Post by 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.

Post Reply