I keep getting database not open error whenever I try committing anything with the user \ as sysdba how do I get started, create a table, create a tablespace and a user?

share|improve this question
Fix your other problem first dba.stackexchange.com/questions/30962/… – Phil Dec 24 '12 at 1:43
Did you check the manual? – BartekR Dec 24 '12 at 8:28

closed as not a real question by Mark Storey-Smith, Paul White, RolandoMySQLDBA, jcolebrand Dec 25 '12 at 2:27

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, see the FAQ.

1 Answer

There are a few steps you need to perform before being able to use the database. 1) install and configure OS 2) create required OS users 3) install Oracle software using the pre-created users 4) create the database 5) start using it.

A very good starting point to look for docu is here Oracle Online Documentation

If you are starting now, it might be a little smarter to start with more up-to-date software and start with 11gR2. Documentation is here Oracle 11gR2 Online Documentation We are close before the release of the next Oracle release.

Start with the installation guides for your platform.

If you have any more questions, feel free to ask; don't forget to mention the OS, OS version and Oracle version. Make the question short with a good description.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.