Tuesday, February 17, 2015

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


--To unlock an user:

alter user USERACC ACCOUNT UNLOCK;


--To reset the password:

alter user USERACC identified by ARISBP01;


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

--To Keep same Password:



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

from dba_users d, sys.user$ u

where d.username = upper('USERACC ')

and u.user# = d.user_id; 



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





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

ALTER PROFILE DEFAULT LIMIT password_life_time UNLIMITED;

Don't forget to commit;

1 comment:

  1. Oracle SOA/BPEL 11g --- "
    Oracle SOA/BPEL 11g Online Training

    Send ur Enquiry to contact@21cssindia.com
    Overview of Service Oriented Architecture (SOA)
    Overview of SOA
    Advantage in using SOA
    Why is SOA 11g Important
    Building Blocks of SOA" more… Online Training- Corporate Training- IT Support U Can Reach Us On +917386622889 - +919000444287 http://www.21cssindia.com/courses/Oracle-soa-bpel-11g-online-training-206.html

    ReplyDelete