Environment:
Os:hp-unix
Database: 11.2.0.4 Dual-machine RAC
(i) Phenomenon
While cleaning up the ORACLE logs, it was found that there were a lot of clsc*.log under the $oracle_home/log/{instance_id}/client. After observation, it is found that 2 logs are generated every 5 minutes, as follows:
-rw-r--r--1 Oracle Oinstall 244 Sep 15:55 clsc34691.log-rw-r--r--1 Oracle oinstall 244 Sep 15:55 clsc34692.log- rw-r--r--1 Oracle Oinstall 244 Sep 16:00 clsc34693.log-rw-r--r--1 Oracle oinstall 244 Sep 16:00 clsc34694.log-rw-r --r--1 Oracle Oinstall 244 Sep 16:05 clsc34695.log-rw-r--r--1 Oracle oinstall 244 Sep 16:05 clsc34696.log-rw-r--r- -1 Oracle Oinstall 244 Sep 16:10 clsc34697.log-rw-r--r--1 Oracle oinstall 244 Sep 16:10 clsc34698.log-rw-r--r--1 Oracle Oinstall 244 Sep 16:15 clsc34699.log-rw-r--r--1 Oracle oinstall 244 Sep 16:15 clsc34700.log-rw-r--r--1 Orac Le oinstall 244 Sep 16:20 clsc34701.log-rw-r--r--1 Oracle oinstall 244 Sep 16:25 clsc34702.log-rw-r--r--1 Oracle O Install 244 Sep 16:30 clsc34703.log-rw-r--r--1 Oracle oinstall 244 Sep 16:35 clsc34704.log-rw-r--r--1 Oracle Oinst All 244 Sep 16:40 Clsc34705.log ...
View the number of logs and find that there are already many
Fabdb1$[/grid/11.2. 0/grid/log/fabdb1/client]ll | WC -l34709
(ii) Reasons
Found this is Oracle in 11.2 bug, in the case of Oracle em on, EM will use crs_stat every 5 minutes to collect the status of Oracle services, resulting in the creation of logs.
(iii) Solutions
Log in as an Oracle user to the directory:
$ORACLE _home/sysman/admin/scripts/
2 Files Modified:
① Vim crs_resources.pl
" $crs _home/bin/crs_stat " "$crs _home/bin/crsctl stat res"
②vim crs_vip.pl
" $crs _home/bin/crs_stat " "$crs _home/bin/crsctl stat res"
Restart EM
Emctl Stop Dbconsoleemctl start dbconsole
Su-grid
CD $ORACLE _home/log/{instance_name}/client
LS-LRT--continuously monitor for half an hour to check if a log file is generated regularly.
Oracle generates 2 Clsc*.log files every 5 minutes