Thursday, 20 March 2025

ORA-28414: specified keys are in HSM and OPEN_NO_MASTER_KEY when migrating to pluggable database (PDB)

›
The error as explained by Oracle mentions that the this happens when your key is stored in an external store - such as Hardware Security Mod...
Friday, 14 July 2023

Online Reorganization in Oracle 19c and 12cR2

›
We recently had to reorganize 7 bigfile tablespaces/datafiles which had almost 8-10TB free in each of them and only consumed less than 1TB o...
Friday, 4 June 2021

Get all the Privileges and Roles Granted to an Oracle User

›
It is often required to review all the privileges/roles assigned to an Oracle user. Below piece of SQL can be run via SQL developer or SQLPl...
Monday, 7 September 2020

Enable or Disable Cron jobs Using Single Command

›
 A quick one, DBAs frequently need to disable/enable cron jobs. This can be often a time killer, so here are three commands to make life eas...
Friday, 9 August 2019

Find SQL Query Being Applied by Logical Standby or Applier Process

›
Came-up with this query to find which SQL is being applied on a logical standby as I frequently need to check what tables are undergoing he...

Logical Standby Recovery Stalled - Problem due to Sequence Reset or SEQ$ table

›
Changes: A sequence was reset or decremented on your primary instance and now apply process is not able to progress on logical standby...
Monday, 15 July 2019

Samba Share Mount Fails or SMB error NT_STATUS_LOGON_FAILURE STATUS_LOGON_FAILURE

›
This problem has been troubling me a lot for days with below error on a live environment (had to mask original details below, but feel free...