ORA-00600 Kcratr_nab_less_than_odr While Starting The Database

While opening the database, if you are getting below ORA-0600 error. Whenever an ORA-0600 error is raised, a trace file is generated and an entry is written to the alert.log with details of the trace file location. As of Oracle 11g, the database includes an advanced fault diagnosability infrastructure to manage trace data.  Problem: ORA-00600: […]

Read More

ORA-27054: NFS File System Where The File Is Created While Expdp

This post explains about the steps which is used by DBA while facing error ORA-27054. For beginners, we have few lines that explain about the technical view of NFS. Network File System (NFS) is a distributed file system protocol originally developed by Sun Microsystems in 1984, allowing a user on a client computer to access files over […]

Read More

ORA-01452: Cannot CREATE UNIQUE INDEX; Duplicate Keys Found

Problem:- While creating the unique index on a table, got below error. SQL> create unique index TEST_IDX on TEST5(EMPNO); create unique index TEST_IDX on TEST5(EMPNO) * ERROR at line 1: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found Cause:- You tried to execute a CREATE UNIQUE INDEX statement on one or more columns that contain duplicate values. Solution:- […]

Read More

ORA-29516: Aurora Assertion Failure: Assertion Failure

  This post is for steps which solve ORA-29516.   If the java component is corrupted, then while executing java related packages, you may face below error. Cause You have set additional mount options on the shared memory device, /dev/shm, other than just the option named defaults. Problem: select dbms_java.longname(‘TEST’) from dual; select dbms_java.longname(‘TEST’) from dual […]

Read More

ORA-19588: Archived Log RECID Is No Longer Valid

As we know each and every problem have solutions. Let’s have a solution to the Error:- ORA-19588. PROBLEM: While taking RMAN backup, got below error. RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on t4 channel at 05/01/2017 03:18:01 ORA-19588: archived log RECID 143154 STAMP 942443843 is no […]

Read More

RMAN-20035: Invalid High RECID In Rman Catalog

We are going to learn about the steps which we use to solve issues RMAN-20035.      we 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 […]

Read More

ORA-00027: Cannot Kill Current Session

A login session is one of the most common problems while we are working on the huge amount of data with multiple users.  This post explains about those steps which we use to kill the session.   ORA-00027: cannot kill the current session, the error comes, when you are trying to kill your current session, which […]

Read More

Generic error(Failed Jdk Version Is Incompatible.Please Use A Jdk Version With Opatchauto)

While running the opatchauto command in oracle grid you may face the jdk version error as below. We are going to learn about the steps which we use to solve this issue. 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 […]

Read More