Original link:
Http://www.lookdaima.com/WebForms/WebPages/Blanks/Pm/Docs/DocItemDetail.aspx? empreviewtypev=2&id=279e64d5-7b60-43fa-b662-33731e895c84
To periodically clean up the listening log file (Listener.log), if you do not clean up regularly, you will encounter some of the following problems:
1: The Listening log file (Listener.log) is getting bigger and larger, taking up additional storage space. (Of course, now store the price of cabbage, not bad for that few grams of space.) But we still have to be in the spirit of craftsmen, Excellence) 2: Listening log files (Listener.log) has become too general to bring some problems: the LISTENER.LOG log size cannot exceed 2GB, which causes the listener listener to be unable to process the new connection. 3: The Listening log file (Listener.log) becomes too large for writing, viewing some of the performance issues and problems that are caused.
another:The Listening log listener.log log is placed under the $oracle_base/diag/tnslsnr/machine name/listener/trace directory
The following references are included in the log:
Thu May 24 05:36:17 2018
2 April-May -2018 05:36:17 * service_update * ORCL * 0
Thu May 24 05:36:49 2018
2 April-May -2018 05:36:49 * (Connect_data= (SID=ORCL) (Cid= (Program=e:\app\administrator\product\11.2.0\dbhome_1\perl\bin \perl.exe) (host=win-8hjg4a1ou19) (User=system))) * (Address= (PROTOCOL=TCP) (host=fe80::e83b:4238:1673:433f%12) ( port=58682)) * Establish * ORCL * 0
Thu May 24 05:37:02 2018
2 April-May -2018 05:37:02 * service_update * ORCL * 0
Thu May 24 05:37:17 2018
2 April-May -2018 05:37:17 * service_update * ORCL * 0
Thu May 24 05:37:47 2018
2 April-May -2018 05:37:47 * service_update * ORCL * 0
Thu May 24 05:38:17 2018
2 April-May -2018 05:38:17 * service_update * ORCL * 0
2 April-May -2018 05:38:27 * (Connect_data= (SID=ORCL) (Cid= (Program=e:\app\administrator\product\11.2.0\dbhome_1\perl\bin \perl.exe) (host=win-8hjg4a1ou19) (User=system))) * (Address= (PROTOCOL=TCP) (host=fe80::e83b:4238:1673:433f%12) ( port=58706)) * Establish * ORCL * 0
Thu May 24 05:38:28 2018
2 April-May -2018 05:38:28 * (Connect_data= (SID=ORCL) (Cid= (Program=e:\app\administrator\product\11.2.0\dbhome_1\perl\bin \perl.exe) (host=win-8hjg4a1ou19) (User=system))) * (Address= (PROTOCOL=TCP) (host=fe80::e83b:4238:1673:433f%12) ( port=58708)) * Establish * ORCL * 0
Thu May 24 05:38:56 2018
2 April-May -2018 05:38:56 * service_update * ORCL * 0
Thu May 24 05:39:13 2018
2 April-May -2018 05:39:13 * Ping * 0
2 April-May -2018 05:39:16 * (Connect_data= (SID=ORCL) (Cid= (Program=c:\windows\syswow64\inetsrv\w3wp.exe) (HOST= Win-v6iu3unf8ub) (User=easyworkwebsite)) * (Address= (PROTOCOL=TCP) (host=10.2.135.122) (port=60532)) * Establish * ORCL * 0
2 April-May -2018 05:39:17 * (Connect_data= (cid= (program=) (host=) (User=system)) (Command=status) (arguments=64) (SERVICE= ( Address= (PROTOCOL=TCP) (host=win-8hjg4a1ou19) (port=1521)) (version=186646784)) * Status * 0
2 April-May -2018 05:39:17 * service_update * ORCL * 0
Thu May 24 05:39:26 2018
2 April-May -2018 05:39:26 * (Connect_data= (SID=ORCL) (Cid= (Program=e:\app\administrator\product\11.2.0\dbhome_1\perl\bin \perl.exe) (host=win-8hjg4a1ou19) (User=system))) * (Address= (PROTOCOL=TCP) (host=fe80::e83b:4238:1673:433f%12) ( port=58722)) * Establish * ORCL * 0
2 April-May -2018 05:39:27 * (Connect_data= (SID=ORCL) (Cid= (Program=e:\app\administrator\product\11.2.0\dbhome_1\perl\bin \perl.exe) (host=win-8hjg4a1ou19) (User=system))) * (Address= (PROTOCOL=TCP) (host=fe80::e83b:4238:1673:433f%12) ( port=58723)) * Establish * ORCL * 0
Thu May 24 05:39:47 2018
2 April-May -2018 05:39:47 * service_update * ORCL * 0
2 April-May -2018 05:39:53 * service_update * ORCL * 0
Thu May 24 05:40:17 2018
2 April-May -2018 05:40:17 * service_update * ORCL * 0
Oracle database operations: To periodically clean up the listening log file (Listener.log), if you do not clean up regularly, you will encounter some of the following problems