ORA-30032: The Suspended (Resumable) Statement Has Timed Out

PROBLEM: While doing a transaction, it was hung for few seconds and got the below error. SQL> create TABLE TEST_3 as select * from dba_objects; create TABLE TEST_3 as select * from dba_objects * ERROR at line 1: ORA-30032: the suspended (resumable) statement has timed out   CAUSE & SOLUTION: Let’s check the alert log: […]

Read More

ORA-00350: Log 4 Of Instance Needs To Be Archived

PROBLEM: After restoring a RAC database to a standalone database through RMAN, we tried to drop the redolog groups belongs to thread 2. We hit the below error.  SQL> alter database drop logfile group 8; alter database drop logfile group 8 * ERROR at line 1: ORA-00350: log 4, for instance, DBATST2 (thread 2) needs […]

Read More

ORA-02020: Too Many Database Links In Use

PROBLEM: While querying against a database link, got below error. select sysdate from dual@DB5 * ERROR at line 1: ORA-02020: too many database links in use CAUSE & SOLUTION: open_links parameter control, the number of database links each session can use without closing it. If you access a database link in a session, then the link […]

Read More

ORA-20002: Version Of Statistics Table SCOTT.STATS Is Too Old

Being DBA we may face this error in many phase example while upgrading we face error while transferring stats from 10g to 11g, While importing a stats table in Oracle 12c, for which the stats export was done from 11g. We are focusing on this error.  While importing a stats table in Oracle 12c, for which […]

Read More

ORA-28014: Cannot Drop Administrative Users

PROBLEM: While dropping APEX user got below error in Oracle 12c, got below error.   SQL> drop user APEX_050000 cascade; drop user APEX_050000 cascade * ERROR at line 1: ORA-28014: cannot drop administrative users   SOLUTION:   set _oracle_script to TRUE and execute drop command as below. SQL> alter session set “_oracle_script“=true; Session altered SQL> drop user APEX_050000 […]

Read More

ORA-00392: Log 7 Of Thread 1 Is Being Cleared, Operation Not Allowed

We are posting this post to help you out on overcoming the error “ORA-00392: log %s of thread %s is being cleared, operation not allowed” while trying to open the database in RESETLOGS mode after an incomplete recovery. Here is what I came across while creating a database clone using the traditional RMAN backup restore and […]

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

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