Tag: tag

ORA-08103 Object No Longer Exists: Find the DDL Culprit

Posted on by Sanjeeva Kumar

Sound familiar? The table is still there. DESC works. SELECT COUNT(*) works. But the 40-minute report died halfway through with ORA-08103 object no longer exists, and the application team wants to know who dropped their table. Usually nobody dropped it. The table was replaced underneath the query. All Queries and their output is generated on Read more about ORA-08103 Object No Longer Exists: Find the DDL Culprit[…]

ORA-00020 maximum processes exceeded — Oracle CDB PDB connection leak production incident

ORA-00020: Maximum Processes Exceeded — How Three Different Errors Led to One Root Cause

Posted on by Sanjeeva Kumar

If you’ve ever hit ORA-00020 maximum processes exceeded in production, you know it rarely announces itself cleanly. Instead, it hides behind a cascade of unrelated-looking errors that send you down completely the wrong diagnostic path. Here’s a real example. You try to reset a password on the ddvpdb pluggable database. Routine task. And Oracle fires Read more about ORA-00020: Maximum Processes Exceeded — How Three Different Errors Led to One Root Cause[…]