My Oracle Support Banner

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

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.8.0.0.0 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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