ORA-28001: the password has expired solution, ora-28001expired

Source: Internet
Author: User

ORA-28001: the password has expired solution, ora-28001expired

Oracle prompt error message ORA-28001: the password has expired, due to new features of Oracle11G, the default password expiration limit for Oracle11G User Creation is 180 days (6 months ), if the user password is not modified for more than 180 days, the user cannot log on. Oracle introduces this default function in 11 GB by default for database security. However, this default function is easily neglected by DBAs or developers. Once the password is not modified for 180 days, this problem occurs.
You can use the following SQL statement to solve the problem:

Note: you must first log on to the console as a dba.
Run the SQLPlus command line tool and enter:
Connect as sysdba;
Enter the dba user name and password.

SELECT * FROM dba_profiles WHERE profile = 'default' AND resource_name = 'password _ LIFE_TIME'
Query the password validity period settings. The LIMIT field is the password validity period.
When the password is about to expire or has expired, use the following statement to modify the password. After the password is changed, the user can connect to the database normally.
Alter user Username identified by password;

To remove the 180-day password lifecycle restriction, use the following SQL statement to disable it:
Alter profile default limit PASSWORD_LIFE_TIME UNLIMITED
The above SQL statement changes the default password validity period from 180 days to "unlimited ". For the sake of database security, we do not recommend that you set PASSWORD_LIFE_TIME to UNLIMITED. We recommend that you modify the password of a database user on a regular basis.

Oracle password expired the password has expired Solution

Oracle encountered the password has expired problem. Today, I suddenly found that the project could not be accessed. I found that I could not use it, and I could not log in,

This problem is caused by the expiration of the Oracle11g password.

An exception occurred when debugging the Web Project:

Java. SQL. SQLException: ORA-28001: the password has expired
Check online, connect to Oracle, log in as an Oracle user, and enter the following command

Select * from dba_profiles where profile = 'default' and resource_name = 'password _ LIFE_TIME ';
Result:

PROFILE RESOURCE_NAME RESOURCE_TYPE LIMIT

DEFAULT
PASSWORD_LIFE_TIME
PASSWORD
180

The password is valid for 180 days.

Enter the following command:

Alter profile default limit password_life_time unlimited;
Commit;
Execute again:

Select * from dba_profiles where profile = 'default' and resource_name = 'password _ LIFE_TIME ';
The result is displayed as follows:

PROFILE RESOURCE_NAME RESOURCE_TYPE LIMIT

DEFAULT
PASSWORD_LIFE_TIME
PASSWORD

UNLIMITED

After performing the preceding steps, you must change the password. Otherwise, the password has expired exception may occur.

Password Change command

Alter user XXXUSER identified by Welcome1;
If the account is locked, the UNLOCK Command is required.

Alter user XXXUSER identified by oracle account unlock;
Debug again and solve the problem

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.