DIA-49803: Purge not possible due to incompatible schema version

This error indicates that there’s a schema version mismatch between the ADRCI (Automatic Diagnostic Repository Command Interpreter) utility and the diagnostic repository you’re trying to purge.

Technical Root Cause:

The error occurs because ADRCI checks the schema version of the diagnostic repository before performing operations. When the ADRCI utility’s expected schema version doesn’t match the actual repository schema version, Oracle prevents the operation to avoid data corruption.

Schema version check happens in:

• DBMS_HM package

• DBMS_DIAG internal packages

• ADR metadata tables

How to fix this issue ?

There is several solution for this issue. You can fix this issue easily as below steps :

[oracle@oradb2:/home/oracle]adrci

ADRCI: Release 12.2.0.1.0 - Production on Thu Nov 27 10:24:55 2025

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

ADR base = "/u01/app/oracle"

# list all adr homes 

adrci> show homes
ADR Homes: 
diag/apx/+apx/+APX2
diag/asm/+asm/+ASM2
diag/clients/user_oracle/host_2172273556_11
diag/clients/user_oracle/host_2172273556_80
diag/crs/oradb2/crs
diag/diagtool/user_oracle/host_2172273556_11
diag/rdbms/_mgmtdb/-MGMTDB
diag/rdbms/testdb/TESTDB2
diag/rdbms/testvt/TESTVT2
diag/tnslsnr/oradb2/asmnet1lsnr_asm
diag/tnslsnr/oradb2/listener
diag/tnslsnr/oradb2/listener_scan1
diag/tnslsnr/oradb2/listener_scan2
diag/tnslsnr/oradb2/listener_scan3
diag/tnslsnr/oradb2/mgmtlsnr
adrci> 
adrci> 

# set adr home which error occurs on it  
adrci> set home diag/rdbms/test/TEST2

# check current home version
adrci> show version schema
,Schema version (on-disk): 80
Schema version (library): 107
adrci> 

# migrate  current home to the new version
adrci> migrate schema
Schema migrated.

# check current home version again
adrci> show version schema
Schema version (on-disk): 107
Schema version (library): 107
adrci> 
adrci> 

If the issue persists, consider opening a service request with Oracle Support, as this may indicate a more complex version compatibility issue.