February, 2021

dbaascli patch db prereq failing with: Error opening the transaction id file

Sometimes you are doing a cloud patch precheck and error is a bit cryptic, it even says “ready to apply patch”! Now, if you try from the other node it can give you a hint: Somehow it can not copy file from DBNODE_B to DBNODE_A, and indeed, we tried to ssh both ways and we... » read more

SQL: How to kill sessions in bulk

For this first post, lets start with something easy that everyone that manages a DB should know. You have been requested to kill everything that RMAN is running for whatever reason. It can be backup is no longer valid or it is generating impact in performance, which needs to be resolved right away. Do you... » read more