Resolution of Oracle 11g user password expiration

Today, I heard colleagues talk about the Oracle password expiration, only to remember that the Oracle 11g Default user password is valid for 180 days, Oracle 10g Default User password is life. Oracle 11g user Password expiration prompts for an error that ORA-28001 password expires or ORA-28002 password expires. User password expiration may cause problems with the application connection, such as Vcenter using Oracle 11g as a database, and its VPX user password expiration may cause the Vcenter service to fail to run;

Resolving the issue of Oracle 11g user password expiration can be resolved by changing the user's password: ALTER users * * * identified by * *, can also be resolved by changing the password effective date;

To change the password expiration date:

1, first view the user's profile, generally default;

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/3F/F0/wKioL1PM2uXgm04hAAGh-KEUkPU366.jpg "title=" 08.png "alt=" Wkiol1pm2uxgm04haagh-keukpu366.jpg "/>

2. Check the password expiration setting of the specified profile;

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/3F/F0/wKiom1PM2hazIBacAADJSZJmDiw815.jpg "title=" 09.png "alt=" Wkiom1pm2hazibacaadjszjmdiw815.jpg "/>

3. Change the validity period to life;

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/3F/F0/wKiom1PM2liDfdpvAABIZz1DvFk849.jpg "title=" 10.png "alt=" Wkiom1pm2lidfdpvaabizz1dvfk849.jpg "/>

4. Check the password validity setting of the specified profile, and modify the success;

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/3F/F1/wKioL1PM26zC4BN_AAD6M55P_to234.jpg "title=" 11.png "alt=" Wkiol1pm26zc4bn_aad6m55p_to234.jpg "/>

This article is from "Jabbar Superman" blog, please be sure to keep this source http://chopper.blog.51cto.com/3946170/1441002

Resolution of Oracle 11g user password expiration