preamble
ORA-28001 indicates that the password has expired. This error is received when an Oracle user has an expired password and tries to log on to the database.
Oracle users will receive this error when their password expires and they try to log in to the database.
The specific solutions are as follows:
1, through the administrator login oracle database
2、Find users who need to reset their passwords
select username from dba_users where account_status = 'EXPIRED';
3、Reset password
alter user <username> identified by <password>;
4. Unlock the user if needed
alter user <username> account unlock;
Caveats:
-
<username>is the Oracle user name for which you want to reset the password. -
<password>is the new password you want to set for the user. - If desired, you can unlock the user using other methods, such as
grant create session to <username>;。 - These steps require logging into the database with administrator privileges, so you need to have credentials as a privileged user.
summarize
to this article on the connection oracle error: ora-28001: the password has expired solution to this article, more related ora-28001: the password has expired content please search for my previous posts or continue to browse the following related articles I hope that you will have more support in the future! I!