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.
No comments:
Post a Comment