Activating (Deactivating) Oracle Sample Database

Oracle Database 10g installer came with several sample database, and here is how to activate it.

1. Log into the server home page as SYSTEM (http://localhost:1158/em from the server).
2. Click the "Administration" tab, under "Schema", under "Users and Privileges" look and click at "Users" link.
3. Click the schema link name (It may be HR, OE, SH, or any other link) to display its information.
   An unconfigured user are usually locked, to begin using it choose the "Unlock User" on the "Actions" selection and click "Go".  Then go ahead and confirm the unlock process.
4. After it's unlocked, go ahead and click the "Edit" button (located beside the "Go" button).
   You may notice that its password is expired.  Go ahead and type the new password and confirm it to un-expire the password.  Click Apply.

Now your selected user account (sample database) is ready to use.

After you finished using the sample database, and you want to freeze the database (for future use) you may want to do the reverse process.  Generally all you have to do is :

1. Expire the password.
2. Lock the user schema.

Optionally when you want to really clean the database from the sample database you can also delete the user schema.