Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
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
1 2 3 4 5 | SQL> select value from v$diag_info where name = 'ADR Home'; VALUE -------------------------------------------------------------------------------- /u01/app/oracle/diag/rdbms/orcl/ORCL1 |
Stop Oracle Instance
Stop the relevant instance. You can stop it with sqlplus or srvctl.
1 | srvctl stop instance -d ORCL -i ORCL1 |
Delete ADR Home Directory
Delete the ADR Home directory with the root user.
1 2 | [root@orcldb01 ~]# cd /u01/app/oracle/diag/rdbms/orcl/ [root@orcldb01 orcl]# rm -rf ORCL1/ |
Start Oracle Instance
Then start the instance.
1 | srvctl start instance -d ORCL -i ORCL1 |
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.
