Unlock password first
alter user user_name_naja account unlock;
Then set the new password
alter user user_name_naja identified by values 'encrypt_password_here_naja'
– I don’t know how to encrypt the password, so I set it to random number just to unlock the account and then use the oracle utilities to change the user password later.
– same password as before can be used as well