Apex 5: Admin account is locked

Question

For a long time, I worked on my own workspace. Now I want to create a new workspace, add new users, .... I login into admin account but the account is locked.

I tried to change password and unlock account.

After running the @apxchpwd.sql script. I re-login but not successfully. Please help me to unlock and change admin password.

Answer 1

It's my mistake

I am on APEX 5.0, but you used the apxchpwd.sql of the APEX version that came with RDBMS 12.1.0.2.

I tried again with the 5.0 script and it worked now.