RAC : Datapatch says "Binary registry: Not installed on nodes RACNODE2,RACNODE3" and "No interim patches need to be rolled back", "No release update patches need to be installed", "No interim patches need to be applied"
(Doc ID 2964923.1)
Last updated on AUGUST 07, 2023
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
Datapatch Execution in a RAC Environment fails with below message-
SQL Patching tool version 184.108.40.206.0 Production on Sat Jul 15 02:36:43 2023
Copyright (c) 2012, 2023, Oracle. All rights reserved.
Log file for this invocation: /oracle/app/orabase/cfgtoollogs/sqlpatch/sqlpatch_6881972_2023_07_15_02_36_43/sqlpatch_invocation.log
Connecting to database...OK
Gathering database info...done
Bootstrapping registry and package to current versions...done
Determining current state...
Current state of interim SQL patches:
Interim patch 29213893 (DBMS_STATS FAILING WITH ERROR ORA-01422 WHEN GATHERING STATS FOR USER$ TABLE):
Binary registry: Not installed on nodes RACNODE2,RACNODE3 <<<<<<<<<<<<<
SQL registry: Not installed
Current state of release update SQL patches:
220.127.116.11.0 Release_Update 230129075550: Not installed on nodes RACNODE2,RACNODE3 <<<<<<<<<<<<<
Applied 18.104.22.168.0 Release_Update 220707111242 successfully on 25-NOV-22 02.05.39.728005 AM
Adding patches to installation queue and performing prereq checks...done
No interim patches need to be rolled back
No release update patches need to be installed
No interim patches need to be applied
SQL Patching tool complete on Sat Jul 15 02:37:37 2023
In this case, Same Patches have been applied to all RAC Nodes as evident from opatch lspatches or lsinv output comparison
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document