While connecting to catalog and running rman script, you may face below error. ERROR: RMAN-06429: TARGET database is not compatible with this version of RMAN RMAN-06618: RMAN client and database release mismatch; indicated database release is 12.1.0.2   Solution: […]

   From 12c onwards, after applying patch, as part of post patching activity, we need to run datapatch utility. If you have applied javam patch in the ORACLE_HOME, then while running datapatch you will face below error. READ ALSO : Apply javam patch in oracle Adding patches to installation queue and performing prereq checks… Installation […]

While running the opatchauto   command in oracle grid you may face the jdk version error as below. root # /crsapp/app/oracle/product/grid12c/OPatch/opatchauto apply /softdump/12C_GRIDSOFT/PATCH/22191349 -analyze -ocmrf /softdump/12C_GRIDSOFT/PATCH/grid.rsp OPatch Automation Tool Copyright (c)2014, Oracle Corporation. All rights reserved. OPatchauto Version : 12.1.0.1.10 OUI Version : 12.1.0.2.0 Running from : /crsapp/app/oracle/product/grid12c opatchauto log file: /crsapp/app/oracle/product/grid12c/cfgtoollogs/opatchauto/22191349/opatch_gi_2016-04-06_09-27-57_analyze.log NOTE: opatchauto is […]

                                    ORA-00027: cannot kill current session , error comes, when you are trying to kill your current session,which is not allowed.  EXAMPLE: Get the sid and serial# for the current session. SQL> select username,inst_id, sid, serial# FROM gV$SESSION WHERE […]

                    While setting attribute on a ASM diskgroup, we got below error. oracle@crmcpredb1:~$ echo $ORACLE_SID +ASM1 oracle@crmcpredb1:~$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Fri Sep 16 11:19:25 2016 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition […]

                              You may face RMAN-20035: invalid high RECID  after connecting to catalog database.   executing command: SET COMMAND ID starting full resync of recovery catalog RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of set command at […]

If the java component is corrupted, then while executing java related packages, you may face below error. select dbms_java.longname(‘TEST’) from dual; select dbms_java.longname(‘TEST’) from dual * ERROR at line 1: ORA-29516: Aurora assertion failure: Assertion failure at eox.c:359 Uncaught exception Root of all Java exceptions: java.lang.UnsatisfiedLinkError sun.net.PortConfig.getLower0 ORA-06512: at “SYS.DBMS_JAVA”, line 139 Solution: Follow below […]

While dropping an index, if you are facing ORA-08104 error, then you need to clean it using dbms_repair   Problem: SQL> drop index eric_icmsprod.SOTRAN00_IDX1; drop index eric_icmsprod.SOTRAN00_IDX1 * ERROR at line 1: ORA-08104: this index object 94771 is being online built or rebuilt Solution: — check the object_id SQL> select obj# ,name from obj$ where […]

                                   While doing expdp  the dumpfile to a NFS mount point, you may receive below error. Error: Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, […]

     While opening the database , if you are getting below ORA-0600 error ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr] metalink – 1296264.1 Problem: SQL>startup ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORACLE instance started. Total System Global Area 8754618368 bytes Fixed Size                  4646288 bytes Variable Size            4160756336 bytes Database Buffers         4429185024 bytes Redo Buffers              160030720 bytes […]