i.e.
mvn clean package -Djava.net.preferIPv4Stack=true
update OER1_OER.ENTSECUSERS set ACTIVESTATUS=0 where USERNAME='admin'; select * from OER1_OER.ENTSECUSERS where username='admin'; select * from OER1_OER.CMEEUSERS where ENTSECUSERID='99'; update OER1_OER.CMEEUSERS set ACTIVESTATUS=0 where ENTSECUSERID='99'; commit;3.- Start oer instance again.
--To unlock an user: alter user USERACC ACCOUNT UNLOCK;
--To reset the password: alter user USERACC identified by ARISBP01;
--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;