Embedded Files
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
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
Enable ADMIN Login
ALTER SESSION SET CURRENT_SCHEMA = APEX_040200;
BEGIN
APEX_INSTANCE_ADMIN.SET_PARAMETER('DISABLE_ADMIN_LOGIN', 'N');
commit;
END;
/
APEX_040200APEX_050100APEX_180300APEX_190100
Disable ADMIN Login
Disable ADMIN Login
ALTER SESSION SET CURRENT_SCHEMA = APEX_040200;
BEGIN
APEX_INSTANCE_ADMIN.SET_PARAMETER('DISABLE_ADMIN_LOGIN', 'Y');
COMMIT;
END;
/
APEX_040200APEX_050100APEX_180300APEX_190100
Change ADMIN Password
Change ADMIN Password
NOTE: These instructions uses variables that should have been set in the .profile of the oracle database/apex software owner (usually 'oracle') at login.
cd ${APXDIR}
sqlplus / as sysdba
@apxchpwd.sql
exit
Remember to update your secure password store with the new value.Bibliography
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)
Page updated
Google Sites
Report abuse