When trying to establish a sqlplus connection I get the “ORA-12537: TNS:connection closed” error messgae. How do I resolve this?
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.