While importing a dump into our 11g database, we got the below error.   impdp dumpfile=test1.dmp logfile=imp1.log directory=t Import: Release 11.2.0.4.0 – Production on Mon Jan 23 08:57:03 2017 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Username: / AS SYSDBA Connected to: Oracle Database 11g Enterprise Edition Release […]

While truncating a table in database, might face the error ORA-02266 unique key error.   PROBLEM: SQL> truncate table DBACLASS.AAF_USER; truncate table DBACLASS.AAF_USER * ERROR at line 1: ORA-02266: unique/primary keys in table referenced by enabled foreign keys   SOLUTION: The primary key in the table( which we are truncating) , seems to be referring […]

               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 => ‘[email protected]’, recipients => ‘[email protected]’, 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 […]