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 laterInformation 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 |