Undo Corruption in Oracle
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…
Read MoreRedo log corruption
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 consists of…
Read MoreORA-01775: looping chain of synonyms
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.…
Read MoreORA-12609: TNS: Receive timeout occurred 12 & 19c
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 complete within…
Read MoreAgent resident memory utilization in KB is
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: <AGENT_HOME>/bin>./emctl status agent $ps…
Read MoreORA-01552: cannot use system rollback segment for non-system tablespace, clone database
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 system rollback segment…
Read MoreRMAN-03009: ORA-17628:
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…
Read MoreUnknown Parameter Name ‘utl_file_dir’
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 ‘utl_file_dir’ LRM-00101: unknown parameter…
Read MorePRCR-1001 : Resource ora.asm does not exist
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 res -t…
Read MoreAlter Pluggable Database Open – (ORA-00604/ORA-01405) After Apex Installation
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…
Read More