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