OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » no listener

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

no listener [message #681507]

Sat, 25 July 2020 05:52

oracle@learner
Messages: 73
Registered: October 2011

Member


Unable to establish database connection.

Please check database configuration.

ORA-12541: TNS:no listener

Please help how to rectify the issue...
many thanks...

Report message to a moderator

Re: no listener [message #681510 is a reply to message #681507]

Sat, 25 July 2020 06:21

Michel Cadot
Messages: 67450
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

1/ Check the listener is started
2/ Check you try to connect to what you actually want to connect: tnsnames entry and/or connect string.

Report message to a moderator

Re: no listener [message #681516 is a reply to message #681507]

Sat, 25 July 2020 10:07

EdStevens
Messages: 1266
Registered: September 2013

Senior Member

And what did you discover when you googled "ORA-12541"?

Network connection issues are usually pretty simple, if you just take it one step at a time, starting with the requestor. And pay attention to the actual error message. Your error means one thing: when your request arrived at the specified server and port, there was no oracle listener active on that server and port.

So, what server and port was specified by the requestor? This can usually be seen by executing 'tnsping <dbname' on the requesting machine.

Report message to a moderator

Re: no listener [message #681524 is a reply to message #681516]

Mon, 27 July 2020 01:21

oracle@learner
Messages: 73
Registered: October 2011

Member

Thanks, it is working now after reconfigured the listener from net config...

Is it a common problem in oracle when I google it, most users faced the same problem...

Report message to a moderator

Re: no listener [message #681525 is a reply to message #681524]

Mon, 27 July 2020 02:20

Michel Cadot
Messages: 67450
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

most users faced the same problem...

What problem?
I had never used net config (and I work with Oracle since version 4, of course net config didn't exist at this time) and had never any problem with that.

Report message to a moderator

Re: no listener [message #681529 is a reply to message #681524]

Mon, 27 July 2020 06:21

EdStevens
Messages: 1266
Registered: September 2013

Senior Member

oracle@learner wrote on Mon, 27 July 2020 01:21

Thanks, it is working now after reconfigured the listener from net config...

Is it a common problem in oracle when I google it, most users faced the same problem...

Then obviously your listener had been incorrectly configured (or was never actually running). But now we'll never know.

Report message to a moderator

Previous Topic:	Oracle Data Mining component in 19c
Next Topic:	histograms in dbms_stats.gather_table_stats

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Oct 22 13:51:11 CDT 2020