ORA-28001: The password has expired

I'm facing the problem about my database in Oracle, When I opened my database, it appear a message with: "ORA-28001: The password has expired"

I have updated my account with somes:

sqlplus /nolog
SQL> connect / as SYSDBA
Connected.


SQL> SELECT username, account_status FROM dba_users WHERE ACCOUNT_STATUS LIKE '%EXPIRED%';


SQL> ALTER USER system IDENTIFIED BY system;
User altered.


SQL> ALTER USER system ACCOUNT UNLOCK;
User altered.


SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
Profile altered.


SQL> exit

I check and see that, my account: 'system' has OPEN, but I open it on Oracle SQL Developer, it still have alert: 

ORA-28001: The password has expired

I have refered very much links but it still same the problem, how to fix this?

235297 次浏览
小开

Check "PASSWORD_LIFE_TIME" by

Sql > select * from dba_profiles;

Set to Never expire

Sql> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

Then reset the password of locked user.

小开
最佳答案

I have fixed the problem, just need to check:

open_mode from v$database

and then check:

check account_status to get mode information

and then use:

alter user myuser identified by mynewpassword account unlock;
小开

you are in wrong cdb/pdb so connect to right pdb

小开 
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
alter user EPUSR100 identified by EPUSR100 account unlock;
commit;
小开

Try to connect with the users in SQL Plus, whose password has expired. it will prompt for the new password. Enter the new password and confirm password.

It will work

SQL Plus output image

小开 
C:\>sqlplus /nolog
SQL> connect / as SYSDBA
SQL> select * from dba_profiles;
SQL> alter profile default limit password_life_time unlimited;
SQL> alter user database_name identified by new_password;
SQL> commit;
SQL> exit;
小开

I had same problem even after changing the password, it wasn't getting reflected in SQLDEVELOPER.

Atlast following solved my problem :

  1. Open Command Propmt
  2. Type sqlplus
  3. login as sysdba
  4. Run following command : alter user USERNAME identified by NEW_PASSWORD;
小开

I had same problem, i am trying to login database it appear a message with: "ORA-28001: The password has expired" , I have fixed the problem simple steps

1.open command prompt 2.type sqlplus 3.It will ask Enter Password, you can give old password, it will show password has expired ORA-28001 4.It will ask new password and retype password 5.It will change with new password 6.Go to the sql database and try to connect with new password, it will connect.

小开

Just go to the machine where your database resides, search windows -> search SqlPlus Type the user name, then type password, it will prompt you to give new password. On providing new password, it will say successfully changed the password.

小开
  • Connect to Oracle

sqlplus sys/root as sysdba connected to oracle

  • Check the status and expiry date for the user

SELECT username, account_status, expiry_date FROM dba_users;

status

  • Change the password for the user to resolve expiry

ALTER USER dummy_user IDENTIFIED BY dummy_password;

change password

  • Unlock the user account if it locked

ALTER USER dummy_user ACCOUNT UNLOCK;

  • Set the password expiry limit to unlimited to avoid issue in the future

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

password unlimit

  • Again check the status of the user to verify the expiry date. The account status is now open and the expiry date is unlimited.

SELECT username, account_status, expiry_date FROM dba_users;

status1

SQL commands:

sqlplus sys/root as sysdba

SELECT username, account_status, expiry_date FROM dba_users;

ALTER USER dummy_user IDENTIFIED BY dummy_password;

ALTER USER dummy_user ACCOUNT UNLOCK;

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

小开

Simple.. Goto Command prompt and type SQLPLUS /@connect string Hit Enter.

It says password expired and provide the option to enter new password. Enter new password and you are done.

小开

To know which users are expired, run command SELECT * FROM <DATABASE USERS/PROFILES>;

To unlock users, run command alter user identified by account unlock;

小开

I am running Oracle 18c in a Docker container, where the problematic database is a Pluggable database, so I had to take a different approach:

  1. Log in to SYSDBA

  2. Switch to Pluggagle Database

    ALTER SESSION SET CONTAINER=XEPDB2;

  3. Remove Password Expiry

    ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

  4. Get Current User Details

    SELECT dbms_metadata.get_ddl('USER','username') stmt from dual;

    Replace the username above with your own.

    The output will be something like:

    CREATE USER "…" IDENTIFIED BY VALUES '…'

  5. To reset the password, run as:

    ALTER USER "…" IDENTIFIED BY VALUES '…' ACCOUNT UNLOCK;

    … using the username and password from the previous step.

This is a combination of other answers here and elsewhere.


提交答案