Complete Oracle Database Administration course (19C,21C)

Explore Oracle architecture and the physical database files, including control, data, and online redo logs, plus initialization, password, and backup files and ASM storage.

Explore common Oracle server configurations, including single and multiple instance databases, and Oracle real application clusters, where multiple instances on shared storage across nodes boost throughput and scalability.

Configure a virtual machine with VirtualBox to run Oracle Linux on a Windows host, detailing host-guest roles and bridged and host-only networking.

Explore Oracle memory structures, including SGA, library cache, and data dictionary cache, that store data and execution plans; examine database buffer cache, redo log buffer, and PGA for performance.

Learn Oracle memory management options, including automatic memory management, automatic shared memory management, and manual mode. Configure memory targets, SGA and PGA, and monitor with show parameter and v$memory_target_advice.

Discover how an Oracle instance uses memory structures and background processes, including db writer, checkpoint, log writer, archiving, and system monitor, to ensure fast commits, data integrity, and recovery.

Explore Oracle multitenancy, using a container database with a root container and seed, enabling multiple pluggable databases with shared undo and maintenance at the CDB level.

Explore Oracle Enterprise Manager Express, now Java-based in Oracle 19c, and learn that only the performance menu is available, with user security, memory, and storage management not currently supported.

Explore how Oracle instance initialization parameters configure a database, including SPFILE and PFILE usage, scope, and how derived and static parameters impact performance and memory.

Explore the automatic diagnostic repository (adr) centralizing trace files and the alert log. Use adrci to view incidents, manage homes, and purge data with time-based or size-based retention.

Explore the Oracle data dictionary, a metadata repository of objects and privileges. Learn to query dynamic and permanent views to monitor schema changes and access.

Explore creating pluggable databases from the seed in a multitenant Oracle database, including locating data files, using the create pluggable database statement, and opening PDB2 in read-write mode.

Clone pluggable databases from a source PDB to a new PDB on a local or remote CDB. Choose hot cloning for read-write, or cold cloning for read-only.

Learn how to create and manage refreshable clone pluggable databases, enabling automated or manual refreshes with recent redo for cloud migrations and minimal downtime.

Unplug and plug pluggable databases (PDBs) into and from a container database (CDB) using XML metadata, with no-copy, copy, and move options.

Unplug and plug a pluggable database via a compressed archive file containing data and metadata; choose extension to generate xml or archive, then open pdb in read/write mode across cdbs.

Learn how to safely drop a pluggable database (PDB) by stopping or unplugging it, choosing to keep or delete data files, and verifying no active connections before the drop.

Explore how Oracle Net, the listener, and dynamic service registration enable clients to connect to Oracle databases using service names, connect strings, and tnsnames.ora configurations.

Review the Oracle connection process from connect string to listener to server process, and compare dedicated versus shared server configurations, including database links and tennis ping troubleshooting.

Create and manage common and local database users by assigning authentication methods, passwords, quotas, default and temporary tablespaces, and profiles in a multitenant Oracle environment.

Discover how Oracle manages privileges and roles, from system and object privileges with admin options, to common and local roles in multi-tenant environments, including password protected role concepts.

Revoke table privileges from a role or user, drop roles and users in Oracle, and use cascade to remove a user’s schema objects or drop without cascade if none exist.

Explore Oracle database authentication options: password, operating system, password-file, AWS authentication, and strong SSL or directory authentication, and see how OS groups grant admin privileges and enable secure access.

Learn to design and enforce database resource limits with profiles, restricting CPU, memory, and disk I/O, connect and idle times, and concurrent sessions to protect the server.