User unable to login /connect with database after upgrade AWS RDS to 19c Database : Error - ORA-01017: invalid username/password

 

Users unable to login / connect with database after upgrade AWS RDS to 19c : Error - ORA-01017: invalid username/password

App users were getting below error after upgrade the AWS Oracle RDS database version 12c to 19c .

ORA-01017: invalid username/password;

Solution :

Need to update below parameter in parameter group :

 

sqlnetora.sqlnet.allowed_logon_version_server  => 8

Also check password version : 

SELECT USERNAME,ACCOUNT_STATUS,PASSWORD_VERSIONS FROM DBA_USERS;