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>’;