WARNING: Oracle executable binary mismatch detected.

In alert log file message showing repeatedly as mismatch detected on Oracle executable.

WARNING: Oracle executable binary mismatch detected.

Binary of new process does not match binary which started instance

issue alter system set "_disable_image_check" = true to disable these messages

Fri Nov 26 13:46:00 2021

To implement the solution, please use one of the following solutions

Solution 1.     alter system set "_disable_image_check" =true;

Solution 2.     shutdown and start your instances issue will be resolved.

The alert log clearly says that there is a mismatch between the binary that started the instance and the binary that was used to attach to the instance when the error happened.

If the issue still persists even after applying above action plan, then it would be a good idea to relink Oracle binaries by referring below document-

You may re-link oracle binary using reference Doc ID 1467060.1.

Shutdown all software running out of that oracle home and execute re-link all. 

$ORACLE_HOME/bin/relink all

How to drop oracle database without DBCA

To drop,remove or delete entire oracle database while doing cloning,refreshing we need to follow the below steps to complete. Connect oracle database using sys user with sysdba and check whether database open in read write mode. 

[oracle@abcapps trace]$ export ORACLE_SID=DEV

[oracle@abcapps trace]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Nov 2 09:51:16 2021

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name,open_mode from v$database;

NAME      OPEN_MODE

--------- --------------------

DEV       READ WRITE

Shutdown database normally.

SQL> shut immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

Startup database in mount mode.

SQL> startup mount;

ORACLE instance started.

Total System Global Area 1.6034E+10 bytes

Fixed Size                  2269072 bytes

Variable Size            2248147056 bytes

Database Buffers         1.3757E+10 bytes

Redo Buffers               26480640 bytes

Database mounted.

Enable restricted session or 'startup mount exclusive restrict;'

SQL>alter system enable restricted session;

or

SQL>startup mount exclusive restrict;

System altered.

Execute the drop database command to drop entire database with datafiles,control files and logfiles.

SQL> drop database;

Database dropped.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options