APEX

Unlock Database 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.

[click to continue…]

{ 5 comments }

Oracle Database Express Edition (Oracle XE)

Oracle Database Express Edition (Oracle Database XE) is a free, lightweight version of Oracle.

If you’re a small enterprise with modest database needs, or an individual looking to learn Oracle on your home computer, Oracle Express Edition is just the answer for you.

This starter version of Oracle is free to download, distribute and deploy. It supports up to 4GB of user data, in addition to Oracle system data.

A demo database called HR is provided with the installation.

[click to continue…]

{ 0 comments }