Use ADRCI or Support Workbench to package the incident.

step 1
adrci> show alert -p "message_text like '%incident%'"

ADR Home = /oramisc01/oracle/diag/rdbms/demoprim/demo1:
*************************************************************************
Output the results to file: /ora01/oracle/temp/alert_33812_140499732489984_demo_1.ado


step 2
adrci> show problem

ADR Home = /oramisc01/oracle/diag/rdbms/demoprim/demo1:
*************************************************************************
PROBLEM_ID           PROBLEM_KEY                                                 LAST_INCIDENT        LASTINC_TIME                
-------------------- ----------------------------------------------------------- -------------------- ----------------------------------------
1                    ORA 600 [ktbdchk1: bad dscn]                                80396                2018-08-19 16:39:16.523000 -04:00
1 rows fetched

step 3
adrci> show incident

ADR Home = /oramisc01/oracle/diag/rdbms/demoprim/demo1:
*************************************************************************
INCIDENT_ID          PROBLEM_KEY                                                 CREATE_TIME
-------------------- ----------------------------------------------------------- ----------------------------------------
80393                ORA 600 [ktbdchk1: bad dscn]                                2018-08-19 16:38:39.543000 -04:00
80394                ORA 600 [ktbdchk1: bad dscn]                                2018-08-19 16:39:14.585000 -04:00
80395                ORA 600 [ktbdchk1: bad dscn]                                2018-08-19 16:39:15.629000 -04:00
80396                ORA 600 [ktbdchk1: bad dscn]                                2018-08-19 16:39:16.523000 -04:00
4 rows fetched

step 4
show incident -mode detail -p "incident_id=80393"

step 5
First, create the package using the problem ID displayed by the SHOW PROBLEM command.
adrci > ips create package problem 1 correlate all

step 6
Next, create a zip to send to Oracle Support by specifying the package number displayed by the above command.
adrci > ips generate package 1 in "/tmp"

step 6
send the zip file to oracle

ADRCI

 

 -- purge trace, using 

      purge -age 8640 -type TRACE 

         1440 (minutes in one day) * 6 = 8640 minutes = 6 days

reconfig_ardci.sh

for i in `adrci exec="show homes"`;do

adrci << EOF

set home $i

       set control (SHORTP_POLICY = 168)

       set control (LONGP_POLICY = 168)

       purge -age 60 -type alert

       purge -age 60 -type incident

       purge -age 60 -type trace

       purge -age 60 -type cdump

       purge -age 60 -type hm

       purge -age 60 -type  UTSCDMP

show control

EOF

Done

purge_listener.sh

for i in `adrci exec="show homes"|grep listener`;do

echo $i

echo "adrci exec=\"set home $i;show control;purge\""

adrci exec="set home $i;show control;purge";

done

ADR_BASE_LISTENER for listener log adn trace files

ADR_BASE_LISTENER directory

To Change the adr directory for listener from default

Make Changes in listener.ora file

 e.g. ADR_BASE_LISTENER = /oralog/oracle

example:

/oralog/oracle/oradiag_oracle/diag/clients/user_oracle/

Hope this helps. Regards Rupam

change adrci destination

How to change adrci diagnostics destination in 11g.

Steps :

1. sqlplus as sysdba

2. check current diagonostic destination

adrci alert

ADRCI  alert

 

Log into the oracle user.

Set Oracle database environment, using

. oraenv

Start the ADR command line interpreter(ADRCI) by issuing the following command in the database directory:

adrci purge

ADRCI  purge

The automated purge policy for Diagnostic data includes incident and problem descriptions, trace files, dumps, health monitor reports, alert log entries, and more are governed by policy setting. 

Cleanup is done by MMON background process.

adrci commands

ADRCI  commands

Log into the oracle user.

Set Oracle database environment, using

. oraenv

Start the ADR command line interpreter(ADRCI) by issuing the following command in the database directory:

adrci

ADRCI: Release 11.2.0.2.0

ADR base = "/ora01/oracle"

adrci

ADR command line interpreter(ADRCI)

ADRCI enables you to:

• View diagnostic data within the Automatic Diagnostic Repository (ADR).
• View Health Monitor reports.
• Package incident and problem information into a zip file for transmission to Oracle Support.