Oracle listener is too slow to connect to the database after address restrictions are added

Source: Internet
Author: User

Database environment: Oracle 9i

HOST: AIX 5.3

Symptom: It is too slow to connect to the database. You can use topas to check the resource usage of the host. Everything is normal. The connection from the local database to itself will be slow as long as it is listened through listener. If you use an oracle user and use sqlplus '/as sysdba' to connect, everything works. The listener problem is found in the database. So I checked the listener log and found that the listener log was full five months ago, causing the listener process to be abnormal.

Solution: Clear the listener log and restart the listener.

This problem occurs again later, but the log is not large, and this problem occurs after a period of running. Find the reason. It is found that another IP address that is not in the address list will apply for a connection every 10 seconds, but there will be a denial in the log, but this IP address is not recorded. No way. Remove the address restriction first and restart listener. View the log, find the address, and then directly restrict it from the firewall. This problem is the final outcome.

Conclusion: After adding address restrictions to oracle, you must pay attention to the size of listening logs. Note that there cannot be IP addresses that are not in the address list for frequent access. Otherwise, the database may run for a period of time, connecting to the database will be very slow.

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.