Reset password for "internal" user in Oracle APEX

Reset password for "internal" user in Oracle APEX:

Steps to follow-

-> Go to the location where apex is installed like below-

C:\apex_20.1_en\apex>

-> Open command prompt (Run as administrator) and connect with sqlplus  and login as sysdba

Example as below-

C:\apex_20.1_en\apex>sqlplus

you will get-

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 24 17:37:56 2020

Version 19.3.0.0.0

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

Now enter username-

Enter user-name: / as sysdba

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

-> Run command-  @apxchpwd.sql

Example to reset password as below- 

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] internal

User "internal" does not yet exist and will be created.

Enter internal's email [internal] abc@abc.com

Enter internal's password []

Created instance administrator INTERNAL.

------------------------------------------------------------------------------------------------

Note: New ADMIN’s password (contains 8 characters, at least 1 number and 1 special character).

----------------------------------------

Now try to login again using APEX URL.

http://localhost:portnumber/apex/apex_admin

port number: 

-> To find out which port Oracle Apex web app is configured on-

Open command prompt. Login into oracle as described above and run below sql:

 select dbms_xdb. gethttpport from dual; 

 

-> To change the port which Oracle Apex web app is configured on run below code: 

exec dbms_xdb.sethttpport('8081');

commit;

***In case of any query, Kindly reach me at yogitatripathi1225@gmail.com with Subject line-Query_For_Blog