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 FEBRUARY 14, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.1 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A 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
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
Changes
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 |
| References |