Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is ORACLE_BASE and ADR how can I specify it during upgrades?

April 26, 2017adr specify upgrades

0

Posted

What is ORACLE_BASE and ADR how can I specify it during upgrades?

1 Answer

0

Posted

The Oracle installer requires that ORACLE_BASE is specified at the time of the 11g install. ORACLE_BASE is the root of both the Oracle software and database files as recommended by the Optimal Flexible Architecture (OFA). ADR or Automatic Diagnostic Repository is the single repository containing all diagnostic information. It is a replacement for the background, user, core dump destination parameters. It is specified by setting the diagnostic_destination parameter. DBUA will default to the ORACLE_BASE setting specified during the install of 11g R1 software. If you have to use a different value of ORACLE_BASE for your database upgrade you can specify ORACLE_BASE as an environment variable. Note that the diagnostic_dest parameter will default to ORACLE_BASE but this value can be changed at the time of upgrades.