after patching 19.10 patch on 2 node RAC - SQL prompt was showing 19.3

Environment :  2 node RAC which is running on Linux 8

We have successfully applied the patch p32226239_190000_Linux-x86-64.zip on Node1 on Grid Home as well as Oracle database home.

Even we have also successfully applied pacth on Grid Home, but while applying patch the patch on Oracle database home we got the error.

i.e. while connecting the database on node2,  we could see that the node2 is connecting to 19.3 instead of 19.10

Oracle version in the SQL plus command prompt does not match across the 2 nodes (Doc ID 2789512.1)

Oracle version does not match  in the SQL plus command prompt across the 2 nodes:

In the first node:

sqlplus / as sysdba

SQL*Plus: Release 19.10.0.0.0 - Production on Sun Jul 4 12:53:35 2021
Version 19.10.0.0.0

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


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.10.0.0.0

 

In the second  node:

sqlplus / as sysdba

SQL*Plus: Release 19.10.0.0.0 - Production on Sun Jul 4 12:53:35 2021
Version 19.10.0.0.0

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


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

 

==> The version is 19.10.0.0.0 in the first node  , and  19.3.0.0.0  in the second node.

CAUSE

The patching levels across the nodes is now consistent.

The lib and bin inconsistency was due to several reasons like:

-Network/OS issues

-OS resource starvation e.g. extremely high cpu usage, paging/swapping, scheduling delays etc.

-Stuck process/thread

After patching, the  binary is not consistent across the nodes


ls -ltr $ORACLE_HOME/lib/libsqlplus*


size differs across the nodes

SOLUTION

 
Please follow the below steps in the problem node, after ensuring that the patching levels across the nodes is the same :

1)Stop the instances

2)<Oracle Home>/bin/relink all    as rdbms owner

3)Start the instances