Basic Oracle XE Skills

Now that you have Oracle Database 10g Express Edition installed on your computer, you are ready to learn some fundamental database management procedures so that you can get started using Oracle XE and troubleshoot problems, if any exist.

Oracle Startup and Shutdown

Chapter 1 explains the fundamental concepts of Oracle databases, database instances, and their relationship to one another in a DBMS. Before anyone can work with an Oracle database, someone must start up the DBMS or database server. Database server startup is an ordered sequence of events that includes the following:

1. Start a database instance.

2. Mount (associate) the physical database to the instance.

3. Open the database.

After a typical server startup, the ...

Get Hands-On Oracle Database 10g Express Edition for Windows now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.