Weird TNS-12541: TNS: nolistener

Source: Internet
Author: User

Strange TNS-12541: TNS: nolistener OS: Microsoft Windows 2003 performanisedatabase: Oracle Database EnterPrise 11.2.0.1 memory: 1G August 13, 2013, is a special day, the sky is very blue, every corner of the city is filled with the scent of roses. It was an intoxicating day. When I was enjoying it, I suddenly got a call, and everything was gone. A customer site engineer called, said the database can not connect, listening can not come, was notified of the error TNS-12571: TNS: Package Write Program failed, by querying Metalink documentation, modify $ ORACLE_HOME/network/admin/SQLNET. add SQL. NET. AUTHENTICATION_SERVICES = (NONE), and then restart the listener. The result is invalid. About 2 hours later, I came to the user's site; check found that there was no TNS-12571 error, but reported TNS-12541: TNS: nolistener error, this error is obviously because the listener fails or cannot be started. Then manually start the listening program, the results found not to start, report TNS-12541 error, should be able to judge the problem is listening to the configuration file, so check and re-listen. What's more weird is that the rebuilding listening is also invalid, or the TNS-12541 error is reported, and the startup process is very slow, then I checked the hardware configuration, and the database parameter configuration, although relatively low, however, the database won't be able to get up and the listener won't be able to get up. Then, check the port and find port 1521. This indicates that the listener is up. At this time, I manually shutdown the database and stop all database services. Check again and find that there are still port 1521 online. Start to guess that there are other applications in addition to the database occupying port 1521 on the local machine. Then modify the default listening port to port 152 and restart the listening again, or the same report TNS-12541: TNS: nolistener; by viewing the port, port 152 does not exist, it is determined that the listen is not up. At this time, I guess it is probably caused by inter-memory communication. To correctly judge this problem, I will disable all related services, restart the server, and then restart the server with the user's consent, check the active port of the current server, no port 1521, which determines that port 1521 is not occupied by other self-starting software, so restart the listener again, or the same error: TNS-12541: TNS: no listener; at this time, I was puzzled that the listening log size reached 4 GB and could not be opened. Of course, it could not be analyzed. However, I noticed how to operate the listening service. The size of the listener log remains unchanged. At this time, I set the listener. log files are cut to the desktop and the listener with the same name is created in the original directory. log File, and grant Everyone write permission to start the listener again. At this time, no error is reported and the startup speed is very fast. In addition, the newly created listener. log File also records the listener startup information, which is correct. Then, it changes the listener port to the default port 1521, and the problem persists. Restart the database and automatically register the listener. Troubleshooting. This problem indicates that the database listening cannot start properly because the logs are too large to be written. We recommend that you manually clear the database log files regularly to avoid such problems.

Related Article

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.