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

Get Oracle Data Guard 11gR2 Administration Beginner's Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.