Create Database   «Prev  Next»

Run and Verify a Lab CDB Creation Script - Exercise

Objective: Describe or perform controlled execution of a reviewed COIN CDB creation script and verify the outcome.

Use the script designed in the preceding exercise only after an instructor or lab administrator has approved it for a new disposable database. Confirm the unused SID, correct Oracle home, secure credentials, storage locations and initialization file. CREATE DATABASE can destroy data in specified existing files. If no suitable lab is available, submit a clearly labeled execution plan.

Instructions

  1. Show the SQL*Plus connection, NOMOUNT startup and script invocation. Use an explicit reviewed PFILE path or a verified SPFILE; never substitute a production SID.
  2. Describe the postcreation catcdb.sql step, patch/component work and verification queries. Do not paste passwords or fabricated successful output.
  3. Report either actual redacted observations or expected outcomes clearly labeled as a plan: database name/CDB flag/open mode, seed state and component status.
  4. Explain how you would respond to a creation error and when you would take a baseline backup.

Self-assessment: 10 points

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

  1. Correct target/prerequisites and connection (2 points).
  2. NOMOUNT and reviewed script invocation (2 points).
  3. CDB initialization and patch follow-up (2 points).
  4. Queries with truthful expected/observed outcomes (2 points).
  5. Controlled failure handling and backup (2 points).