Unlock password for "internal" user in Oracle APEX
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 workspace Id for the “INTERNAL” workspace:
SQL> SELECT workspace_id FROM apex_workspaces WHERE workspace = 'INTERNAL';
WORKSPACE_ID
------------
10
-> Get the APEX schema’s name for your version:
SQL> select username from dba_users where username like 'APEX%' order by 1;
USERNAME
-------------------------------
APEX_200100
APEX_INSTANCE_ADMIN_USER
APEX_LISTENER
APEX_PUBLIC_USER
APEX_REST_PUBLIC_USER
-> Switch your session to the APEX-schema:
SQL> alter session set current_schema = APEX_200100;
Session altered.
-> Now run below block to Unlock your ADMIN account:
SQL> begin
wwv_flow_security.g_security_group_id := 10;
wwv_flow_fnd_user_api.UNLOCK_ACCOUNT('ADMIN');
commit;
end;
/
PL/SQL procedure successfully completed.
-----------------
Now try to login again using APEX URL.
http://localhost:portnumber/apex/apex_admin
Port number:
-> To find out which port Oracle Apex web app is configured on-
Open command prompt. Login into oracle as described above and run below sql:
select dbms_xdb. gethttpport from dual;
-> To change the port which Oracle Apex web app is configured on run below code:
exec dbms_xdb.sethttpport('8081');
commit;
***In case of any query, Kindly reach me at yogitatripathi1225@gmail.com with Subject line-Query_For_Blog
Awesome...
ReplyDelete