ADRCI PURGE Command Is Not Cleaning Up CDUMP_{TIMESTAMP} Folders In TRACE Directory (Doc ID 756140.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.1.0.6 [Release 11.1]
Information in this document applies to any platform.
Oracle Server Enterprise Edition - Version: 11.1.0.6


Symptoms

For this article there are no symptoms in terms of errors seen in alert or within the session.

Instead for this article to be applicable the user will be trying to delete folders using the ADRCI tool under Oracle11g 11.1.0.6, the problem is only seen on this particular release and is resolved in the 11.1.0.7 patchset.

There is no clear documentation to show how such directories can be removed using ADRCI so to demonstrate the problem and solution an example is now provided. The example is specific to a particular machine/instance so cannot be simulated by a testcase. The purpose of the example is simply to highlight syntax and usage of ADRCI:

a) navigate to the directory containing the instance trace information:

cd /app/oracle/diag/rdbms/v1116u/V1116U/trace


The path will depend on the installation. If unsure of on the location, issue the following query against the database instance:

SELECT VALUE FROM V$DIAG_INFO WHERE NAME LIKE 'Diag Trace%';


b) At the OS command prompt issue the directory listing command, like in:

$ ls -ltr | grep cdmp

 drwxr-xr-x 2 oracle dba 4096 Nov 11 11:54 cdmp_20081111115441/
 drwxr-xr-x 2 oracle dba 4096 Nov 13 09:10 cdmp_20081113091031/
 drwxr-xr-x 2 oracle dba 4096 Nov 20 11:23 cdmp_20081120112348/
 drwxr-xr-x 2 oracle dba 4096 Nov 27 06:52 cdmp_20081127065231/
 drwxr-xr-x 2 oracle dba 4096 Nov 27 06:52 cdmp_20081127065232/
 drwxr-xr-x 2 oracle dba 4096 Nov 27 06:52 cdmp_20081127065235/


c) initiate the ADRCI utility:

$ adrci


d) at the ADRCI command prompt display all Oracle Homes maintained by this ADR:

adrci> show homes


e) If (d) shows more than 1 home, select the proper home for use with ADRCI:

adrci> set homepath diag/rdbms/v1116u/V1116U
adrci> set home diag/rdbms/v1116u/V1116U


The SET command here depends on (a). If (c) already shows diag/rdbms/v1116u/V1116U then no action needed.

f) find out what incidents are reported for this instance:

adrci> show incident

INCIDENT_ID  PROBLEM_KEY                    CREATE_TIME
-----------  -----------------------------  ------------------------------
      39828  ORA-4031                       2008-11-27 06:52:26.580144 +00:00
      39820  ORA-4031                       2008-11-27 06:52:28.845338 +00:00
      39796  ORA-4031                       2008-11-27 06:52:27.562537 +00:00
      39780  ORA-4031                       2008-11-27 06:52:32.817075 +00:00
      39748  ORA-4031                       2008-11-27 06:52:29.250429 +00:00
      31411  ORA-7445 [mdagun_term()+1031]  2008-11-20 11:23:43.585772 +00:00

6 rows fetched


g) try to purge the evidence of the incident 31411:

adrci> purge -i 31411


'show incident' will then show the 5 remaining rows but still 'ls -ltr' shows six CDMP_<timestamp> directories.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms