Monday, November 14, 2011

ADRCI error - DIA-48448: This command does not support multiple ADR homes


While running ADRCI in a box where multiple Oracle instances are installed; comes with below error.

adrci> show control
DIA-48448: This command does not support multiple ADR homes

Reason is existence of multiple oracle database instances/ASM/Listener homes etc. Solution is to set the ADRCI home for the instance you want to operate.
adrci> show homes
ADR Homes:
diag/rdbms/DBRAC/DBRAC1
diag/tnslsnr/DBRAC1/listener
diag/asm/+asm/+ASM1

adrci> SET HOME diag/rdbms/DBRAC/DBRAC1

Now ADRCI can operate on the HOME we've selected.

6 comments:

Unknown said...

thanks, this helped.

Ferdous Nadvi said...

Appreciate your feedback. Good to know that it helped.

Bloggsi said...

thanks for the post. saved me time

Unknown said...

Great. Your article really helped me. Thank you so much

Unknown said...

This was a time saver - thank you for sharing.

NAJLAA said...

DIDN'T WORK WITH ME