Jump to Navigation

225 - adrci (Automatic Diagnostic Repository Command Interpreter)

Starting with 11gR1, we have a new way to deal with Oracle Errors & Tracefiles: There is now a special command line utility
dedicated for that purpose called adrci.

This posting is intended to show you the (in my view) essential commands, a DBA ought to know in order to use it. We will look at

    1. Viewing the alert.log
    2. The relation between incident & problem
    3. Creation of Packages & ZIP files to send to Oracle Support
    4. Managing, especially purging tracefiles

Available Options :

        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

 

 

 

Oracle:


Main menu 2

Story | by Dr. Radut