DIA-49803: Purge not possible due to incompatible schema version
Error
Trying to purge oracle home get the error:
adrci> purge -age 8640
DIA-49803: Purge not possible due to incompatible schema version.
Cause
If you do manually upgrade the database, then the adrci version of schema is not matching with latest version of schema.
adrci> show version schema
Schema version (on-disk): 82
Schema version (library): 107
Solution
1. When you start the database from new home then it automatically fixed the issue.
2. If automatically issue is not fixed, then run the command MIGRATE SCHEMA from ADRCI console.
adrci>Migrate schema
-- For Oracle 18c
adrci> show version schema
Schema version (on-disk): 110
Schema version (library): 110
Example of migrate schema
adrci> migrate schema
DIA-48448: This command does not support multiple ADR homes
adrci> show homes
ADR Homes:
diag\clients\user_scott\host_1dsfer8fda_110
diag\clients\user_OracleServiceXE\host_1dsfer8fda_110
diag\rdbms\xe\xe
diag\tnslsnr\ORACLEHOST\listener
adrci> set home 3
adrci> show homes
ADR Homes:
diag\rdbms\xe\xe
adrci> migrate schema
Schema migrated.
Pingback: DIA-49803: Purge not possible due to incompatible schema version – ExadataBlogg