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.
{ 5 comments… read them below or add one }
Very simple tutorial. Thank you so much for the share. I’m so glad you have even the most basic tutorials for the beginner newbies. 😉
Ha that may have sounded weird. I consider myself a beginner newbie. 😀
Hi Sü, Thanks for your comment. Glad to be of help!
For UNLOCKING HR account in 64bit system, follow below steps
1.Go to start ->oracle 11g Express Edition->Run SQL Command Line
2.conn system/hr (password which you gave while XE DB installation)
3.ALTER user hr IDENTIFIED BY hr account UNLOCK;
4.Now try to login with hr user
thanks
how to unlock an Administrator(SYSTEM) account. If no other account has DBA privilege???