Introduction to Oracle Database architecture, accessing an instance, and starting up/shutting down the database. Database Creation Creating databases using Database Configuration Assistant (DBCA) or manual SQL commands. Connectivity
5. Preparing for the Oracle Certified Professional (OCP) Credential
Create and secure database accounts following least-privilege principle. Phase 3: Security and Data Movement No
Utilizing Database Configuration Assistant (DBCA) to create container databases. Managing Database Instances
| Component | Description | 19c Specifics | |-----------|-------------|----------------| | | System Global Area (shared memory) + Program Global Area (private memory) | In-Memory Column Store (optional) | | Processes | Background, user, and server processes | More automatic processes (e.g., space advisor) | | Storage | Data files, control files, redo logs, parameter file | Multitenant architecture (CDB/PDB) | and relocate them.
: A key focus of 19c is managing Pluggable Databases (PDBs) —learning to create them from seeds, clone them, and relocate them. Phase 3: Security and Data Movement
No. 23ai is a separate database version. However, the 19c guide includes a preface comparing 19c to 23ai for those planning migrations. Introduction to Oracle Database architecture
: Understanding the Oracle Database instance and storage structures.
Based on the official curriculum, the updated 19c Administration Workshop focuses on these key areas: