Posts

Showing posts from February, 2026

Oracle DBA - Basic Commands

ADRCI ·        command line interface for diagnostic utility ·        viewing diagnostics data like listener log , alert log ,incident and cor dump etc ·        creating incident packages Sl.No. Command Description 1. adrci> show base | set base /u01/app/grid Get/set current base location 2. adrci> show home | adrci> set homepath /u02/app/oracle List/Set ORACLE_HOME 3. adrci> show alert adrci> show alert -tail 100 View alert log 4. adrci> purge -age 600 -type ALERT adrci> purge -age 600 -type TRACE adrci> purge -age 600 -type incident adrci> purge -age 10080 -type cdump Purge alerts and trace files 5. adrci> show control — Get existing control policy adrci> ...