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 |
Leave a Reply