DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Tuesday, March 17, 2015

Unlock APEX admin user (when apxchpwd.sql doesn't work) 

 

 

  1. sqlplus / as sysdba
  2. sql > alter user APEX_040000 account unlock;
  3. sql > conn  APEX_040000/password;
      Create any password for APEX_040000 user ,
  1. sql >
    begin
    wwv_flow_api.set_security_group_id(p_security_group_id=>10); 
    wwv_flow_fnd_user_api.create_fnd_user( 
      p_user_name => 'admin2', 
      p_email_address => 'dev@null.com',
      p_web_password => 'admin2') ; 
    end;
    /
    commit
    / 
  2. sql > alter user APEX_040000 account lock;
then try with ,

login to apex_admin
http://localhost:7780/pls/apex/apex_admin


 

No comments: