Yaro Perventsev·Nov 7ORA-03113 After the Connection Sat Idle: The Firewall Forgot ItThe application works all day. Then the first request after a quiet spell fails: the first one in the morning, the first one after lunch…
InLevel Up CodingbyYaro Perventsev·Nov 1ORA-01000 Maximum Open Cursors Exceeded: Don’t Raise the Limit, Find the LeakThe application has been fine for days. Then one request fails, then a few more, all from the same app server:
InLevel Up CodingbyYaro Perventsev·Oct 31SYSDATE Is Hours Off After the Move to the Cloud. Nothing Errors.The migration went well. The database moved from the server room to the cloud over the weekend, the row counts matched, the application…
Yaro Perventsev·Oct 28ORA-01017 After a Password Change: Rotate It With Zero DowntimeThe security team wants the application account’s password rotated. It’s a one-line change:
Yaro Perventsev·Oct 20ORA-12514: The Database Is Up. The Listener Just Doesn’t Know It.The application can’t connect. The error is one every Oracle DBA has seen:
InLevel Up CodingbyYaro Perventsev·Oct 17ORA-01652: Unable to Extend Temp Segment. Don’t Just Add Space.The open-orders report has run every morning for a year. Today it fails:
Yaro Perventsev·Oct 13Checkpoint Not Complete: Every Commit Waits, and the SQL Is FineThe nightly batch used to finish in twenty minutes. Now it takes an hour, and during that hour the application stutters: every few seconds…
InLevel Up CodingbyYaro Perventsev·Oct 10Same SQL, Fast for One Value, Slow for AnotherThe order-history screen is fast for every customer except one. Or it’s fast all morning and crawls all afternoon. Or it was fine for…
InLevel Up CodingbyYaro Perventsev·Oct 4Cutover Went Perfectly. The First New Order Failed With ORA-00001.The migration went by the book. The initial load ran days ahead. On cutover night the final data refresh finished early, row counts matched…
InLevel Up CodingbyYaro Perventsev·Oct 3You Deleted 99% of the Rows. The Full Scan Didn’t Get Any Faster.The audit table had grown to 200 million rows, so the team finally ran the purge: everything older than 90 days, gone. Ninety-nine percent…