My Oracle Support Banner

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 OCTOBER 06, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 19.17.0.0.0 and later
Information 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$

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.