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]
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.
Hellthor
 
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.
Challenger
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.
Hellthor
 
Posts: 2
Joined: Tue 08 Aug 2006 08:25


Return to dbExpress driver for Oracle