Primeiro, devemos ir até a pasta que abriga a instalação do Apex, checar se o arquivo “apxchpwd.sql” está hospedado lá, e posteriormente é só executá-lo no banco de dados para proceder com a alteração da senha:
[oracle@oel7 ~]$ cd $ORACLE_HOME/apex
[oracle@oel7 apex]$ ls -la apxchpwd.sql
-rw-r--r-- 1 oracle oinstall 4016 Nov 8 2019 apxchpwd.sql
[oracle@oel7 apex]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jan 22 13:40:58 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> @apxchpwd.sql
...set_appun.sql
================================================================================
This script can be used to change the password of an Application Express
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 [ADMIN]
Enter ADMIN's password []
Changed password of instance administrator ADMIN.
SQL>
Portuguese
English
Spanish