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

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

db02:orcl01:/u01/product/12.1.0.2/database/OPatch>./datapatch -verbose
SQL Patching tool version 12.1.0.2.0 on Tue Oct 25 13:01:10 2016
Copyright (c) 2016, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_6619568_2016_10_25_13_02_22/sqlpatch_invocation.log
SQL Patching arguments:
verbose: 1
force: 0
prereq: 0
upgrade_mode_only:
oh:
bundle_series:
ignorable_errors:
bootstrap:
skip_upgrade_check:
userid:
pdbs:
Connecting to database…OK
catcon: ALL catcon-related output will be written to /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_6619568_2016_10_25_13_02_22/sqlpatch_catcon__catcon_6619568.lst
catcon: See /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_6619568_2016_10_25_13_02_22/sqlpatch_catcon_*.log files for output generated by scripts
catcon: See /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_6619568_2016_10_25_13_02_22/sqlpatch_catcon__*.lst files for spool files, if any
Bootstrapping registry and package to current versions…done
verify_queryable_inventory returned ORA-20006: Number of RAC active instances and opatch jobs configured are not same
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_6619568_2016_10_25_13_02_22/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_6619568_2016_10_25_13_02_22/sqlpatch_invocation.log
for information on how to resolve the above errors.
SQL Patching tool complete on Tue Oct 25 13:02:29 2016
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;
ERROR:
ORA-20006: Number of RAC active instances and opatch jobs configured are not same
ORA-06512: at “SYS.DBMS_QOPATCH”, line 1222
no rows selected
SQL> select NODE_NAME, INST_ID, INST_JOB from opatch_inst_job;
NODE_NAME INST_ID INST_JOB
—————– ———- ————————-
db01 2 Load_opatch_inventory_2
db02 1 Load_opatch_inventory_1
SQL> select job_name ,state from dba_scheduler_jobs where job_name like ‘%OPATCH%’ ;
JOB_NAME STATE
———————— —————
LOAD_OPATCH_INVENTORY_2 DISABLED

Delete all existing job entries

SQL> exec DBMS_SCHEDULER.DROP_JOB(‘LOAD_OPATCH_INVENTORY_2’);
PL/SQL procedure successfully completed.

Delete rows from opatch_inst_job

SQL> delete from opatch_inst_job;
2 rows deleted.
SQL> commit;
Commit complete.

Re-run datapatch

db02:orcl02:/u01/product/12.1.0.2/database/OPatch>./datapatch -verbose
SQL Patching tool version 12.1.0.2.0 on Tue Oct 25 13:06:59 2016
Copyright (c) 2016, Oracle. All rights reserved.
Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_5506020_2016_10_25_13_06_59/sqlpatch_invocation.log
Connecting to database…OK
Bootstrapping registry and package to current versions…done
Determining current state…done
Current state of SQL patches:
Bundle series PSU:
ID 161018 in the binary registry and not installed in the SQL registry
Adding patches to installation queue and performing prereq checks…
Installation queue:
Nothing to roll back
The following patches will be applied:
24006101 (Database Patch Set Update : 12.1.0.2.161018 (24006101))
Installing patches…
Patch installation complete. Total patches installed: 1
Validating logfiles…
Patch 24006101 apply: SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/24006101/20648640/24006101_apply_ORCL_2016Oct25_13_11_23.log (no errors)
SQL Patching tool complete on Tue Oct 25 13:18:34 2016
Advertisements
This entry was posted in datapatch issues, Oracle Administration, Oracle OPatch and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s