Ameer Khan

No ADR homes are set

Recently for one my customer, I upgraded database from 12c to 19c. So after upgrade when I tried to use adrci utility It showed me “No ADR base is set” message

[oracle@oda02 ~]$ adrci

ADRCI: Release 19.0.0.0.0 – Production on Sun Nov 20 12:12:58 2022

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

No ADR base is set

adrci> show homes

No ADR homes are set

Solution:-

The reason behind above message is adrci utility is unable to find any information about ADR base .

Create following directory in new oracle home

[oracle@oda02 ~]$ echo $ORACLE_HOME/u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1 [oracle@oda02 dbhome_1]$ mkdir -p $ORACLE_HOME/log/diag

Now copy the following file from old ORACLE_HOME i.e. 12c home in our case

[oracle@oda02$ cd /u01/app/odaorahome/oracle/product/12.1.0.2/dbhome_1/log/diag/

 [oracle@oda02$ cp adrci_dir.mif $ORACLE_HOME/log/diag/

Now lets check ADR home using adrci utility

[oracle@oda02 diag]$ adrci

ADRCI: Release 19.0.0.0.0 – Production on Sun Nov 20 12:23:30 2022

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

ADR base = “/u01/app/odaorabase0”

adrci> show homes

ADR Homes:

diag/rdbms/orcl/orcl

Now we are able to see the homes in ADR base.