adrci> help

 HELP [topic]

   Available Topics:

        CREATE REPORT

        ECHO

        EXIT

        HELP

        HOST

        IPS

        PURGE

        RUN

        SET BASE

        SET BROWSER

        SET CONTROL

        SET ECHO

        SET EDITOR

        SET HOMES | HOME | HOMEPATH

        SET TERMOUT

        SHOW ALERT

        SHOW BASE

        SHOW CONTROL

        SHOW HM_RUN

        SHOW HOMES | HOME | HOMEPATH

        SHOW INCDIR

        SHOW INCIDENT

        SHOW PROBLEM

        SHOW REPORT

        SHOW TRACEFILE

        SPOOL

 There are other commands intended to be used directly by Oracle, type

 "HELP EXTENDED" to see the list

adrci> HELP SHOW TRACEFILE

  Usage: SHOW TRACEFILE [file1 file2 ...] [-rt | -t]

                        [-i inc1 inc2 ...] [-path path1 path2 ...]

  Purpose: List the qualified trace filenames.

  Options:

    [file1 file2 ...]: The trace files users are interested in to search.

    If "-i" or/and "-path" is specified, the trace files are assumed

    to be under the specified incidents or paths. Otherwise, the files

    will be searched among the trace directory and all incident directories

    of the current ADR homes. Filenames allow SQL like condition syntax.

    I.e., allowing wildcard search on filenames by using "%". For example,

    "%mmon%" means all trace files with the "mmon" substring.

    [-rt | -t]: Order the trace filenames. "-t" means in the modified

    timestamps order; "-rt" means in the reversed modified timestamps

    order. Note that the ordering is only apply to a single directory.

    [-i inc1 inc2 ...]: The trace files produced for the listed incidents.

    If no files are listed, all trace files produced for the list

    incidents are considered.

    [-path path1 path2 ...]: The trace files under the given paths will be

    queried. If no files are listed, all trace files under these paths

    are considered.

  Examples: 

    1. Show all the trace files under the current home

       "show tracefile"

    2. Show all the mmon trace files in time reverse order

       "show tracefile %mmon% -rt"

    3. Show all trace files under incidents 123 456, and /home/someone/temp

       "show tracefile -i 123 456 -path  /home/someone/temp"

adrci> SHOW CONTROL

DIA-48448: This command does not support multiple ADR homes

adrci> show HOMES

ADR Homes:

diag/asm/+asm/+ASM1

diag/tnslsnr/zzwsjdb3/listener

adrci> set HOMEPATH diag/asm/+asm/+ASM1

adrci> show HOMES

ADR Homes:

diag/asm/+asm/+ASM1

SHOW ALERT -TAIL

SHOW ALERT -TAIL 50

SHOW ALERT -TAIL -F

SHOW ALERT -P "MESSAGE_TEXT LIKE '%ORA-600%'"

SHOW TRACEFILE

SHOW TRACEFILE %mmon%

SHOW TRACEFILE %mmon% -PATH /home/steve/temp

SHOW TRACEFILE -RT

SHOW INCIDENT

SHOW INCIDENT -MODE BRIEF

SHOW INCIDENT -MODE DETAIL

SHOW INCIDENT -MODE DETAIL -P "INCIDENT_ID=1681"

purge

SHORTP_POLICY

Trace files

Core dump files

Packaging information

LONGP_POLICY

 Incident information

Incident dumps

Alert logs

adrci> set home diag/rdbms/orcl/orcl

adrci> SET CONTROL(SHORTP_POLICY=24)

adrci> SET CONTROL(LONGP_POLICY=24)

adrci> show CONTROL

ADR Home = /u01/app/oracle/diag/rdbms/orcl/orcl:

*************************************************************************

ADRID                SHORTP_POLICY        LONGP_POLICY         LAST_MOD_TIME                            LAST_AUTOPRG_TIME                        LAST_MANUPRG_TIME                        ADRDIR_VERSION       ADRSCHM_VERSION      ADRSCHMV_SUMMARY     ADRALERT_VERSION     CREATE_TIME                              

-------------------- -------------------- -------------------- ---------------------------------------- ---------------------------------------- ---------------------------------------- -------------------- -------------------- -------------------- -------------------- ----------------------------------------

1335663986           24                   24                   2013-12-20 09:27:21.295138 +08:00        2013-12-14 05:48:36.092047 +08:00        2013-12-20 09:18:52.380654 +08:00        1                    2                    80                   1                    2013-08-27 07:08:28.517862 +08:00      

1 rows fetched

adrci> set home diag/rdbms/racdb/racdb1

adrci> SHOW PROBLEM

ADR Home = /u01/app/oracle/diag/rdbms/racdb/racdb1:

*************************************************************************

PROBLEM_ID           PROBLEM_KEY                                                 LAST_INCIDENT        LASTINC_TIME                            

-------------------- ----------------------------------------------------------- -------------------- ----------------------------------------

3                    ORA 445                                                     88339                2013-12-16 08:42:43.929000 +08:00      

6                    ORA 29770                                                   72139                2013-09-13 16:25:39.344000 +08:00      

5                    ORA 603                                                     72002                2013-08-07 08:14:35.111000 +08:00      

4                    ORA 600 [kgantc_1]                                          64385                2013-08-07 08:14:20.437000 +08:00      

2                    ORA 240                                                     64154                2013-06-27 10:37:36.264000 +08:00      

1                    ORA 600 [ksfdchkfob1]                                       64425                2013-05-23 13:10:42.927000 +08:00