Oracle prompts Password Change ORA-28002 and ORA-28221 Database User Change Password error Solution

Source: Internet
Author: User
ORA-28002: thepasswordwillexpirewithinstringdays for example ERROR: ORA-28002: thepassw

ORA-28002: the password will expire within string days if ERROR: ORA-28002: the passw

Change the password of a Database User. When a user is not a dba-level user or a common user, you must use the replace clause to change the password (that is, you must know the old password before changing it)
Alter user hljitsm identified by hljitsm_123


Alter user hljitsm identified by hljitsm_123 replace Oracle_1234

Otherwise, the 'ora-28221: REPLACE not specified 'error will be reported when you directly use alter user hljitsm identified by hljitsm_123 to change the password.

ORA-28002: the password will expire within string days
Such as ERROR: ORA-28002: the password will expire within 6 days
In addition to changing the password, you can also change the password's validity period to avoid such restrictions.

1. SELECT username, profile FROM dba_users where username like 'test1 ';

USERNAME PROFILE
------------------------------------------------------------
TEST1 DEFAULT


Generally, the user profile is set to DEFAULT. Of course, some will also be others, such as NEW_PROFILE, which is to find out what it is.

2. SELECT * FROM dba_profiles s WHERE s. profile = 'default' AND resource_name = 'password _ LIFE_TIME ';

PROFILE RESOURCE_NAME RESOURCE LIMIT
--------------------------------------------------------------------------------------------------------------
DEFAULT PASSWORD_LIFE_TIME PASSWORD 180dys

========================================================== ======================================

3. Modify PASSWORD_LIFE_TIM settings in DBA_PROFILES to ULIMITED.
Execute the statement:
Alter profile default limit PASSWORD_LIFE_TIME UNLIMITED;


After modification, the settings take effect immediately. You do not need to restart the database, and the password will never expire.

After modification, users who have not been prompted for ORA-28002 warning will not receive the same prompt again;
The prompted user must change the password again, log on with the dba user, and enter the modification statement as follows:

SQL code

Alter user username identified by the new password you want to change

If you are not a dba user, modify the settings by referring to the method command at the beginning of this article.

Related reading:

Oracle 11g default password term issue-ORA-28002

ORA-01172, ORA-01151 error handling

ORA-00600 [2662] troubleshooting

Troubleshooting for ORA-01078 and LRM-00109

Notes on ORA-00471 Processing Methods

ORA-00314, redolog corruption, or missing Handling Methods

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.