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
- 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? - 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?
- ORA-01403 No Data Found Error - What is the cause of the "ORA-01403 no data found" error? What can be done to solve this?