Time for action – monitoring the database alert log using ADRCI

Let's see an example of monitoring the database alert log using the ADRCI utility:

1. Ensure that the ORACLE_HOME and PATH environment variables are set properly. The PATH environment variable must include the ORACLE_HOME/bin directory.

   export ORACLE_HOME=/u01/app/oracle2/product/11.2.0/dbhome_1
   export PATH=$PATH:$ORACLE_HOME/bin
   

2. Start the ADRCI command-line tool:

   $ adrci
   
   ADRCI: Release 11.2.0.1.0 - Production on Thu Dec 20 02:06:49 2012
   
   Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
   
   ADR base = "/u01/app/oracle2"
   

3. We can run the HELP command to get help on the usage of this utility:

   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...