ORA-48318: ADR Relation [HM_FINDING] of version=5 cannot be supported

In Oracle databases, when the downgrade operation or “migrate schema” operation is done through adrci, when using the adrci, ORA-48318 error is received when the job named “SYS”.”DRA_REEVALUATE_OPEN_FAILURES” runs. The version value in error may be different.

For the solution of the problem, while the database instance is stopped, ADR Home directory must be deleted and the instance must be opened. When you open the instance, ADR home directory automatically will be created in the relevant version.

Find the ADR Home directory

Stop Oracle Instance

Stop the relevant instance. You can stop it with sqlplus or srvctl.

Delete ADR Home Directory

Delete the ADR Home directory with the root user.

Start Oracle Instance

Then start the instance.

These operations should be done in all instances for RAC databases. When the instance starts, ADR Home will be created in the version it should be and no errors will be received.

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

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