Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
ORA-01017 error after password reset — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

ORA-01017 error after password reset

Received Response
11
Views
6
Comments

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!