Ameer Khan

How to change admin password in Apex 23.2

In apex , admin password can be changed using two methods such as

Method 1. By executing apxchpwd.sql

Method 2. By executing sql command

Method 1. By executing apxchpwd.sql

Login to Database server  and navigate to apex installation folder and execute apxchpwd.sql as sys user.

[oracle@ocisoumya-2 ~]$ cd /u01/apex/apex/ [oracle@ocisoumya-2 apex]$ sqlplus / as sysdba   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 [ADMIN] Enter ADMIN’s password [] Changed password of instance administrator ADMIN.

Method 2. By executing sql command

Login to database as sys user and set the current schema as your existing apex version.

SQL> select username from dba_users where username like ‘APEX%’;   USERNAME ——————————————————————————– APEX_LISTENER APEX_PUBLIC_USER APEX_REST_PUBLIC_USER APEX_230200   SQL> alter session set current_schema=APEX_230200 ;   Session altered.   SQL> set lines 222 SQL> COLUMN first_name FORMAT A20 SQL> COLUMN last_name FORMAT A20 SQL> COLUMN default_schema FORMAT A30 SQL> COLUMN user_id Format 9999999999999   SQL> SELECT user_id, first_name,last_name, default_schema FROM   wwv_flow_fnd_user WHERE  user_name = ‘ADMIN’ ORDER BY last_update_date DESC;  2    3              USER_ID FIRST_NAME           LAST_NAME            DEFAULT_SCHEMA —————— ——————– ——————– ——————————   1395498604080259                                           APEX_230200   SQL>   Set the ADMIN user password for the id we retried from above query   SQL> UPDATE wwv_flow_fnd_user SET    web_password = ‘NewApexPAssword’ WHERE  user_name = ‘ADMIN’ AND    user_id = 1395498604080259;      Unlock ADMIN user :-   SQL> BEGIN   WWV_FLOW_SECURITY.g_security_group_id := 10;   WWV_FLOW_FND_USER_API.unlock_account(‘ADMIN’);   COMMIT; END; /