How to re-open expired or EXPIRED(GRACE)  Oracle database account without changing the password 

Oracle open a account without changing password for EXPIRED(GRACE) .
oracle EXPIRED(GRACE)
Oracle password EXPIRED
oracle ACCOUNT_STATUS EXPIRED(GRACE)
oracle ACCOUNT_STATUS EXPIRED

set linesize 200 pagesize 200 
col username for a20
select USERNAME,EXPIRY_DATE,ACCOUNT_STATUS from dba_users 
where 1=1 
and USERNAME like 'ANUJ%';



USERNAME EXPIRY_DATE ACCOUNT_STATUS
-------------------- -------------------- --------------------------------
ANUJ Feb-12-2017 03:06:30 OPEN
ANUJ1 Aug-17-2016 05:23:26 EXPIRED <<<<<----- 



ANUJ1 account is expired .


Run following Sql to create a sql 

set linesize 2000 longchunksize 300 long 5000 pagesize 0
select 'alter user ' || su.name || ' identified by values' || ' ''' || spare4 || ';' || su.password || ''';'
from sys.user$ su , dba_users du 
where su.name = du.username
and username='ANUJ1'
-- and ACCOUNT_STATUS like '%GRACE%' ;


execute this sql ..

alter user ANUJ1 identified by values 'S:B14311128BF87FFD1643BEF65E94695CAE0AF024E2A19A1EDF939E4DB739;H:895AC434525B471C4EAFEDDCE7A92E68;T:83572A338D2763FE2DDBF96C865557E58B916A1CD9EABA882E2FFF48C4CD69DA08B10582D0AD4FE3DC5CAC43322492C786B47C2BD12F3BA7136065D636BA9A8159AD3EB71BEFC2D754E253D09E5E849C;4A4D264BE7A4FEB0';


User altered.

set linesize 2000 longchunksize 300 long 5000 pagesize 0
select 'alter user ' || su.name || ' identified by values' || ' ''' || spare4 || ';' || su.password || ''';'
from sys.user$ su , dba_users du
where su.name = du.username
--and username='TEST'
-- and ACCOUNT_STATUS like '%GRACE%'
and spare4 like 'S:%'
order by name
;

======

set pagesize 0 linesize 300
SELECT 'alter user ' || name
|| ' identified by values '''
|| spare4
|| ';'
|| password
|| ''''
|| ' Account unlock;'
FROM sys.user$
WHERE name IN (SELECT username
FROM dba_users
WHERE 1=1
-- default_tablespace NOT IN ('SYSTEM', 'SYSAUX')
AND account_status = 'OPEN'
and ORACLE_MAINTAINED='Y'
)
--AND spare4 IS NOT NULL
--AND password IS NOT NULL
;
set pagesize 80 linesize 80

=====

Now user is alerted with old password 



Now Check the status is open ...



set linesize 200 pagesize 200 
col username for a20
select USERNAME,EXPIRY_DATE,ACCOUNT_STATUS from dba_users 
where 1=1 
and USERNAME like 'ANUJ%';


USERNAME EXPIRY_DATE ACCOUNT_STATUS
-------------------- -------------------- --------------------------------
ANUJ Feb-12-2017 03:06:30 OPEN
ANUJ1 Feb-13-2017 05:36:06 OPEN <<<<<----