The problem of abnormal listening caused by the listener. log exceeding 4 GB on windows is solved.

A friend consulted the production database Today. It was very slow and the application could not connect to the database. The analysis result showed that the file system of win 32-bit database 11.2.0.1 was ntfs, but listener. the log is 4 GB, causing abnormal listening.

Tnsping almost hangs

Lsnrctl status is almost hang

Ping the ip address directly.
It turns out that it is not a network problem and the listener is abnormal.

Disconnection is a listener problem

The Listening Log exceeds 4 GB.

Disable listening logs

Normal listening
After the listener log is disabled, the listener returns to normal.

The file system is in ntfs format.
It is proved that the maximum ntfs file size is not limited by the file system format. 4G is definitely not the limit of the system.
 

Well, the above is the solution to the abnormal listening problem caused by listener. log exceeding 4G on the windows platform. I hope this article will help you.