ORA-01017 error after password reset
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ---------------- ---------- -------------
2 PDB$SEED READ ONLY NO
3 TEST READ WRITE NO
SQL> alter session set container=TEST;
Session altered.
SQL> select username,account_status ,expiry_date from dba_users where username='TEST';
USERNAME ACCOUNT_STATUS EXPIRY_DA
-------- ----------------- ---------------
TEST EXPIRED 24-OCT-22
SQL> alter user TEST identified by TesT#123#;
User altered.
SQL> conn TEST/TesT#123#
ERROR:
ORA-01017: invalid username/password; logon denied
Why I am getting ORA-01017 error after user's password reset ?
Tagged:
1