Design a CREATE DATABASE Script for a CDB - Exercise

Objective: Draft a manual Oracle AI Database 26ai CDB creation script and document its prerequisites.

Oracle recommends DBCA for routine CDB creation. This exercise studies the manual SQL path for a new, single-instance COIN lab CDB using Oracle Managed Files (OMF). Submit a design; do not execute the template as part of this exercise.

Assume a reviewed initialization file with DB_NAME=coin, ENABLE_PLUGGABLE_DATABASE=TRUE, UNDO_MANAGEMENT=AUTO, and DB_CREATE_FILE_DEST set to a dedicated, existing, writable lab directory. Memory, control-file and redo placement must also be reviewed for that host. Never point a creation script at an existing database.

Instructions

Draft create_coin.sql using OMF, explicit SYS and SYSTEM password placeholders, AL32UTF8/AL16UTF16 character sets, a locally managed SYSTEM tablespace, default permanent/temporary tablespaces, an undo tablespace, and ENABLE PLUGGABLE DATABASE LOCAL UNDO ON.
Explain how OMF supplies root and seed file names, and why omitted file sizes and redo/control-file settings still require review. No sample size is a production sizing recommendation.
State the required administrative connection and startup state. Explain which containers the statement creates and what remains before application use.
Submit the redacted script plus prerequisite and follow-up notes. Never include actual SYS or SYSTEM passwords.

Self-assessment: 30 points

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

Correct COIN name, OMF assumptions and unused destination (5 points).
SYS/SYSTEM placeholders with no secrets (5 points).
Character sets and local extent management (5 points).
Permanent, temporary and undo clauses (5 points).
CDB/local undo clauses and root/seed distinction (5 points).
SYSDBA/NOMOUNT, configuration review and follow-up work (5 points).