When oracle db password expires

Use this instructions to unlock the user account when the password is expired:

--check user status
select username, expiry_date, account_status from dba_users where username = 'USERACC';

view source

print?

1	--To unlock an user:

2

3	alter user USERACC ACCOUNT UNLOCK;

view source

print?

1	--To reset the password:

2

3	alter user USERACC identified by ARISBP01;

--But we'd like to use the existing password so we proceed with:

view source

print?

01	--To Keep same Password:

02

03

04

05	select 'alter user "'||d.username||'" identified by values '''||u.password||''';'

06

07	from dba_users d, sys.user$ u

08

09	where d.username = upper('USERACC ')

10

11	and u.user# = d.user_id;

view source

print?

1	alter user "USERACC " identified by values '4301288F751F9615';

2

3

4

5

6

7	--On a production system, has to change this limit to unlimited to solve this and to avoid this in future.

8

9	ALTER PROFILE DEFAULT LIMIT password_life_time UNLIMITED;

view source

print?

1

view source

print?

1	<span style="font-family: Arial, Helvetica, sans-serif; white-space: normal;">Don't forget to commit;</span>