How to Prevent/Fix /usr/TKLC/oracle11 Partition from Being Full on Oracle Server in Diameter Intelligence Hub (DIH) ?

Asset ID:	1-72-2127338.1
Update Date:	2017-12-25
Keywords:

Solution Type Problem Resolution Sure

Solution 2127338.1 : How to Prevent/Fix /usr/TKLC/oracle11 Partition from Being Full on Oracle Server in Diameter Intelligence Hub (DIH) ?

Applies to:

Oracle Communications Diameter Signaling Router (DSR) - Version DSR 5.0 to DSR 7.1.1 [Release DSR 5.0 to DSR 7.0]
Information in this document applies to any platform.

Symptoms

/usr/TKLC/oracle11 partition is full on the DIH oracle server.

Cause

Two folders are full of logs, thousands of files are created preventing the script supposed to compress them to work.

First folder is /usr/TKLC/oracle11/oracle/diag/rdbms/pic/PIC/alert containing 'log_*.xml' files

Second folder is /usr/TKLC/oracle11/grid/product/11.2.0/grid/rdbms/audit containing '+asm_ora_*.aud' files

This issue is caused by an Oracle Database bug, see 1298957.1 for details.

Solution

Fix

To fix the issue the partition usage must first be fixed. To do that log as root user to the DIH oracle servers and run the following commands:

find /usr/TKLC/oracle11/oracle/diag/rdbms/pic/PIC/alert -maxdepth 1 -name 'log_*.xml' -mtime +10 -delete
find /usr/TKLC/oracle11/grid/product/11.2.0/grid/rdbms/audit -maxdepth 1 -name '+asm_ora_*.aud' -mtime +10 -delete

Prevent

Once the partition usage is back to normal enter crontab to add new jobs to purge the folder from the older files:

Log as root
Edit cron:
crontab -e
Insert the following lines:
0 2 * * * /usr/bin/find /usr/TKLC/oracle11/grid/product/11.2.0/grid/rdbms/audit -maxdepth 1 -name '+asm_ora_*.aud' -mtime +10 -delete
0 3 * * * /usr/bin/find /usr/TKLC/oracle11/oracle/diag/rdbms/pic/PIC/alert -maxdepth 1 -name 'log_*.xml' -mtime +10 -delete
Save and exit (:wq)

Attachments

This solution has no attachment