The NO listener error occurs during PLSQL developer login.

Source: Internet
Author: User

ORA-12541: TNS: No listener

Since PLSQL developer was unable to log on to Oracle, it was long before people wanted to study this database, but they had no time to study it.

I used to use the client PLSQL developer, there is no problem, but today when starting PLSQL developer, there is always "ORA-12541: TNS: No

Listener "problem, found the solution on the Internet:

Start --> Oracle InstallationProgramAccording to --> net configuration Assistant

Select Listener Configuration --> next --> Add (generally, the server is vulnerable to problems, so Add a new listener) --> Add listener

Name (generally, the name of the database to be accessed is used as the listener name) --> select TCP --> select default. Return to the logon page, --> select a local net name.

Service configuration --> select "reconfigure" --> select the Net Name (generally the global database name) --> enter the local IP address, select the default one, and then enter the local IP address.

To restart the service.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.