Changing Password for Common User Hangs with Database Vault Enabled (Doc ID 2746980.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

Database 19c Multitenant with Database Vault: Changing password for common user hangs, waiting on Concurrency row cache lock.
This issue may occur when changing passwords for Database Vault Owner or Account Manager, but it is also occurring for C## common users.
And it only happens with Database Vault enabled, if DV is disabled the user can change its password.

Trace file shows ALTER USER statement followed by a lot of recursive sql and it eventually starts to hang on: 

/* SQL Analyze(860,0) */ SELECT /*+PARALLEL(1) NO_STATEMENT_QUEUING */ * FROM X$KXFTASK /*kpdbReplayDDL,PDB_Replay_DDL*/

AWR report shows "row cache lock" wait event

Changes

Change password for common user

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.