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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial