ADR – Automatic Diagnostic Repository is a file-based directory structure formed in a hierarchical way to store diagnostic information of the database.

For each database instance, ADR directories are created and maintained.

In 12c release two, it is not changed. Hence we are having one instance for root container only. ADR directories are managed for that instance only.

Connect to ADRCI prompt and check available homes.

[oracle@localhost dbs]$ adrci

ADRCI: Release - Production on Wed Jul 25 06:05:25 2018

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

ADR base = "/u01/oracle"
adrci> show homes
ADR Homes: 

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.