Zdlra: PTIME For The User Password Change Not Updating (Doc ID 2684587.1)

Last updated on AUGUST 19, 2024

Applies to:

Symptoms

CT has changed the user password and PTIME not updating in the user$ table .

The database is running on 19c and ZDLRA appliance

SQL> select USER#,NAME,CTIME,PTIME from user$ where name='SYS';

    USER#  NAME       CTIME                             PTIME
----------    ---------- ------------------------------  --------------------
        0       SYS        14-APR-2020 08:15:29   14-APR-2020 08:15:29

SQL> alter user sys identified by ********;

User altered.

SQL> select USER#,NAME,CTIME,PTIME from user$ where name='SYS';

    USER#   NAME       CTIME                             PTIME
----------    ---------- ------------------------------  -----------------------
      0          SYS       14-APR-2020 08:15:29    14-APR-2020 08:15:29                             <<<<==== PTIME value did not change.

SQL>

Changes

Cause

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