ERROR: No Checkpoint Table Specified For ADD REPLICAT

In this post, we are going to have look at Goldengate issue. While adding the replicate, you may get the below error. GGSCI (sec75-2) 2> add replicat LOYTSTR, exttrail /ggatebss/oradata/RBM12C/R4 ERROR: No checkpoint table specified for ADD REPLICAT. Solution: Checkpoint table needs to be created on the replication side. 1. Login to ggsci with dblogin […]

Read More

ORA-00059: Maximum Number Of DB_FILES Exceeded

While adding new datafile, you may face below error. Problem: ALTER TABLESPACE TS_LOYALTY_DATA add datafile ‘+DATA’ size 10g auto extend on next 500M * ERROR at line 1: ORA-00059: maximum number of DB_FILES exceeded   Solution: Check the db_files parameter in database SQL> show parameter db_files db_files integer 200 — Check the total number of […]

Read More

RMAN-07539: Insufficient Privileges To Create Or Upgrade The Catalog Schema

While creating a catalog for the database, received below error. RMAN-07539: insufficient privileges to create or upgrade the catalog schema RMAN> connect target sys/oracle#1234@ARCDB connected to target database: ARCDB (DBID=605774762) RMAN> connect catalog RMAN_st/rman@catlogdb connected to recovery catalog database RMAN> create catalog RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-07539: insufficient […]

Read More

ORA-27102: Out Of Memory While Starting DB Instance

We are going to have look at OS level error. As we must know while starting DB instance below error coming because of less memory allocated to oracle user at OS level. ORA-27102: out of memory SVR4 Error: 12: Not enough space Additional information: 1671 Additional information: 16106127360 Additional information: 6291456000   Solution: If Oracle […]

Read More

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-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

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