Solution for ORA-00600: Internal Error Code, Arguments: [4193] [2206} in Oracle In this post we will see How to solve ORA-00600: Internal Error Code, Arguments: [4193] [2206], You can encounter this error in Multitenant Environment (CDB) if your Oracle Database machine was suddenly stopped without proper shutdown command due to some unavoidable problem like Power […]
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 […]
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 […]
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. […]
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 […]
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 […]
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 […]
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, […]
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 […]
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 – […]
Recent Comments