Sometimes You can get ” ORA-28001: the password has expired ” error.
Details of error are as follows.
ORA-28001: the password has expired
Check the users which users are expired.
SQL> SELECT username, account_status FROM dba_users WHERE ACCOUNT_STATUS LIKE '%EXPIRED%';
You can solve this error by using its existing password or with new password as follows.
ALTER USER USERNAME IDENTIFIED BY PASSWORD; SQL> ALTER USER MEHMET IDENTIFIED BY DEVECI; User altered.
Or you can unlock it as follows, then change default profile PASSWORD_LIFE_TIME to UNLIMITED as follows.
SQL> ALTER USER system ACCOUNT UNLOCK; User altered. SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED; Profile altered. SQL>
Do you want to learn Oracle Database for Beginners, then read the following articles.
1,392 views last month, 6 views today