ADRCI incompatible schema version

This issue arises when migrating from Oracle 12.1 to 12.2.

I could not easily find the info how to fix this issue, so I’ll share it in case someone else stumbles upon it.

adrci> show log
DIA-48494: ADR home is not set, the corresponding operation cannot be done
adrci>

adrci> show homes
ADR Homes:
diag/netcman/hostname/cman_hostname.domainname
adrci>

adrci> set homepath diag/netcman/hostname/cman_hostname.domainname
adrci> purge -age 129600 -type ALERT
DIA-49803: Purge not possible due to incompatible schema version.

adrci> set homepath diag/netcman/hostname/cman_hostname.domainname
adrci> migrate schema
Schema migrated.
adrci> purge -age 129600 -type ALERT
adrci>

Done!

Leave a Reply

Your email address will not be published. Required fields are marked *