Oracle DBA Lesson 24A — Create a Database with DBCA

Installing Oracle Database gives you the engine and the tools. It does not give you a database. DBCA creates the files, the containers,...

Read the full lesson

Oracle DBA Lesson 23B — Recover from a Bad Startup Setting

A saved startup setting can stop Oracle before the database opens. Find the bad value in the error stack, test one correction in a sepa...

Read the full lesson

Oracle DBA Lesson 22A — Where Did Startup Stop?

Oracle starts in three stages: NOMOUNT, MOUNT, and OPEN. Each stage needs different files. The stage Oracle reached is why the database...

Read the full lesson

Oracle DBA Lesson 21E — Why Dates and Numbers Look Different

A DATE is not the characters on the screen. SQL*Plus turns that value into text with the session's date mask, so one stored day pri...

Read the full lesson