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

What are the ways to change the validity limit of oracle passwords? I believe that many inexperienced people are at a loss about this, so this article summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

Bug description:

Oracle11g, the password validity period of the user after silent installation is set to 180 days by default. The password will expire after 180 days. Oracle will prompt you to change the password.

Our project uses jdbc to connect to the oracle database, so we can't automatically handle the password error prompt of oracle, so we just failed to connect to oracle.

Solution idea 1:

Change the database user password regularly.

The second solution is:

Set the database password to be permanent.

Idea one has a certain role of security protection, but because the business does not support modifying the database password configuration in business components (there are too many parts, it is too troublesome to modify, so it is simply required that it cannot be modified, it is a bit difficult to think about it), so I decided to adopt idea two.

The specific setting commands are as follows:

Suppose the database user we are using is test and the password is test123456

Step 1: log in to the linux server where oracle is located (our oracle assumes that it is on the linux server), and be careful to use dba users.

Step 2: execute 'sqlplus / as sysdba'

Step 3: enter 'alter profile default limit password_life_time unlimited;' and enter

Step 4: enter 'alter user test identified by test123456;'

Step 5: enter 'quit;' to exit sqlplus.

Step 6: restart all business components, all OK.

It is important to note that for step 4, it may fail because oracle may set a limit that cannot be repeated with historical passwords when changing passwords. We can first execute the following command to remove the restrictions, and then perform step 4. Although the password has not changed before and after setting for the fourth step, is it necessary? in the actual test, it is found that even if the third step is processed, if you do not perform the fourth step, jdbc will still fail to connect to the data.

'alter profile default limit password_reuse_max unlimited;''alter profile default limit password_reuse_time unlimited;'

When using profile and want to reuse passwords, the following conditions need to be met

1) when both password_reuse_time and password_reuse_max are unlimted

You can reset it at will.

2) when specifying one of password_reuse_time and password_reuse_max and the other unlimted

The password can never be reset.

3) when both password_reuse_time and password_reuse_max are specified

The password can be reset when the password_reuse_max is met

The password can be reset when both password_reuse_time and password_reuse_max are met

The password cannot be reset when password_reuse_time is met but the password has never been changed, that is, when password_reuse_max is useless once.

The above solution is a remedial measure to fix the existing network problems, and the limit of password validity should be removed at the time of oralce installation.

After reading the above, do you know how to change the validity limit of oracle password? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

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.