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?
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.
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.