ORA 02049: Distributed Transaction Timeout waiting for lock
ORA 02049: Distributed Transaction Timeout waiting for lock This error occurs when a session is trying to modify a table’s row in a remote database through a database link that…
Read MoreORACLE GOLDEN GATE ERROR OGG-00868
In this tutorial, we are going to learn about, “How to resolve this ERROR OGG-00868″ I got the below type of error while re-start the replicat in golden gate. I…
Read MoreASM Instance cloning using RMAN in same host
Description: In this article step by step Cloning the asm instance in same host.Earlier we use to clone database using rman backup. After adding the database service entry and restore…
Read MoreHow to fix INVALID status for RAC component in dba_registry
Before upgrade or after upgrade, database may show INVALID status for component Real Application Clusters in dba_registry as below . SQL> select comp_name,version,status from dba_registry; … Oracle Real Application…
Read MoreKinsing (kdevtmpfsi and dbused) malware in linux impacting oracle
Introduction: Do you know there is malware in Linux that impacts your Oracle Database and Oracle Applications environment? This malware impacting critical Linux/Oracle systems is by Kinsing. The Malware’s primary…
Read MoreHOW TO RESOLVE THE ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00704: bootstrap process failure ORA-39700: database must be opened with UPGRADE option
In this tutorial, we are going to learn about, “How to resolve these ORA ERRORS: ORA-01092, ORA-00704 and ORA-39700”. I got the below type of error while startup the database.…
Read MoreORA-65114: space usage in container is too high
ORA-65114: space usage in container is too high While an import for a pluggable database and it ran out of space so I tried to resize one of the datafile…
Read MoreScript to Detecting Unindexed Foreign Keys
SELECT table_name, constraint_name, cname1 || Nvl2(cname2,’,’ ||cname2,NULL) ||Nvl2(cname3,’,’ ||cname3,NULL) || Nvl2(cname4,’,’ ||cname4,NULL) ||Nvl2(cname5,’,’ ||cname5,NULL) || Nvl2(cname6,’,’ ||cname6,NULL) ||Nvl2(cname7,’,’ ||cname7,NULL) || Nvl2(cname8,’,’ ||cname8,NULL) columns from ( SELECT b.table_name, b.constraint_name, max(decode( position,…
Read MoreORA-01516: nonexistent log file, data file, or temporary file container in stand by Database
ORA-01516: nonexistent log file, data file, or temporary file container in stand by Database: ============================================================================================= ERROR at line 1: ORA-01511: error in renaming log/data files ORA-01516: nonexistent log file, data…
Read MoreInstalling Oracle 18c XE on Windows
This blog talks about How to Install Oracle Database 18c XE on Windows OS and Connect the database using SQL Plus and SQL Developer. It will help the developer to…
Read More