Home » RDBMS Server » Networking and Gateways » ORA-12541 TNS No listener with pl/sql developer
ORA-12541 TNS No listener with pl/sql developer [message #280917] Thu, 15 November 2007 03:11 Go to next message
maga
Messages: 17
Registered: November 2007
Junior Member
I have an oracle database 10.2.0.1.0 on windows 2003 server 64 bit.

And I have a client. In my client there is installed pl/sql developer.
When I try to connect to the dataaase with pl/sql developer I recivied this message:
ORA-12541 TNS No listener

but the lister is on.
I'm able to connect in my client with sqlplus: conn system/password@alias
and I'm able to use sql developer


So what can be the problem?
Re: ORA-12541 TNS No listener with pl/sql developer [message #280919 is a reply to message #280917] Thu, 15 November 2007 03:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68637
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12541: TNS:no listener
 *Cause: The connection request could not be completed because the listener
 is not running.
 *Action: Ensure that the supplied destination address matches one of
 the addresses used by the listener - compare the TNSNAMES.ORA entry with
 the appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is to
 go by way of an Interchange). Start the listener on the remote machine.

Check you are using the same tnsnames.ora for both clients.

Regards
Michel
Re: ORA-12541 TNS No listener with pl/sql developer [message #280930 is a reply to message #280917] Thu, 15 November 2007 03:59 Go to previous messageGo to next message
maga
Messages: 17
Registered: November 2007
Junior Member
Server and client don't have the same tnsnames
Re: ORA-12541 TNS No listener with pl/sql developer [message #281528 is a reply to message #280917] Sat, 17 November 2007 22:30 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

what is the output of
lsnrctl services ;
Previous Topic: not able to access thro db link
Next Topic: HS ODBC set isolation level when reading from ext non oracle db
Goto Forum:
  


Current Time: Tue Apr 16 18:19:43 CDT 2024