Oracle XEr2 Enable HR Schema

Oracle XEr2 Enable HR Schema

So now that we have the XE installed lets enable your HR Schema.

Log into the sqlplus and execute this:

Alter user hr identified by hr account unlock;

Then you can log into the Schema

#bearMan

Oracle XEr2 Check Database

Oracle XE SQLPLUS

Now that we have out Oracle XEr2 Database Installed Lets use our Main “DBA” tool, sqlplus.

What you can do is run Command Prompt or Terminal

Type:

Sqlplus / as sysdba

You should log in. If you don’t

You will need to go into the File the contains SQLPLUS.

Mine was:

C:\oraclexe\app\oracle\product\11.2.0\server\bin

Cd C:\oraclexe\app\oracle\product\11.2.0\server\bin

Once there you can run that command.

Run

Selext * from dual;

If you get this command it means your database is running.

Have fun selecting J

#bearMan