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...

  1. Go to http://servername[:port]/pls/apex/f?p=4550:1

  2. Enter "INTERNAL" for the Workspace

  3. Enter "ADMIN" for the Username

  4. 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 ADMIN

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

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

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.