Hello everyone, I hope the holidays went well for you, best of wishes from my family to yours! It is a new year and we all have new year resolutions! After years of creating blogs for you all, I have decided to turn it up a notch! As many of you already know, I am […]
When executing a procedure I am getting “ORA-04031: unable to allocate shared memory” error. How do I avoid this error?
What is the cause of the error ORA-00054 “resource busy and acquire with NOWAIT specified or timeout expired”?
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.
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?