My Oracle Support Banner

PASSWORD_ROLLOVER_TIME doesn't work for users with a 10G only password hash (Doc ID 2813753.1)

Last updated on OCTOBER 12, 2021

Applies to:

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

Symptoms

PASSWORD_ROLLOVER_TIME doesn't work for users with a 10G only password hash

Changes

 TEST CASE in 19.12:

 NOTE: This parameter is set in sqlnet.ora file “SQLNET.ALLOWED_LOGON_VERSION_SERVER=8”.

           SCOTT Account lives in DB with 10g only password version and use Default Profile.

SQL> connect / as sysdba
Connected.
SQL> select username, password_versions, created, account_status from dba_users where username = 'SCOTT';

USERNAME    PASSWORD_VERSIONS     CREATED          ACCOUNT_STATUS
--------------------------------------------------------------------------------------------------------------------------------

SCOTT           10G                                     06-OCT-21        OPEN

SQL> connect scott/current_password
Connected.

SQL> connect / as sysdba
Connected.

SQL> ALTER PROFILE default LIMIT PASSWORD_ROLLOVER_TIME 1;

Profile altered.

SQL> alter user scott identified by "new_password" ;

User altered.

SQL> select username, password_versions, created, account_status from dba_users where username = 'SCOTT';

USERNAME    PASSWORD_VERSIONS     CREATED          ACCOUNT_STATUS
--------------------------------------------------------------------------------------------------------------------------------

SCOTT          10G                                      06-OCT-21        OPEN & IN ROLLOVER

SQL> connect scott/current_password
ERROR:
ORA-01017: invalid username/password; logon denied

Warning: You are no longer connected to ORACLE.
SQL> connect scott/new_password
ERROR:
ORA-01017: invalid username/password; logon denied

SQL> connect / as sysdba
Connected.

SQL> ALTER USER scott EXPIRE PASSWORD ROLLOVER PERIOD;

User altered.

SQL> select username, password_versions, created, account_status from dba_users where username = 'SCOTT';

USERNAME    PASSWORD_VERSIONS     CREATED        ACCOUNT_STATUS
--------------------------------------------------------------------------------------------------------------------------

SCOTT          10G 11G 12C                         06-OCT-21      OPEN

SQL> connect scott/new_password
Connected.

SQL> 

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.