Page 1 of 1

ORA-12541: TNS:no listener

Posted: Tue 08 Aug 2006 08:41
by Hellthor
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.

Posted: Tue 08 Aug 2006 13:02
by Challenger
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.

Posted: Wed 09 Aug 2006 07:31
by Hellthor
Ok, I'll try something like that.
I will post the solution, if I finally get a connection.

Thanks a lot.