It happens that you forget your master ADMIN password for the apex_admin page. Here are the two widely user methods to change it and unlock the Admin account:
- Use @apxchpwd.sql script in your APEX directory. To run it, navigate to the directory through bash or Command prompt. Connect to your database as SYS and run the file. You will be asked for a new password. Set it and you are done.
- If the above method does not work for any reason, you can manually unlock the account and change the password.
update apex_050000.wwv_flow_fnd_user
set web_password = 'set_new_password'
where user_name = 'admin'
and security_group_id = 10;
commit;
alter session set current_schema = apex_050000;
begin
wwv_flow_security.g_security_group_id := 10;
wwv_flow_fnd_user_api.unlock_account ('admin');
commit;
end;
thank you. i finally got this working. apxchpwd didnt work for me.
LikeLike