Oracle 11g Password Expiration Problem Solving method

ORACLE 11G Password Expiration issue:

1. Use the Oracle user to enter the SQL Editor to execute the Change password (original password, remain unchanged) command
Sql>alter user username identified by "password";

2, the view user's proifle is that, generally is the default:
Sql>select username,profile from Dba_users;

3. View the password expiration settings for the specified profile (such as default):
Sql>select * from Dba_profiles s WHERE s.profile= ' DEFAULT ' and resource_name= ' password_life_time ';

4. Change the password validity period from the default of 180 days to "unlimited":
ALTER profile DEFAULT LIMIT password_life_time UNLIMITED;

5, restart the application services.

Database Restart steps:
1. Open SecureCRT and connect to the Linux machine where the database resides. If the user is root, please enter the command "Su-oracle" and return to the password, enter the password and return to the Oracle user.

2. Turn off Oracle's listening process: The command is "Lsnrctl stop" and enter, when the external cannot connect to the database. You are prompted to close the success message.

3. Kill all Sessions First, "Ps-ef|grep $ORACLE _sid|grep-v ora_|grep Local=no|awk ' {print $} ' |xargs kill ' can also be used in other ways. Then log in to the database with Sqlplus. The commands are: "Sqlplus/nolog"-"Connect/as sysdba", and finally the Oracle database "shutdown immediate" is closed with a command. When you close the command, you need to wait for some time, and then the prompt will be successful.

4. Exit Sqlplus with the command "exit". Then use the command "Lsnrctl start" to start the listening process for the database. The prompt statement indicates that the startup was successful.

5. Log in to the database with Sqlplus first. The commands are: "Sqlplus/nolog"-"Connect/as sysdba". Then type the command "Startup" and enter. Wait a few minutes for the prompt message to appear. Finally, exit Sqlplus with the command "exit".

Reference Link: https://zhidao.baidu.com/question/331648255.html

Oracle 11g Password Expiration Problem Solving method