Create Database   «Prev 

Order the Manual CDB Creation Steps - Exercise

Objective: Put the dependencies for a new single-instance COIN CDB in the correct order.

Use the manual Oracle AI Database 26ai creation path. This is a sequencing exercise; no database commands need to be executed. DBCA is the recommended routine creation tool.

  1. A. Run the reviewed CREATE DATABASE script.
  2. B. Select the unused SID and Oracle home; prepare and review the initialization file, authentication and storage plan.
  3. C. Run the documented CDB dictionary/component initialization, apply required SQL patch changes, verify the database and take a backup.
  4. D. Start the instance in NOMOUNT using the reviewed parameters.
  5. E. On Windows, create the missing service with manual instance startup and ensure the service is available.
  6. F. Connect as SYSDBA to the new idle instance and create the SPFILE from the reviewed PFILE.

Instructions

  1. Submit the six letters in execution order. Treat E as a Windows-only step; explain how the sequence changes on Linux.
  2. Explain why NOMOUNT precedes CREATE DATABASE and why successful creation is not the end of initialization.
  3. Distinguish the root/seed created here from a separately created application PDB.

Self-assessment: 10 points

Compare your response with the model solution. This page does not automatically grade free-text answers.

  1. All six letters in dependency order (6 points; 1 per correct position).
  2. Windows-only service distinction (1 point).
  3. NOMOUNT rationale (1 point).
  4. Postcreation initialization and verification (1 point).
  5. Separate application PDB (1 point).