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 […]

            While starting DB instance below error coming because of less memory allocated to oracle user at OS level. ORA-27102: out of memory SVR4 Error: 12: Not enough space Additional information: 1671 Additional information: 16106127360 Additional information: 6291456000   Solution: If Oracle DB version is 12.1.0.2 or later use below […]

         While creating a catalog for the database, received below error. RMAN-07539: insufficient privileges to create or upgrade the catalog schema   RMAN> connect target sys/oracle#1234@ARCDB connected to target database: ARCDB (DBID=605774762) RMAN> connect catalog RMAN_st/rman@catlogdb connected to recovery catalog database RMAN> create catalog RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS […]