Monthly Archives: October 2016

ORA-00704: bootstrap process failure

Bootstarp error indicates version mismatch between datafile headers and oracle binaries, which are being used to start the database. I’m starting the database using Oracle 12.1.0.2 binaries, where as datafiles are from 11.2.0.4. $ sqlplus / as sysdba SQL*Plus: Release … Continue reading

Posted in Oracle Administration, Oracle Database Upgrade, Startup issues | Tagged , , , | Leave a comment

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

ORA-06598: insufficient INHERIT PRIVILEGES privilege

Recently while upgrading 11204 database to 12102, got following error. XDB SGA reset to NULL. Tue Oct 25 05:37:34 2016 Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl01/trace/orcl01_ora_5898844.trc: ORA-00604: error occurred at recursive SQL level 1 ORA-06598: insufficient INHERIT PRIVILEGES privilege ORA-06512: at “XDB.DBMS_CSX_INT”, … Continue reading

Posted in 12c Upgrade issues, Oracle Bugs | Tagged , , , | Leave a comment