Oracle DBA Lesson 19 — Is Enterprise Manager Down—or the Database?

When Enterprise Manager will not load, the instinct is to treat the database as down. This lesson separates the management path from...

Read the full lesson

Oracle DBA Lesson 18 — Inspect a PDB with SQL Developer

SQL Developer is another client for the same PDB you already open with SQL*Plus. This lesson connects to LABPDB as COURSE_READER , co...

Read the full lesson

Oracle DBA Lesson 17B — Run a Repeatable SQL*Plus Report

A report you will run again is a script: fixed line and page size, column formats, a spool file, and an exit that means what it says. A...

Read the full lesson

Oracle DBA Lesson 17A — Connect and Check Your SQL*Plus Session

Connect through a service, not through ORACLE_SID . Prove the session: SHOW USER , SHOW CON_NAME , and the USERENV service name. EXIT ...

Read the full lesson

Oracle DBA Lesson 16 — Choose the Right Database Tool

The job picks the tool. SQL*Plus does not create a database. DBCA does not apply redo. A listener can answer while the instance is down...

Read the full lesson