Oracle 19c solves ORA-00026 when killing PDB sessions

Oracle Multitenant was a big architectural change for Oracle Database. I guess it was not so easy to introduce it to such a complex system. Unsurprisingly, there were some side effects introduced, but Oracle works hard to correct them. One example is ORA-00026: missing or invalid session ID thrown while trying to kill specific sessions, e.g. Data Pump workers or DBMS_SCHEDULER ones.

Continue reading “Oracle 19c solves ORA-00026 when killing PDB sessions”

Useful Oracle tools – DBCOMP

Getting lost writes (e.g. ORA-00752: recovery detected a lost write of a data block) is one of the worst DBA’s nightmares. There are a lot of very important questions popping up. Apart from the obvious ones on how to solve the problems reported (hopefully without any data loss), there are many others. For instance – can I rely on my current software and/or hardware stack? Or maybe lost writes were introduced before and I should be fine with what I have? What about other lost writes which are dormant and not yet detected? Fortunately, since Oracle 12.2 version, the last one can be easily answered.

Continue reading “Useful Oracle tools – DBCOMP”