Wednesday, December 15, 2010

Unlock HR Account

If you are a newbie to Oracle XE, this article will be definite help. Whenever xe is installed it comes default with HR schema however the shcema/user will be in locked/expired state. So to continue to create connection to hr account we first need to unlock the HR schema/user.

To unlock the HR Schema that will be used in the lab, please follow these steps.

    Your database should have the HR schema enabled.
    To do this, from a command line issue the command: sqlplus system
    Provide the password for the system user.
    In the SQLPLUS prompt write the following command Alter user HR account unlock ;
    Alter user HR identified by HR;
   


Protected by Copyscape Unique Content Check