Learn Oracle Database Administration From Scratch

Understand how a user connects to an Oracle database, from three-tier architecture to direct connections, and how the listener, PMON, base tables, data dictionary cache, and server process enable authentication.

Understand Oracle data files, redo log files, archived redo logs, log switches, archiver CPT, and memory management evolution from manual sizing to automatic shared memory and memory_target.

Navigate to oracle.com and accept the license to access Oracle database 11g release 2 for Linux 64-bit. Download file one and file two (see all) to obtain the database software.

Configure your Linux server with the same VirtualBox VM setup—two GB RAM, 50 GB disk—and install Oracle 11g 64-bit for Linux on the VM, using VirtualBox or VMware.

Install Oracle 11g via the graphical installer, fix host entry errors by editing /etc/hosts with the machine IP and hostname, then install database software and run prerequisite checks.

Learn how to manually create an Oracle database from a prod-like parameter file, adjusting pfile or spfile, setting Oracle sid, and running post-create scripts; compare with Dbca automation.

Delete a database in Oracle using dbca, verify it is no longer running, and confirm its entry is removed from the /edc/auto file.

Identify key external Oracle files—ora tab, ora instalok, and inventory.xml—to locate databases and Oracle home, and learn how pfile and spfile govern startup, including control and data files.

Discover how table spaces map to physical data files in Oracle databases, and use practical queries to list spaces and their data files, including system, undo, temp, and user spaces.

Learn Oracle database startup and shutdown modes, including no mount, mount, and open phases, and how startup and shutdown commands transition the database with rapid restarts using shutdown immediate.

Practice shutting down the database with shutdown immediate and starting it up, using status checks, startup mount, alter database open, and optional no mount paths, with downloadable lab exercises.

Learn to multiplex redo log files across distinct locations, manage redo log groups and members, and perform add, rename, relocate, and drop operations during mount.

Learn how capacity planning keeps Oracle databases by monitoring table space utilization, keeping usage below 80%, resizing data files, and coordinating with storage teams to ensure mount points have space.

Learn to manage Oracle database users by creating and dropping accounts, setting default tablespaces and quotas, granting connect and resource privileges, and locking or unlocking accounts.

Create a role, grant insert, update, and delete permissions to it, and assign the role to users to streamline access and reduce manual grants.

Configure the Oracle database listener by editing listener.ora with host, port 1521, and sid list for prod db and test db; start and stop the listener to enable client connections.

Configure Oracle networking by aligning DNS entries with the listener and creating tnsnames.ora entries on the client, then verify connectivity with the DNS ping utility and sqlplus.

Explore SQL Loader to upload CSV and text files into an Oracle database, using control, input, log, batch, and discard files with a where clause to filter data.

Learn to use the Oracle import utility to import schemas and tables from dump files, configure logs, and manage from user to user transfers between production and test servers.

Learn how to use the data pump export utility expdp to perform database, schema, table, and row-level exports, with dump and log files, using directory and query options.