Unlock Database User Account in Oracle Express Edition

February 19, 2011

in DBA, ORA Errors

Unlock User Account in Oracle Express Edition

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.

Oracle XE Administration

Oracle Database Users

3. Click on HR.

Manage Database Users

4. On Manage Database User for HR, do the following:

  • Set password for HR.
  • Change the Account Status from Locked to Unlocked.

Unlock Database User

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 }

1 Sü Smith March 23, 2011 at 2:16 am

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. 😉

2 Sü Smith March 23, 2011 at 2:17 am

Ha that may have sounded weird. I consider myself a beginner newbie. 😀

3 oratabler March 23, 2011 at 8:31 am

Hi Sü, Thanks for your comment. Glad to be of help!

4 suresh February 27, 2014 at 5:52 pm

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

5 Manivel May 15, 2014 at 4:25 pm

how to unlock an Administrator(SYSTEM) account. If no other account has DBA privilege???

Leave a Comment

Previous post:

Next post: