Oracle Tips
Database
Most Popular
[wpp range=all limit=5 stats_views=0 order_by=views pages=0 cat=370 wpp_start=
- wpp_end=
]
Oracle Tips
- Looking for errors in the Clusterware and RAC logs? Dash through using the TFA Collector - The Oracle Trace File analyzer utility has been originally developed by Oracle to help collect and bundle up all the pertinent diagnostic data in the log files, tracefiles, os statistics, etc.. This is a very common task when Oracle Support engineers request this information to help troubleshoot issues and bugs.
- ORA-00984 column not allowed here - What is the cause of the "ORA-00984 column not allowed here" error? How do I resolve this?
- ORA-04031 Unable to Allocate Shared Memory - When executing a procedure I am getting "ORA-04031: unable to allocate shared memory" error. How do I avoid this error?
- Solved – How to fix ORA-00054 resource busy and acquire with NOWAIT specified or timeout expired? - What is the cause of the error ORA-00054 "resource busy and acquire with NOWAIT specified or timeout expired"?
- ORA-01110 data file %s - What is the cause of the error "ORA-01110 data file %s"? How do I resolve this?
- ORA-00918 column ambiguously defined - What is the cause of the "ORA-00918 column ambiguously defined" error? How do I resolve this?
- Generate Multiple AWR Reports Quickly - 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.
- How to solve “ORA-03135 connection lost contact” error? - 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?
- Solved – How to troubleshoot ORA-01034: ORACLE not available issue? [Updated 2019] - What is the cause of the error ORA-01034 "ORACLE not available"?
- ORA-04030 Out of Process Memory When Trying To Allocate s Bytes - What is the cause of the "ORA-04030 out of process memory when trying to allocate s bytes" error? How do I resolve this?