We have recently upgraded our database from 11g to 12c. And when one of the developer ran some job, the job got killed and got the below error in log. These jobs were running fine in 11g without any issues. ORA-00028: your session has been killed ORA-04036: PGA […]

      While starting a database in RAC, either using startup or srvctl , got error  ORA-01102: cannot mount database in EXCLUSIVE mode   Solution: This error comes, when cluster_database parameter is set to false. Change it to TRUE and try to start again.   startup nomount alter system set cluster_database=TRUE scope=spfile sid=’*’; shutdown […]

  While creating an index or doing DDL change on a table, getting resource busy error.   PROBLEM: SQL> create index IND_TEST on DBATEST ( OBJECT_ID); create index IND_TEST on DBATEST ( OBJECT_ID) * ERROR at line 1: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired   Solution: There are some other […]

           While sending mail using utl_mail or utl_stmp in oracle 11g, you may get access denied error: begin utl_mail.send(sender => ‘admin@dbaclass.com’, recipients => ‘admin@dbaclass.com’, subject => ‘MAIL from ADMIn of dbaclass’, message => ‘Do visit dbaclass’); end; / * ERROR at line 1: ORA-24247: network access denied by access control list […]

   While creating a composite index in the oracle database, got SQL> create index EMP_TAB_IDX1 on EMP_TAB ( EMPNAME,LOCATION,DEPT); create index EMP_TAB_IDX1 on EMP_TAB ( EMPNAME,LOCATION,DEPT) * ERROR at line 1: ORA-01450: maximum key length (6398) exceeded PROBLEM: SQL> create index EMP_TAB_IDX1 on EMP_TAB ( EMPNAME,LOCATION,DEPT); create index EMP_TAB_IDX1 on EMP_TAB ( EMPNAME,LOCATION,DEPT) * ERROR […]

    While importing in an oracle 12c database, got below error: ERROR:   impdp dumpfile=teset2.dmp logfile=imp_teset2.lod directory=ODSFINAL remap_schema=TEST:CRMB Import: Release 12.1.0.2.0 – Production on Fri Jan 13 00:37:12 2017 Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved. Username: / as sysdba Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – […]

            While putting the database in hot backup mode  , below error came. ORA-01123: cannot start online backup; media recovery not enabled   PROBLEM: SQL> alter database begin backup; alter database begin backup * ERROR at line 1: ORA-01123: cannot start online backup; media recovery not enabled SOLUTION: This error […]

       While dropping a diskgroup, error may come like ORA-15073: diskgroup mounted by another instance.   Problem: SQL> drop diskgroup NSMREDOA including contents; drop diskgroup NSMREDOA including contents * ERROR at line 1: ORA-15039: diskgroup not dropped ORA-15073: diskgroup NSMREDOA is mounted by another ASM instance   Solution: For rac with multiple node, you […]

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