If the extract process was not un-registered from the database then Cleaning Up GoldenGate Integrated Extract Using DBMS_CAPTURE_ADM.DROP_CAPTURE will be necessary.
What is the cause of the error “ORA-01110 data file %s”? How do I resolve this?
What is the cause of the “ORA-00918 column ambiguously defined” error? How do I resolve this?
Occasionally there is a need to generate multiple AWR reports for database analysis. In my case, a storage vendor will use a tool to extract data from all time periods from the AWR reports to find IO related specific information. Here is how I generated these reports.
Users are connected to the database via TNS and abruptly get disconnected. What is the cause of the “ORA-03135 connection lost contact” error? How can this be avoided?