Oracle Password expires the password has expired____oracle

The workaround can be done by using the following SQL statement

First you need to log on using DBA.

To run the cmd command-line tool, enter:

Sqlplus/as SYSDBA

Sqlplus sys/Password @ database use case name as Sysdba

After you enter the DBA's username and password

SELECT * from Dba_profiles WHERE profile= ' DEFAULT ' and resource_name= ' Password_life_time '

Query password expiration setting, limit field is the password valid number of days.

Or: Select Username,account_status from Dba_users; You can see that some user status is expired. When the password is about to expire or has expired, the following statement can be used to modify the password, the user can normally connect to the database after the password modification.

ALTER user username identified by password;

Note: If the password consists of a number + password, you must add double quotes to succeed

sql> alter user Ju identified by "123AAA";

Submit

Commit

Exit

Exit