Thursday, April 23, 2015

OER 12c - how to unlock admin user

Before starting the default credentials for admin user is:
admin/weblogic1

Now if you got this locked, you  need to do the following.

1.- Stop the oer instance.

2.- Login into the OER databse schema and perform the following commands


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.