Monday, August 3, 2009

Problem after resetting ADMIN password after running apxchpwd.sql

I ran into problem when i forgot my password for ADMIN user in APEX. I logged in as sys on database and executed apxchpwd.sql. All went fine no errors. The trouble started when i was trying to login to apex_admin page (http://nbi2crm3.colorline.com:7777/pls/apex/apex_admin).

I got error Application access restricted to internal workspace users. I was also not able to login to my workspace since when i tried to login i was redirected to change password page and when i supplied the old and new password APEX claimed that old password was wrong all the time.

Well i was stucked and didn't get login either to APEX admin or my workspace. Then i
saw a notice on APEX forum and this helped my out of the problem. The answer to the problem which helped me out was the following:




login to database as sys

alter session set current_schema = APEX_030200;

update wwv_flow_fnd_user
set change_password_on_first_use ='N'
where lower(user_name) = 'admin'
/
commit
/



This helped me out of the problem, now i was able to login to apex_admin and also to login to my workspaces.

Hope this also could help other if they get problem after running apxchpwd.sql.

4 comments:

Paul said...

Had the same issue, this was also my solution.

josh said...

Very helpful, thanks!

Sergey Panov said...

SQL> update apex_040000.wwv_flow_fnd_user set change_password_on_first_use ='N'
where lower(user_name) = 'admin';

x said...

Very helpful, thanks!