How to reset password in Oracle 11g
1. Reset password
In order to reset a password in Oracle 11g:
- Log in as a system user through sqlplus or any oracle client.
- Run this command: alter user <user_name> identified by <password>
2. Turn off password expiration
In order to turn off the password expiration for a particular user, do the following:
- First of all, check which profile the user is using by running this command:
select profile from DBA_USERS where username = ‘<user_name>’
- Then, change the limit to never expire using:
alter profile <profile_name> limit password_life_time UNLIMITED;
- You can always check the password limit of your user using:
select resource_name,limit from dba_profiles where profile='<profile_name>’;