Category Archives: Oracle OPatch

PRVG-2027 : Owner of file “filename” is inconsistent across nodes.

CVU (Cluster Verification Utility) logged multiple PRVG-2027 errors in CRS alret log. This environment was recently patched with latest PSU, which failed while applying changes to GMIR. $GRID_HOME/bin/crsctl binary ownership should be root:dba. db01:+ASM3:/u01/app/oracle>ls -al /u01/product/12.1.0.2/grid/bin/crsctl -rwxr-xr-x 1 oracle dba … Continue reading

Posted in Oracle Administration, Oracle OPatch | Tagged , , , , | Leave a comment

PRVG-2029 : Octal permissions of file “filename” are inconsistent across nodes

Following entries were logged in CRS/GRID alert.log 2016-10-23 16:24:49.048 [SRVM(4849748)]CRS-10051: CVU found following errors with Clusterware setup : PRVG-2029 : Octal permissions of file “/u01/product/12.1.0.2/grid/lib/libccme_asym.so” are inconsistent across nodes. [Found = “{0644=[db01], 0755=[db02]}”] PRVG-2029 : Octal permissions of file “/u01/product/12.1.0.2/grid/lib/libccme_base.so” … Continue reading

Posted in Oracle OPatch | Tagged , | Leave a comment

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 … Continue reading

Posted in datapatch issues, Oracle Administration, Oracle OPatch | Tagged , , | Leave a comment

datapatch failing with ORA-27477: “SYS”.”LOAD_OPATCH_INVENTORY_X” already exists

datapatch is failing with ORA-27477, due to existing job_name in dba_scheduler_jobs 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 12:55:45 2016 Copyright (c) 2016, Oracle. All rights reserved. Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_3997884_2016_10_25_12_55_45/sqlpatch_invocation.log Connecting to database…OK Bootstrapping … Continue reading

Posted in datapatch issues, Oracle Administration, Oracle OPatch | Tagged , , | Leave a comment

/tmp/CVU_1x.x.x.x.x_oracle/exectask: not found

After few failed execution of opatchauto, for current run I started getting “/tmp/CVU_12.1.0.2.0_oracle/exectask.sh -getver”. The output from the command was “/tmp/CVU_12.1.0.2.0_oracle/exectask.sh[22]: /tmp/CVU_12.1.0.2.0_oracle/exectask: not found” Looks like after earlier failures, it did not cleanup the directories/flies and this opatchauto run was … Continue reading

Posted in Oracle OPatch | Tagged , , , , | Leave a comment

OPatch 12c: emocmrsp missing from OPatch/ocm/bin

So far while applying PSU or one off patches, we use to pass -ocmrf parameter.  I could not think of a scenario where we are going to expose database servers to external world. Before applying latest PSU, I downloaded latest … Continue reading

Posted in Oracle One-Off Patch, Oracle OPatch, Oracle PSU | Tagged , , | Leave a comment