yt-techie

  Unlock "internal" user password in Oracle APEX -> Go to location where apex is installed- C:\apex_20.1_en\apex> -> connect with sqlplus then / as sysdba -> To unlock the account instead of completely resetting the password, you can use the below PL/SQL block: begin     wwv_flow_security.g_security_group_id := <APEX_WORKSPACE_ID>;     wwv_flow_fnd_user_api.UNLOCK_ACCOUNT('<APEX_ACCOUNT_NAME>');     commit; end; / In detail- -> Go to the location where apex is installed- C:\apex_20.1_en\apex> -> Open command prompt (Run as administrator) and connect as sysdba Example as below- C:\apex_20.1_en\apex>sqlplus You will get- SQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 24 17:37:56 2020 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle.  All rights reserved. Enter user-name: / as sysdba Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 -> Get the worksp...

Reset password for "internal" user in Oracle APEX: Steps to follow- -> Go to the location where apex is installed like below- C:\apex_20.1_en\apex> -> Open command prompt (Run as administrator) and connect with sqlplus  and login as sysdba Example as below- C:\apex_20.1_en\apex>sqlplus you will get- SQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 24 17:37:56 2020 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle.  All rights reserved. Now enter username- Enter user-name: / as sysdba Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 -> Run command-   @apxchpwd.sql Example to reset password as below-  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. ==================...