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

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

Oracle Infrastructure as a Service Cloud 2017 Implementation Essentials

Hi Readers Finally I’ve successfully passed 1Z0-337,  Oracle Infrastructure as a Service Cloud 2017 Implementation Essentials. It was almost more than 2 months that I’ve been preparing for this. The Exam contains 60 questions related to Compute, Container, Networking and Ravello Services. To earn this certification you need to get 70% marks. This was the result of […]

Read More

RMAN-06429: TARGET Database Is Not Compatible Version

This post is about to solve the issue RMAN-06429. While connecting to catalog and running rman script, you may face below error.  Whenever you connect to a database (rman version if different from source database version, in fact, rman version is higher than the source database) through RMAN using/without recovery catalog it fails with RMAN-06429: […]

Read More

ORA-02095: Specified Initialization Parameter Cannot Be Modified

As we know Troubleshooting is the process of identifying, planning and resolving a problem, error or fault within a software or computer system. It enables the repair and restoration of a computer or software when it becomes faulty, unresponsive or acts in an abnormal way. We are going to know the steps we use to resolve […]

Read More