APEX ADMIN Login
The ADMIN account is the master account for logging into the INTERNAL workspace. To login to the Administrator section of Oracle Applications Express (if you don't have your own login or your own login does not have administrative rights)...
In your browser...
Go to http://servername[:port]/pls/apex/f?p=4550:1
Enter "INTERNAL" for the Workspace
Enter "ADMIN" for the Username
Enter the Password
Check ADMIN Login
SET SERVEROUTPUT ON
BEGIN
dbms_output.put_line(apex_instance_admin.get_parameter('DISABLE_ADMIN_LOGIN'));
END;
/
If the value returned is 'Y' then you will NOT be able to login to the INTERNAL workspace as ADMINEnable ADMIN Login
ALTER SESSION SET CURRENT_SCHEMA = APEX_040200;
BEGIN
APEX_INSTANCE_ADMIN.SET_PARAMETER('DISABLE_ADMIN_LOGIN', 'N');
commit;
END;
/
Disable ADMIN Login
ALTER SESSION SET CURRENT_SCHEMA = APEX_040200;
BEGIN
APEX_INSTANCE_ADMIN.SET_PARAMETER('DISABLE_ADMIN_LOGIN', 'Y');
COMMIT;
END;
/
Change ADMIN Password
cd ${APXDIR}
sqlplus / as sysdba
@apxchpwd.sql
exit
Remember to update your secure password store with the new value.Bibliography
http://apexblog.nl/oracle-apex-info/sub-apex-installation-configuration/89-reset-the-apex-administrator-password.html http://kb.initso.at/2013/08/how-to-unlock-apex-admin-without-changing-the-password/ https://apextips.blogspot.com/2016/01/apex-instance-admin-preferences-cheat.html
https://support.oracle.com'Unauthorized Access' Message When Trying to Login with Admin User on Workspace Internal or HTTP-404/HTTP-503 When Trying to Login via APEX_ADMIN URL (Doc ID 1504899.1)