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: internal error code, arguments: [kcratr_nab_less_than_odr]

Solution:

1. Check the Alert Log

The alert log may indicate additional errors (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 a computer network much like local storage is accessed. NFS, like many other protocols, builds on the Open Network (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:-

Find the duplicate rows in the table and delete them.

Use below script to delete the duplicate rows

REM This (more...)

ORA-08104: This Index Object Is Being Online Built Or Rebuilt

This post is about “ORA-08104”.  We are going t learn how to solve this issue. Steps are mention 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

Cause

you have not installed the patch for Bug 3805539 or (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
*
ERROR at line 1:
ORA-29516: Aurora assertion failure: Assertion failure at eox.c:359
Uncaught exception Root of (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 longer valid

Cause: The indicated record has been marked as deleted. This indicates that the corresponding file has either been (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 07/27/2016 10:54:19
RMAN-03014: implicit resync of recovery catalog failed

on default channel at 07/27/2016 10:54:19
RMAN-20035: invalid (more...)