Friday, 17 January 2014

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