Basic ADRCI Commands

  1. Get and Set ADR_BASE location.

     [oracle@orcl ~]$ adrci
    
     ADRCI: Release 19.0.0.0.0 - Production on Tue Aug 8 15:08:45 2023
    
     Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
    
     ADR base = "/u01/app/oracle"
     adrci> show base
     ADR base is "/u01/app/oracle"
     adrci> set base /u01/app/oracle
     adrci>
    
  2. Get and Set Home.

     adrci> show home
     ADR Homes:
     diag/rdbms/cdb1/cdb1
     diag/tnslsnr/orcl/listener
     adrci> set homepath diag/rdbms/cdb1/cdb1
     adrci>
    
  3. Get and Set Control Policy.

     adrci> show control
    
     ADR Home = /u01/app/oracle/diag/rdbms/cdb1/cdb1:
     *************************************************************************
     ADRID                SHORTP_POLICY        LONGP_POLICY
     -------------------- -------------------- --------------------
     1467330218           720                  8760
    
     adrci> set control (SHORTP_POLICY = 360)
     adrci> set control (LONGP_POLICY= 2190)
    
0
Subscribe to my newsletter

Read articles from Martyn Rangel Figueiredo directly inside your inbox. Subscribe to the newsletter, and don't miss out.

Written by

Martyn Rangel Figueiredo
Martyn Rangel Figueiredo