Shulou(Shulou.com)05/31 Report--

Editor to share with you the expiration of Oracle password how to cancel the password 180-day limit, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

The Oracle password expires and the password limit of 180 days is lifted.

1. Enter sqlplus mode

Sqlplus / as sysdba

2. Check the validity period of the user's password (the default configuration file is DEFAULT)

SELECT * FROM dba_profiles WHERE profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME'

3. Change the validity period of the password from the default 180 days to "unlimited". There is no need to restart the database after the change, and it will take effect immediately.

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED

4. Change the account password again

Alter user username identified by original password

Alter user system identified by TRANSITsystrong2017

5. Log in with the modified user. If you report "ORA-28000: user is locked", unlock it.

Alter user user name account unlock; commit

Let's take a look at solving the problem that the Oracle11g password expires within 180 days and the account is locked.

1. Check which user's proifle is, usually default:

Sql > SELECT username,PROFILE FROM dba_users

2. Check the password validity settings for the specified profile (such as default):

Sql > SELECT * FROM dba_profiles 's WHERE s.profileholders default AND resource_name='PASSWORD_LIFE_TIME'

3. Change the password validity period from the default 180 days to "unlimited":

Sql > ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED

4. Unlock the account

Sql > alter user sys account unlock; are all the contents of this article entitled "how to remove the password limit of 180 days after the expiration of Oracle password". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.