ORA-1017 raised after resolving ORA-28040

ORA-28040: No matching authentication protocol

ORA-1017 Invalid Username or Password

Above error raised when resolving the ORA-28040 (Connecting Oracle 12c with 11g or lower client)

Following a recent database upgrade to 12.2, an 11gR2 client might suddenly start to fail to connect to the database with an error ORA-28040.

Click to see the solution for ORA-28040 


However, once the ORA-28040 error is cleared, the client still cannot connect and a persistent ORA-1017 is returned.

Solution:

- Connect with sys user 

- Expire user password

- Reset the password
- Re-connect with client 

```

SQL> alter user scott password expire;

User altered

SQL> alter user scott identified by tiger;

User altered

```