Ora 12541 no listener windows

So you are able to connect to database using sqlplus but not from SQL Developer? Show 4 more comments. Active Oldest Votes. Step 1 - Edit listener. Improve this answer. Sanabria 1 1 gold badge 7 7 silver badges 21 21 bronze badges. Mikael Holmgren Mikael Holmgren 2, 1 1 gold badge 16 16 silver badges 27 27 bronze badges.

Finally after one day of hardship, it works! The Listener in the DB Server set to localhost. Put the hostname for the computer solve my problem. Show 3 more comments.

If answers here not work , since this quesiton is closed. EXE start : sort. Add a comment. Armand Armand 31 5 5 bronze badges.

According to oracle online documentation ORA TNS:no listener Cause: The connection request could not be completed because the listener is not running. All rights reserved. The listener is listening to another port other than the default one, e. The connection went for the wrong database server. Please check every parameter in your connect descriptor and make sure they are correct. Jon Carpenter February 25, at pm.

Hello Ed, Used three of your posts related to listener and TNS setup, they did the trick, all of my issues are resolved. Ed Chen February 27, at am. Ed Chen March 9, at am. My pleasure. Collectives on Stack Overflow. Learn more. Asked 9 months ago. Active 9 months ago. Viewed times. I have also tried to use oracle sql developer But another error occur. Improve this question. Where are you finding that tnsnames.

Are you trying to create a database link to a non-Oracle database? The files you posted would be used for configuring Heterogeneous Services which is what you'd use to create a database link to a non-Oracle database. I don't think those are the files you want to be referencing. I'm assuming the Oracle database is installed locally i.