ORA-65162: The password of the common user has expired
Posted by Mir Sayeed Hassan on October 2nd, 2021
ORA-65162: The password of the common user has expired
The above error is occur due to the user password was expired in your database
Check the status of the user
SQL> select username,account_status from dba_users where account_status like '%EXPIRED%'; USERNAME ACCOUNT_STATUS ----------------------------- SYSTEM EXPIRED
Check the Profile
SQL> select * from dba_profiles where profile='DEFAULT'; PROFILE RESOURCE_NAME RESOURCE LIMIT COM INH IMP ------------------------------------------------------------------------------------- DEFAULT PASSWORD_LIFE_TIME PASSWORD 180 NO NO NO
Note:
– In case if you want to extend the resource limit of password expired., You just need to change the password & unlock your account.
– In case if you want to set the resource limit of password expired, then you need update.
Alter the Profile to unlimited
SQL> sqlplus / as sysdba
SQL> show user; USER is "SYS"
SQL> alter profile default limit password_life_time unlimited;
Profile altered.
Change the Password
SQL> alter user system identified by <password>; User altered.
SQL> alter user system account unlock;
User altered.
Verify
SQL> select username,account_status from dba_users where account_status like '%EXPIRED%'; USERNAME ACCOUNT_STATUS ----------------------------- SYSTEM OPEN ====Hence tested & verified in our test env===== Also Read: technology quotes