racle11g, after a silent installation, the user's password expiration is set to 180 days by default, and after 180 days the password expires and Oracle prompts to change the password. Our project uses JDBC to connect to Oracle database, unable to automatically handle this kind of Oracle password error prompt, directly connect Oracle failure. Solution One: Periodically modify the database user password. Solution Two: Set the database password to be permanently valid. A certain security protection function, but because the business does not support modifying the database password configuration in the business parts (more parts, modification is too cumbersome, so simply request can not be modified, think a little dwarfish), so decided to adopt the idea two. The specific settings command is as follows: Suppose we are using a database user test, the password is test123456 step one: Log on to the Linux server where Oracle resides (our Oracle assumes on a Linux server), and be aware of the DBA user. Step Two: Execute ' sqlplus/as sysdba ' step three: Enter ' alter profile default limit Password_life_time unlimited; ' and enter step four: input ' alter user test identified by test123456; ' Step five: Enter ' quit; ' Exit Sqlplus. Step Six: Restart the various business parts, all OK. It is important to note that for the fourth step, it may fail because Oracle may have set a limit that cannot be duplicated with the history password when the password is modified, and we can first execute the following command to remove the limit before performing step fourth. Although the password for the fourth step is not changed, but it is necessary, the actual test found that even if you do a third step, if you do not perform fourth step, JDBC connection data will still fail to connect. ' ALTER profile default limit Password_reuse_max unlimited; ' Alter profile default limit Password_reuse_time unlimited; ' when using profile and want to re-use the password, the following conditions need to be met 1) Password_reuse_time and Password_reuse_ When Max is unlimted, you can reset it casually. 2) When you specify Password_reuse_time and Password_reuse_max, the other one unlimted, the password neverReset 3) When Password_reuse_time and Password_reuse_max are specified at the same time, the password can be reset when the Password_reuse_max is satisfied Password_reuse_ Time and Password_reuse_max, you can reset the password to meet Password_reuse_time but from the time of replacement password, that is, Password_reuse_max once also useless password can not be reset . Above this treatment scheme is to repair the current network problem of the remedy, the fundamental to oralce installation when the password expiration limit.
Modify the Oracle password expiration limit
