Problem Diagnosis - Expert Oracle RAC Performance Diagnostics and Tuning - page 616

ADR HOME : Each product stores diagnostic data underneath its own ADR home directory.
For example, in an Oracle RAC environment with shared storage and ASM, each database
instance and each ASM instance has a home directory within the ADR. The ADR's unified
directory structure helps correlate and analyze diagnostic data across multiple instances
and multiple products. All ADR homes share the same hierarchical directory structure.
Some of the standard subdirectories in each ADR home include alert (for the alert log),
trace (for trace files), and incident. ADR homes are located within the ADR base directory.
Homepath : The homepath determines the ADR homes that are current. It does so by
pointing to a directory within the ADR base hierarchy. If it points to a single ADR home
directory, that ADR home is the only current ADR home. If the homepath points to a
directory that is above the ADR home directory level in the hierarchy, all ADR homes that
are below the directory that is pointed to become current.
With multiple components (database, ASM, etc.), there are multiple locations where diagnostic data is collected
by Oracle. ADR home by default points to more than one location as illustrated here:
adrci> show homes
ADR Homes:
diag/tnslsnr/prddb3/listener_scan1
diag/tnslsnr/prddb3/listener_scan3
diag/tnslsnr/prddb3/listener_scan2
diag/tnslsnr/prddb3/listener_prd
diag/tnslsnr/prddb3/listener
diag/rdbms/prddb/PRDDB_1
diag/asm/+asm/+ASM1
To change this to one specific location, the homepath definition needs to be reset using set homepath <path>
command:
adrci> set homepath diag/rdbms/prddb/PRDDB_1
adrci> show homes
ADR Homes:
diag/rdbms/prddb/PRDDB_1
Similar to the show home, show control, and set control commands discussed earlier, ADR command line
interface provides several commands that can be executed from the command line. To get a list use the help
command or help extended command, use the following:
[mvallath@prddb3]$ adrci
ADRCI: Release 11.2.0.2.0 - Production on Fri Dec 17 17:24:13 2010
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
ADR base = "/app/oracle"
adrci> HELP EXTENDED
HELP [topic]
Available Topics:
BEGIN BACKUP
CD
CREATE STAGING XMLSCHEMA
CREATE VIEW
DDE
DEFINE