Skip to content

How to Resolve DIA-48448: This command does not support multiple ADR homes

  • by

DIA-48448

Tried to purge trace files in ADRCI, but it failed with DIA-48448

adrci> purge -age 10080
DIA-48448: This command does not support multiple ADR homes

Even show control threw the error.

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

DIA-48448 means that there're multiple ADR homes in current session, the utility does not know which ADR home you want to perform. That is to say, only one ADR home can be used at a time to perform commands in ADRCI.

Solution

Let's see what ADR homes we have.

adrci> show homes
ADR Homes:
diag/asm/+asm/+ASM1
diag/asmcmd/user_grid/primary01
diag/asmcmd/user_oracle/primary01
diag/clients/user_grid/host_220395685_110
diag/clients/user_root/host_220395685_110
diag/crs/primary01/crs
diag/kfod/primary01/kfod
diag/tnslsnr/primary01/asmnet1lsnr_asm
diag/tnslsnr/primary01/listener
diag/tnslsnr/primary01/listener_scan1
diag/tnslsnr/primary01/listener_scan2
diag/tnslsnr/primary01/listener_scan3

As you can see, there're many ADR home in ORACLE_BASE. To solve DIA-48448, we should explicitly set only one ADR home in order to perform the command.

adrci> set home diag/tnslsnr/primary01/listener
adrci> purge -age 10080
adrci>

By the way, SHOW HOME, SHOW HOMES and SHOW HOMEPATH are synonyms, there's no difference among them.

adrci> help SHOW HOME

  Usage: SHOW HOMES | HOME | HOMEPATH
          [-ALL | -base <base_str> | homepath_str1 ... ]

  Purpose: Show the ADR homes in the current ADRCI session.

  Options:
    [-ALL]: If it is specified, the ADR homes under the current base
    setting will be displayed.
    [-base <base_str>]: It is for showing all the homes under <base_str>,
    where <base_str> is a system-dependent directory path string.
    <homepath_str1 ...>: The paths of the home, relative to the ADR base.

  Examples:
    show homes -all
    show homes -base /temp
    show homes rdbms
    show homes

Leave a Reply

Your email address will not be published.