Quick tip to unlock database user account in Oracle Express Edition (XE) – this is among the first things you’d need to do when you start using Oracle XE.
The default user HR in Oracle Express Edition is locked when you first try to login after database installation.
SQL> conn hr/hr ERROR: ORA-28000: the account is locked
This is apparently due to security reasons, and needs to be unlocked by the administrator.
To unlock HR — or any other database user account in Oracle Database XE – follow the steps below.
1. Login to the graphical interface with an administrator account, say SYSTEM.
2. On the Home page, click Administration, and then Database Users.
3. Click on HR.
4. On Manage Database User for HR, do the following:
- Set password for HR.
- Change the Account Status from Locked to Unlocked.
5. That’s it! Verify that the user is now working, by logging in to SQL*Plus:
SQL> conn hr/hr Connected. SQL>
Summary
This article shows you how to unlock database user account in Oracle Express Edition (XE).
Also read: how to find out your Oracle database version, how to find out your Oracle database name, how to starting learning Oracle.
