Press "Enter" to skip to content

2 Ways to Unlock Oracle Apex Admin Account

Is your Oracle Apex admin account locked? Use any one method from the following two examples to unlock the Oracle Apex admin account.

Method -1: Using APXCHPWD.SQL Script

You will find this script in your Oracle Apex installation folder. The script apxchpwd.sql not only changes the admin password but also unlocks the admin user.

To run this script, open the command prompt on Windows systems or open terminal in Linux/Mac systems. Then change the current directory to your Oracle Apex installation directory and then run the following commands:

sqlplus sys/yoursyspsw@orcl as sysdba
@apxchpwd.sql

This will prompt you to specify a new password for the admin user. Specify the password, and your admin account will be unlocked.

Method -2: Using APEX_UTIL Package

The alternate approach is to run apex_util.set_security_group_id() and apex_util.unlock_account() procedures to unlock the admin account in Oracle Apex.

To run these commands, open the command prompt/terminal and run the following commands:

sqlplus sys/yoursyspsw@orcl as sysdba
BEGIN
   apex_util.set_security_group_id(p_security_group_id => 10);
   apex_util.unlock_account(p_user_name => 'ADMIN');
END;
/
COMMIT;

Related Tutorials:

Have you found the answer to your question? If not, you can discuss it with me in the comments section below or join my Q&A community OrclQA.com for developers and ask your question. It is FREE.

Vinish Kapoor

Follow

Hi, I am a full stack developer and writing about development. I document everything I learn and help thousands of people. foxinfotech.in is created, written, and maintained by me; it is built on WordPress, and hosted by Bluehost. Connect with me on Facebook, Twitter, GitHub, and get notifications for new posts.

guest
0 Comments
Inline Feedbacks
View all comments