Misdiagnosing a critical #oracle problem

I thought I was solving an ORA-3113 problem (end-of-file on communication channel) when I was actually solving an ORA-1113 problem (file %s needs media recovery). It was only when I started to write up the experience that I realized that I had solved the wrong problem.

Advertisements

Technical Note: ORA-28017: The password file is in the legacy format

When I tried to change the password for SYS, I got an ORA-28017 error message. This was caused by a manual DB upgrade to 12C without upgrading the password file as well.

Street-Light Performance Anti-Method

Connor McDonald writes that It’s just bad code or bad design … most of the time for Oracle performance problems.

Why Choosing ANSI JOIN is an Operational Issue

From an operational perspective, I argue that the use of ANSI syntax for JOINs is superior to that of Oracle’s native syntax.

Slow Apply on Logical Standby due to SYS.AUD$

Struck a problem today with Logical Standby due to SYS.AUD$.

Bottom-Up Enterprise Information Systems

In Bottom-Up Enterprise Information Systems: Rethinking the Roles of Central IT Departments (behind a pay-wall), Chua and Storey look at strategies for Central IT departments to handle the challenge of these new systems.

Exercise in Database Performance Modelling

I have spent the past year doing performance modelling of a new product that is being rolled progressively to clients. The most frustrating thing has the lack of meaningful feedback from the product support group. Everytime I raise a concern that the performance is not as expected, I get the platitude that the product is performing as expected.