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: