ORA-30041: Cannot Grant Quota On The Tablespace

We are going to learn about the ORA-30041: Cannot Grant Quota On The Tablespace. This post has mentioned about the steps with cause list. Being human we all know on thing have different accept in the same manner we have one error but the different cause in a different way. PROBLEM: Granting tablespace quota to a user is […]

Read More

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

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