Tuning and Monitoring RMAN and the Automatic Diagnostic Workflow - OCP: Oracle Database 12c Administrator Certified Professional - page 273

So, for items related to the Fault Diagnosability Framework, we are going to point you
to some tutorials that are available online from Oracle.
Oracle offers a number of tutorials on various subjects, including the OEM Support
Workbench. The tutorial I'd like to point you to is a good introductory tutorial that dem-
onstrates how the OEM Support Workbench can analyze and detect a database problem,
in this case, data dictionary corruption.
The tutorial then walks you through reviewing the incident, packaging it up for sending
to Oracle Support (which you wouldn't do, of course, since it is a tutorial). I'd strongly sug-
gest that you run through this Oracle tutorial on OEM Support Workbench. It takes about
30 minutes to complete and it can be found by searching on the Web for the terms “Oracle
support workbench data dictionary corruption.” The title of the tutorial is “Analyzing Data
Dictionary Corruption Using Support Workbench.”
We don't like to provide URLs in our topics because web pages tend to
change all the time. However, the search terms for the specific pages we
will be suggesting rarely change. Thus, we use search terms to point you
to the tutorial we are recommending.
The ADRCI Command-Line Utility
We mentioned the Automatic Diagnostic Repository Command Interpreter (ADRCI) previ-
ously. It is an alternative method of managing the functionality of the Fault Diagnosability
Framework components and infrastructure. It provides a command-line-driven means of
doing most of the tasks that Support Workbench does graphically. If you are not using Oracle
Enterprise Manager Cloud Control, you will have to use ADRCI. This is because Enterprise
Manager Express does not have an interface to ADRCI built into it.
ADRCI provides the ability to
■ Review the data that is contained in the ADR
■ Review Health Monitor reports
■ Work on problems and packaging incidents and send those incidents to MOS
ADRCI is not unlike SQL*Plus in that you can issue commands and even create
ADRCI scripts to run. ADRCI is protected based on what user you are logged in as and
the permissions of the files on the operating system. As a result, there is no password
required to use ADRCI.
Starting ADRCI
ADRCI is easy to use. Simply enter adrci at the OS prompt to start the interface, as
shown here:
C:\Users\rfreeman>adrci
ADRCI: Release 12.1.0.1.0 - Production on Sun Jan 5 12:27:58 2014
Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.