ORA-12541: TNS:no listener

Hellthor · 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]
BlobSize=1
DataBase=DUNE
DriverName=Oracle
ErrorResourceFile=t:\a.txt
LocaleCode=0000
Password=myOwnPass
Oracle TransIsolation=ReadCommited
User_Name=myOwnUser

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.

Regards.

Challenger · 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.

Hellthor · 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.