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 JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.17.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
Datapatch Execution in a RAC Environment fails with below message-
oracle@RACNODE1:/home/oracle$datapatch -verbose
SQL Patching tool version 19.18.0.0.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...
done
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:
Binary registry:
19.18.0.0.0 Release_Update 230129075550: Not installed on nodes RACNODE2,RACNODE3 <<<<<<<<<<<<<
SQL registry:
Applied 19.16.0.0.0 Release_Update 220707111242 successfully on 25-NOV-22 02.05.39.728005 AM
Adding patches to installation queue and performing prereq checks...done
Installation queue:
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
oracle@RACNODE1:/home/oracle$
SQL Patching tool version 19.18.0.0.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...
done
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:
Binary registry:
19.18.0.0.0 Release_Update 230129075550: Not installed on nodes RACNODE2,RACNODE3 <<<<<<<<<<<<<
SQL registry:
Applied 19.16.0.0.0 Release_Update 220707111242 successfully on 25-NOV-22 02.05.39.728005 AM
Adding patches to installation queue and performing prereq checks...done
Installation queue:
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
oracle@RACNODE1:/home/oracle$
Changes
In this case, Same Patches have been applied to all RAC Nodes as evident from opatch lspatches or lsinv output comparison
Cause
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
Symptoms |
Changes |
Cause |
Solution |