I just installed Oracle Database Express Edition 11g Release 2.This is the first time I am using
Oracle. Earlier I have used
MSSql and I bet this one is a lot different !
These are the things I see in the
start menu :
To start the oracle database, I click
start database. Then in the prompt I do :
C:\Windows\system32>SQLPLUS / AS SYSDBA SQL*Plus: Release 184.108.40.206.0 Production on Sat Mar 2 20:37:14 2013 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Database 11g Express Edition Release 220.127.116.11.0 - Production SQL> STARTUP ORA-01081: cannot start already-running ORACLE - shut it down first SQL>
I did exactly the same as written in DOCS but then why does I see that message as I run the command
Also certain commands like :
- show databases;
- use database db_name;
don't work in it ! Why is that ?
And isn't there a graphical query browser that comes packed with this RDMS ?