Oracle error message ORA

Oracle prompt error message ORA-28001: thepasswordhasexpired solution: 1, using SYSDBA permission login; 2, view account information: selectusername, role, if the account lockedexpired, first unlock: alteruserBJMMISaccountunlock; then modify Password

Oracle prompt error message ORA-28001: the password has expired solution: 1. log in with SYSDBA permission; 2. View account information: select username, account_status from dba_users 3. If the account locked/expired, unlock first: alter user BJMMIS account unlock; Then Change Password

Oracle prompt error message ORA-28001: the password has expired

Solution:

1. Use SYSDBA permissions to log on;

2. View account information:

Select username, account_status from dba_users

3. If the account locked/expired,

Unlock first:

Alter user BJMMIS account unlock;

Change the password

Alter user BJMMIS identified by newpwd;

Once and for all, the password for the 11G180 day will fail:

Query password Validity Period

SELECT * FROM dba_profiles WHERE profile = 'default' AND resource_name = 'password _ LIFE_TIME'

Change to unrestricted:

Alter profile default limit PASSWORD_LIFE_TIME UNLIMITED