What is Undo ? Undo records are used to: Oracle Database creates and manages information that is used to roll back, or undo, changes to the database. Such information consists of records of the [...]

What is a Redo log corruption? In the Oracle RDBMS environment, redo logs comprise files in a proprietary format which log a history of all changes made to the database. Each redo log file [...]

I encounter the looping chain of synonyms error Reason:- ORA-01775: looping chain of synonyms – Basically means that you created a synonym that points to another object in a circle. In order to [...]

Sometimes You can get “ORA-12609: TNS: Receive timeout occurred ” error. Details of error are as follows. ORA-12609: TNS: Receive timeout occurred Cause: The receive or read operation did not [...]

EM Incident: Warning:New: – Agent resident memory utilization in KB is   1. ./emctl stop agent Ensure no EMAgent process is running with the following commands: [...]

ORA-01552: cannot use system rollback segment for non-system tablespace “TBS Name”   ORA-01552: cannot use system rollback segment for non-system tablespace "string" Cause: Tried to use the [...]

Error:- While the RMAN Active Duplicate is initiated, the rman job failed with the below errors, RMAN-03009: failure of backup command on C1 channel ORA-17628: Oracle error 19505 returned by [...]

ERROR:- SQL> create spfile from pfile; create spfile from pfile * ERROR at line 1: ORA-01078: failure in processing system parameters ORA-32003: error occured processing parameter [...]

Cause: After installing grid,i cant start asm resource [oracle@dbadb01 ~]$ srvctl start asm PRCR-1001 : Resource ora.asm does not exist Check the resource status [oracle@dbadb01 ~]$ crsctl stat [...]

While trying to open one pluggable database, I got the following errors: Background: While installing Apex 20.1 in one PDB, and while being very close to the installation completion, the session [...]