Oracle Database Administration for JuniorDBA/Oracle cloud.

Explore how an Oracle database instance, stored in memory, loads data and persists it on disk through physical files using SAN and NAS storage.

Explore Oracle server processes and architecture, including dedicated and shared server processes, background processes, and connection handling with memory considerations and pooling.

Explore how the Oracle shared pool, library cache, and dictionary cache manage parsing and permissions, using soft vs hard parses, cache hits, and flush strategies to optimize performance.

Understand how the redo log buffer stores redo entries for changes in the buffer cache and writes them to disk to enable recovery, while modified blocks are written asynchronously.

The checkpoint process synchronizes modified memory blocks with disk data to ensure memory-disk consistency and aid recovery, generating a system change number stored in data and control files.

Explain the PMON process and its role in process recovery, cleaning up changes in the database buffer cache, and releasing resources from failed user sessions while monitoring database processes.

Describe the recovery process as the bedrock of distributed database transactions, ensuring commit or rollback across multiple databases and automatically cleaning up in-doubt actions.

Explore how tnsnames.ora acts as a client side configuration file that stores connection aliases, mapping host, port, protocol, and service name to connect via the Oracle listener.

The lecture explains how a client resolves a dns alias such as sales from dns name file, reads connection information, and connects to the sales_db service through a server process.

Explore how Oracle database storage uses multiple on-disk file types, including data files for stored data, redo log files for committed transactions, and the alert log for errors and monitoring.

Explore how data files store users and application data, including metadata, and how blocks, extents, and segments organize storage inside tablespaces.

Discover the special Oracle tablespaces created automatically—system tablespace, undo tablespace, and temporary tablespace—and their roles in metadata storage, rollback, transient work areas, and why you should not create tables there.

Understand redo log files, the cyclic transaction logs used for crash recovery, and how multiplexing and log groups provide redundancy. Learn why losing or deleting these logs prevents database startup.

Learn to identify and protect database backup files and archived redo log files, and perform point in time recovery using roll forward recovery to restore a consistent database.

Review the spfile, a binary server parameter file that stores instance settings like sga_target and pga_target. Understand how the DBA password file and the alert log support security and troubleshooting.

Compare single instance architecture with multitenant container databases, showing how an Oracle instance hosts multiple pluggable databases within a container database.

Discover backward compatibility enabling migration to the Oracle multitenant architecture. Copy an 11g database, create a PDB in a 12c container, connect, and consolidate users and applications with separate PDBs.

Explore four Oracle shutdown options: shutdown abort, shutdown immediate, shutdown production, and checkdown, highlighting crash recovery with redo log files when the instance is not cleanly shut down.

Navigate the Oracle database startup sequence from normal to open state, detailing how the instance reads the control file and starts data files and redo logs to enable read/write access.

Prepare Oracle installation by configuring prerequisites, hardware, host name resolution, and creating dedicated storage and Oracle directories with proper ownership and permissions.

Set up and configure Oracle OS environment for installation by defining Oracle OS user variables like hostname, SID, base, and home, updating PATH, and adjusting SELinux and firewall settings.

Use NETCA to launch a wizard that guides you through creating a listener, choosing TCP/IP and the default port 1521, then verify with lsnrctl status.

Use the database configuration assistant (dbca) to create an Oracle database instance, selecting a general purpose template, multitenant options, listener settings, storage locations, and memory parameters.