ORA-01017: invalid username/password logon denied

ORA-01017: invalid username/password; logon denied

Oracle SQL Error: ORA-01017: invalid username/password; logon denied

Cause:

An attempt was made to logon on database schema.

Solution:

Check if the username and password are correct. Check if the user has the right to create session.

Example:

CREATE USER test3 IDENTIFIED BY test_user3;

GRANT create session TO test3; 

Output:

User TEST3 created.
Grant succeeded.