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?
What is the cause of the error “ORA-02010 missing host connect string”? How do I resolve this?
Tokens are used to capture and store the environment variable values in the header of the GoldenGate trail record file. The trail file header contains a lot of information about the physical environment that produced the trail file and trail file contents. We can use this information to map token data to a target column […]
Are you moving you OCR and Voting disks from one storage to another? Read the step-by-step instructions on how to to move these files to a different diskgroup.