Oracle 11g password expired lock reported ORA-28000 the account is locked, 11gora-28000

Oracle 11g password expired lock reported ORA-28000 the account is locked, 11gora-28000

I. Reasons for triggering this error and Related Factors

This is because "PASSWORD_LIFE_TIME = 180 days" is set in the default profile in oracle11g by default.
The password has expired.

Ii. Error:

After the user is locked, an ORA-28000 error will be reported, and the user cannot be logged in to the database.
SQL> conn system / oracle
ERROR:
ORA-28000: the account is locked
Warning: You are no longer connected to ORACLE.
SQL>

Iii. solution:

Follow the steps below:
1. Check which user's proifle is generally default:
SQL> select username, profile from dba_users where username = 'SYSTEM';
USERNAME PROFILE
------------------------------ -------------------- ----------
SYSTEM DEFAULT
SQL>

2. View the password expiration setting for the specified profile (such as default):
SQL> SELECT * FROM dba_profiles s WHERE s.profile = 'DEFAULT' AND resource_name = 'PASSWORD_LIFE_TIME';
PROFILE RESOURCE_NAME RESOURCE LIMIT
------------------------------ -------------------- ------------ -------- ------------------------------ ----------
DEFAULT PASSWORD_LIFE_TIME PASSWORD 180DAY

3. Change the password validity period from the default 180 days to "Unlimited":
sql> ALTER PROFILE DEFAULT LIMITPASSWORD_LIFE_TIMEUNLIMITED;
The database does not need to be restarted after modification, it will take effect immediately.

4. After the modification, accounts that have not been prompted with ORA-28002 warning will not encounter the same prompt again
The account that has been prompted just needs to be unlocked.
$ sqlplus / as sysdba
SQL> alter user system account unlock;
User altered.
5. If you are still unable to log in, perform another password configuration and it is OK. (Same as the original password)
SQL> alter user system identified by oracle;
User altered. 

The oracle11g startup parameter resource_limit takes effect regardless of whether it is set to false or true. Therefore, you must modify the password in the preceding method. The preceding account name must be changed based on the actual account name.

ORA-28000 in oracle Database: the account is locked Problem

This user has been locked. Generally, it has to be unlocked because the wrong password has been tried too many times.
Log in with the system or sys user, and then
Alter user username account unlock;

Oracle 11 ora-28000: the account is locked

The account has been locked. Is there too many wrong passwords?
Run the following commands after entering cmd:

Sqlplus/nolog
Conn/as sysdba
Alter user system identified by oracle account unlock;
Alter user system identified by password;
Step-by-step execution. It is best to copy my files. I am afraid you may make a mistake, because there must be spaces in some places.