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 12.1.0.2.0 - 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: diag/rdbms/mycdb/mycdb diag/clients/user_oracle/host_61728193_80 diag/clients/user_oracle/host_61728193_107 diag/tnslsnr/localhost/listener121 diag/tnslsnr/localhost/listener diag/tnslsnr/localhost/listener1 adrci>
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: https://t.me/helporacle
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp
