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

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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.