How to change Apex Admin Password

• Introduction: Oracle APEX is a low-code development platform that helps you build scalable, secure enterprise apps. To access the APEX, we need ADMIN credential. This guide will walk you through to change Apex Admin Password.

• Prerequisites: Oracle Apex should be installed.

• Environment Used:
  Hostname: apex
  IP: 192.168.101.10
  ORACLE_SID : APEXDB
  PDB: APEXPDB
  Apex: 24.1
  ORDS: 24.2
  
  
• Now let's change the ADMIN password.
  
  

1. You will get below error if ADMIN password is incorrect.

2. Stop running ORDS services by killing its PID.

3. Now change the password using below steps:

[oracle@apex ~]$ cd /u02/app/oracle/apex24_1/apex/
[oracle@apex apex]$ ls
apexins1.sql 			apex_rest_config_nocdb.sql  apxdvins_nocdb.sql 
apxremov_nocdb.sql  		builder  devins.sql	apxrtins_nocdb.sql
apexins2.sql            	apex_rest_config.sql apxdvins.sql      
apexins3.sql            	appins.sql          apxdwngrd.sql      
apexins_adb.sql         	apxappcon.sql       apxpatch_cdb.sql   
apexins_cdb.sql         	apxchpwd.sql        apxpatch_nocdb.sql 
apexins_nocdb.sql       	apxdevrm_cdb.sql    apxpatch.sql       
apexins.sql             	apxdevrm_nocdb.sql  apxremov1.sql      
apex_rest_config_cdb.sql	apxdevrm.sql       apxremov2.sql      
apex_rest_config_core.sql 	apxdvins_cdb.sql  apxremov_cdb.sql   
apxremov.sql       		core          	images
apxrtins1.sql      		coreins2.sql  	install2024-09-25_04-11-58.log
apxrtins2.sql      		coreins3.sql  	LICENSE.txt
apxrtins3.sql      		coreins4.sql  	load_trans.sql
apxrtins_cdb.sql  		coreins5.sql  	utilities
coreins.sql			apxrtins.sql       dbcsconf.sql
apxsilentins.sql   dbcsins.sql	
[oracle@apex apex]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Mar 24 18:12:21 2025
Version 19.24.0.0.0

Copyright (c) 1982, 2024, Oracle.  All rights reserved.

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.24.0.0.0

SQL> show pdbs
     CON_ID CON_NAME                             OPEN MODE  RESTRICTED
---------- ------------------------------------- ---------- ----------
         2 PDB$SEED                             READ ONLY  NO
         3 APEXPDB                              READ WRITE NO

SQL> alter session set container=APEXPDB;

Session altered.

SQL> show pdbs
     CON_ID CON_NAME                             OPEN MODE  RESTRICTED
---------- ------------------------------------- ---------- ----------
         3 APEXPDB                              READ WRITE NO

SQL> @apxchpwd.sql
...set_appun.sql
================================================================================
This script can be used to change the password of an Oracle APEX
instance administrator. If the user does not yet exist, a user record will be
created.
================================================================================
Enter the administrator's username [ADMIN]
User "ADMIN" exists.
Enter ADMIN's email [xxxxxxxxxxx@gmail.com]
Enter ADMIN's password []    
 ----> Provide the password & keep a note of it.
Changed password of instance administrator ADMIN.

SQL>

4.  Now Access the Apex Admin via browser with new password:
http://192.168.101.10:8080/ords/apex_admin

Apex Admin Login

Admin Home

Thanks for visiting!!