0 Comments

Solution for [INS-08101] Unexpected error ‘supportedOSCheck’ while Oracle 19C Installation 0 (0)

Solution for [INS-08101] Unexpected error ‘supportedOSCheck’ while Oracle 19C Installation In this article we will solve error [INS-08101] Unexpected error while executing the action at state: ‘supportedOSCheck’.  Above error occurred while 19c (19.3) binary installation on server Oracle enterprise Linux version (OEL) 8.2 or greater than version 8.1 i.e Oracle 19c supported up to version […]

 56 Total Views,  4 Views Today

0 Comments

Solution for OGG-00516 Fatal error executing DDL replication 0 (0)

Solution for OGG-00516 Fatal error executing DDL replication In this blog, we will perform a solution to resolve OGG-00516 Fatal error executing DDL replication.This error occurs when the golden gate REPLICATE process unable to perform the same DDL on Target DB which was executed on Source DB. In the Target database, you may not create […]

 64 Total Views,  2 Views Today

0 Comments

Solution for ORA-00904: DBMS_FLASHBACK: invalid identifier in Oracle 0 (0)

Solution for ORA-00904: DBMS_FLASHBACK: invalid identifier in Oracle In this article, we will demonstrate a solution for ORA-00904: DBMS_FLASHBACK: invalid identifier in Oracle. This error reflects whenever the user tries to get access current system change number (SCN) without appropriate access.  To eliminate this error ORA-00904, we will grant EXECUTE on package DBMS_FLASHBACK or SELECT access […]

 118 Total Views,  7 Views Today

0 Comments

Fixing OGG-01161 Bad Column Index (77) Specified for Tables 0 (0)

Fixing OGG-01161 Bad Column Index (77) Specified for the Table In this blog we will perform require steps to resolve OGG-01161 Bad column index (77) specified for the table in Oracle Goldengate, This error occurs when the target table doesn’t match the source table, there is a mismatch on columns between source and target. OGG Setup – […]

 174 Total Views,  2 Views Today

0 Comments

Fixing OGG-05500 Detected Database Metadata Mismatch Between Current Trail File 5 (1)

Fixing OGG-05500 Detected Database Metadata Mismatch Between Current Trail File In this blog we will perform require steps to resolve ERROR OGG-05500 Detected database metadata mismatch between current trail file OGG Setup – Source (Window Server) OGG Setup – Target (Linux Server) Step 1. Replicat Process Abended in Target: As you will notice Replicat RC232 […]

 282 Total Views,  3 Views Today

4 Comments

How to Fix ORA-10458 & ORA-01196 in Standby 11g (Roll Forward a Physical Standby Database) 5 (1)

How to Fix ORA-10458 & ORA-01196 in Standby 11g (Roll Forward a Physical Standby Database) This post presents a quick and efficient alternative to rebuilding a physical standby database in Oracle Database 11g Release 2 by using RMAN incremental backups to roll forward and resynchronize a physical standby database with the primary database or Fix ORA-10458 […]

 210 Total Views,  1 Views Today

0 Comments

ORA-01102: Cannot Mount Database in EXCLUSIVE mode 5 (2)

ORA-01102: Cannot Mount Database in EXCLUSIVE mode When we are doing database refresh from Prod to Dev (lower environment), At that time we put the cluster database parameter to false. This parameter is spfile file specific, so we need to bounce the database. After the refresh completed successfully, we are trying to start the node, […]

 1,297 Total Views,  5 Views Today

Spread the Knowledge!

6 Comments

Resolve ORA-10562,10564,01110,10561,00600 at Standby database In Oracle 4.7 (21)

Resolve ORA-10562, 10564, 01110, 10561, 00600 at Standby database In Oracle In this article, we will resolve errors ORA-10562, 10564, 01110, 10561, 00600 at Standby. Few days back, we got SYSAUX tablespace error at DBGURU STANDBY database and the error was as below: Errors in file /u02/app/oracle/diag/rdbms/dbguru/dbguru/trace/dbguru_mrp0_26696.trc:ORA-10562: Error occurred while applying redo to data block […]

 3,803 Total Views,  5 Views Today

Spread the Knowledge!