APEX管理账号解锁

On By 去哪儿

问题现象：后台管理登录时提示账户已锁定

先尝试切换到PDB，重启tomcat服务，如还是提示锁定，尝试再试方式一和二

[oracle@localhost apex]$ sqlplus / as sysdba
SQL> alter session set container = orclpdb1;
SQL> exit;

方式1：通过脚本重置密码

通过执行脚本，不仅更改了密码，也实现了账户解锁；

[oracle@localhost ~]$ cd /u01
[oracle@localhost u01]$ cd apex/
[oracle@localhost apex]$ ls | grep apxchpwd
apxchpwd.sql
[oracle@localhost apex]$ sqlplus / as sysdba
SQL> alter session set container = orclpdb1;
SQL> @apxchpwd.sql
...set_appun.sql
================================================================================
This script can be used to change the password of an Application Express
instance administrator. If the user does not yet exist, a user record will be
created.
================================================================================
Enter the administrator's username [ADMIN] 
User "ADMIN" exists.
Enter ADMIN's email [ADMIN] 
Enter ADMIN's password [] 
Changed password of instance administrator ADMIN.

方式2：使用APEX_UTIL Package

[oracle@localhost apex]$ sqlplus / as sysdba
SQL> alter session set container = orclpdb1;
SQL> BEGIN
  2  apex_util.set_security_group_id(p_security_group_id => 10);
  3  apex_util.unlock_account(p_user_name => 'ADMIN');
  4  END;
  5  /
SQL> COMMIT;

注：执行完成后，如果还是提示锁定问题，尝试重启下tomcat服务、启停监听、启停数据库