Posts

Showing posts from November, 2018

ORACLE Database ADRCI

ADRCI is Automatic Diagnostic Repository Command Interpreter. Its command line tool to manage diagnostic data. Diagnostic data include alert log, trace file, dump, HM report and more. Automatic Diagnostic Repository ADR is file based repository for Oracle database diagnostic data. It stores alert log, core dump, health monitor reports. The same directory structure is used across multiple products of Oracle database like listener, CRS, ASM. ADRCI provide interactive mode, to launch it use adrci command. Make sure Set ORACLE_HOME and PATH variable properly. The relative location from where adrci launched that define behavior of it. If you launch adrci utility from perticular database diagnostic destination then home path set to that database by default. Using show control purge policy can be found. adrci> show control; ADR Home = /oracle/app/oracle/diag/rdbms/testdb/testdb: ************************************************************************* ADRID  SHO