Executing datapatch -verbose , shows : execute failed: ORA-20006: Number of RAC active instances and opatch jobs configured are not same (Doc ID 1674566.1)

Last updated on JUNE 07, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Information in this document applies to any platform.

Symptoms

Symptoms 1

Performing the Post Patch steps of the PSU patch on a RAC Database.


Executing the datapatch -verbose , fails with following errors:

oracle@cltlcopr1:[/oracle/database/12.1.0/OPatch]: ./datapatch -verbose
SQL Patching tool version 12.1.0.1.0 on Mon May 5 16:40:33 2014
Copyright (c) 2014, Oracle. All rights reserved.

Connecting to database…OK
Determining current state…
Currently installed SQL Patches:
PDB CDB$ROOT:
PDB PDB$SEED:
PDB PRD_GOLDCP:
PDB QUARTZDB:
PDB CARDDB:
DBD::Oracle::st execute failed: ORA-20006: Number of RAC active instances and opatch jobs configured are not same
ORA-06512: at “SYS.DBMS_QOPATCH”, line 1007
ORA-06512: at line 4 (DBD ERROR: OCIStmtExecute) [for Statement "DECLARE
x XMLType;
BEGIN
x := dbms_qopatch.get_pending_activity;
? := x.getStringVal();
END;" with ParamValues: :p1=undef] at /oracle/database/12.1.0/sqlpatch/sqlpatch.pm line 1227.

 

Symptoms 2

datapatch fails with prereq failures

./datapatch
SQL Patching tool version 12.1.0.2.0 on Wed Jul 1 17:07:07 2015
Copyright (c) 2015, Oracle. All rights reserved.

Connecting to database...OK

Queryable inventory could not determine the current opatch status.
Execute 'select dbms_sqlpatch.verify_queryable_inventory from dual' and/or check the invocation log
/u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_17491_2015_07_01_17_07_07/sqlpatch_invocation.log for the complete error.

Prereq check failed, exiting without installing any patches.

Please refer to MOS Note 1609718.1 and/or the invocation log
/u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_17491_2015_07_01_17_07_07/sqlpatch_invocation.log  for information on how to resolve the above errors.

SQL Patching tool complete on Wed Jul 1 17:07:11 2015

 

Error when following SQL statements is executed

SQL>select dbms_sqlpatch.verify_queryable_inventory from dual;

VERIFY_QUERYABLE_INVENTORY
ORA-20006: Number of RAC active instances and opatch jobs configured are not same


SQL>select dbms_qopatch.get_pending_activity from dual;

ORA-20006: Number of RAC active instances and opatch jobs configured are not same
ORA-06512: at "SYS.DBMS_QOPATCH", line 1199

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms