Category Archives: Oracle Administration

Oracle Administration

ORA-00600: internal error code, arguments: [ksprcvsp:ksfdread_resilver]

On an Oracle 11204 restart environment, ASM spfile creation failed with create spfile=’+DATA5′ from pfile=’/u03/asmpfile.ora’ * ERROR at line 1: ORA-01078: failure in processing system parameters ORA-00600: internal error code, arguments: [ksprcvsp:ksfdread_resilver],[0x0A2435D48], [3], [0x7F710EE38000], [512], [], [], [], [], [], … Continue reading

Posted in Oracle Administration, Oracle ORA-600 errors | Tagged , , , | Leave a comment

ORA-00600: internal error code, arguments: [kzsrgpw]

Recently I started getting ORA-00600 error, while I was trying to connect  as $ sqlplus sys as sysdba SQL*Plus:Release 11.2.0.3.0 Production on Tue Jan 17 06:13:16 2017 Copyright (c) 1982, 2011, Oracle. All rights reserved. Enter password: ERROR: ORA-00600: internal … Continue reading

Posted in Oracle Administration, Oracle ORA-600 errors | Tagged , , , | Leave a comment

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

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

ORA-00600: internal error code, arguments: [kwqitnmphe:ltbagi]

Recently started seeing this error on few of the RAC environments. Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl01/trace/orcl01_q002_5570998.trc: ORA-00600: internal error code, arguments: [kwqitnmphe:ltbagi], [1], [0], [], [], [], [], [], [], [], [], [] As per metalink this is a known Bug 20987661 … Continue reading

Posted in 12c Upgrade issues, Oracle Administration, Oracle Bugs, Oracle ORA-600 errors | Tagged , | Leave a comment