0 Comments

Solution for ORA-01516: nonexistent log file, data file, or temporary file in Oracle 0 (0)

Solution for ORA-01516: nonexistent log file, data file, or temporary file in Oracle In the previous blog, we saw steps to restore RMAN consistent backup using duplicate database command Click here to read more. In this blog, we are going to restore the same consistent RMAN backup using the manual method. With this method we […]

 154 Total Views,  2 Views Today

0 Comments

Solution for RMAN-05541: no archived logs found in target database in Oracle 0 (0)

Solution for RMAN-05541: no archived logs found in target database in Oracle In the previous blog, we performed Steps to Clone Oracle Database from Windows to Oracle Linux Click here to read more. The only difference, in this case, we are taking a cold RMAN backup, and since this is a cold rman backup we […]

 135 Total Views,  1 Views Today

0 Comments

Steps to Clone Oracle Database from Windows to Oracle Linux 0 (0)

Steps to Clone Oracle Database from Windows to Oracle Linux In the previous blog, we saw Steps to create a Heterogeneous Dataguard between Windows and Linux Click here to read more. In this blog, we are going to perform a clone of Windows Oracle DB by taking RMAN backup and restoring it to Oracle Linux Server. […]

 320 Total Views,  1 Views Today

0 Comments

Solution for TNS-12557: TNS:protocol adapter not loadable 0 (0)

Solution for TNS-12557: TNS:protocol adapter not loadable In previous blog we saw How to Setup Oracle DB Network Encryption using SSL/TLS Click here to read more. Steps in previous blog will work fine for Enterprise Edition. But if you are using Standard Edition you will encounter error “TNS-12557: TNS:protocol adapter not loadable” while starting listener […]

 732 Total Views

0 Comments

KVM failed to start after ODA upgrade from 18.8 to 19.6 5 (1)

KVM failed to start after ODA upgrade from 18.8 to 19.6 Recent we had patched our ODA X7-2M (Baremetal) machine from 18.8 to 19.6 click here to read more about same both OS and Server patch was successful, But after ODA Server patched when tired to start KVM machine encounter below errors: error: Failed to […]

 799 Total Views

4 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 […]

 3,091 Total Views,  9 Views Today

4 Comments

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

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

 1,882 Total Views,  8 Views Today

2 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 […]

 1,122 Total Views

0 Comments

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

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 – […]

 1,297 Total Views

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 […]

 1,287 Total Views