Medium

Yaro Perventsev

Yaro Perventsev

·

Oct 28

ORA-01017 After a Password Change: Rotate It With Zero Downtime

The security team wants the application account’s password rotated. It’s a one-line change:

ORA-01017 After a Password Change: Rotate It With Zero Downtime

Yaro Perventsev

·

Oct 20

ORA-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:

ORA-12514: The Database Is Up. The Listener Just Doesn’t Know It.

In

Level Up Coding

by

Yaro Perventsev

·

Oct 17

ORA-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:

ORA-01652: Unable to Extend Temp Segment. Don’t Just Add Space.

Yaro Perventsev

·

Oct 13

Checkpoint Not Complete: Every Commit Waits, and the SQL Is Fine

The nightly batch used to finish in twenty minutes. Now it takes an hour, and during that hour the application stutters: every few seconds…

Checkpoint Not Complete: Every Commit Waits, and the SQL Is Fine

In

Level Up Coding

by

Yaro Perventsev

·

Oct 10

Same SQL, Fast for One Value, Slow for Another

The 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…

Same SQL, Fast for One Value, Slow for Another

Yaro Perventsev

·

Oct 4

Cutover 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…

Cutover Went Perfectly. The First New Order Failed With ORA-00001.

In

Level Up Coding

by

Yaro Perventsev

·

Oct 3

You 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…

You Deleted 99% of the Rows. The Full Scan Didn’t Get Any Faster.

Yaro Perventsev

·

Sep 30

Your Oracle Traffic Is Readable on the Wire. Here’s the Proof, and the Fix.

The database is patched. The data files are encrypted with TDE. The audit trail is clean. And every query your application runs — along…

Your Oracle Traffic Is Readable on the Wire. Here’s the Proof, and the Fix.

Yaro Perventsev

·

Sep 26

The Migration Completed Successfully. Half the Names Are Now Question Marks.

The cutover ran clean. impdp reported completed successfully, the row counts matched to the row, the application came up, and everyone went…

The Migration Completed Successfully. Half the Names Are Now Question Marks.

Yaro Perventsev

·

Sep 23

ORA-00257: The Database Stopped Accepting Writes. The Archiver Is Stuck.

The pager goes off at 3 a.m.: the application is frozen. Every screen that tries to save hangs, and the ones that time out come back with…

ORA-00257: The Database Stopped Accepting Writes. The Archiver Is Stuck.

Yaro Perventsev

Yaro Perventsev

Oracle systems architect, ~27 years. I write field-tested, vendor-neutral guides on HA, performance & cloud migration at uptimearchitect.com. Views are my own.

Help

Status

About

Careers

Press

Blog

Store

Privacy

Rules

Terms

Text to speech