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

How to use Catalog start with command

Recovery Manager(RMAN) is an Oracle Database client that performs backup  and recovery tasks on your databases and automates administration of your backup strategies. It greatly simplifies backing up,restoring and recovering database files. If you have backup files in non-FRA location  , you can catalog your backup using catalog start with command of RMAN. Note : […]

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

Read More

Storage Volumes and File System Layout in Oracle Cloud

This section provides information about the storage volumes and file system layout of a newly created database deployment on Oracle Database Cloud Service. Compute Cloud Service Storage Volumes When a Database Cloud Service deployment is created using the Oracle Database Cloud Service service level, the following storage volumes are created. Storage Volume Description bits 60 GB volume completely […]

Read More

Explain usage of different users in Oracle Cloud

This article provides information about Linux user accounts that are provisioned on Oracle Database Cloud Service. Every Database Cloud Service compute node is provisioned with the following operating system user accounts. Both compute nodes are provisioned with the following operating system user accounts. opc: The system administrator account you use with the sudo command to perform operations that […]

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