Oracle Database Administration I case studies
Oracle Database Administration I · Put your knowledge to work in context.
Oracle Database Administration I is the foundational certification exam for working database administrators and for developers, system administrators, and support engineers who are moving into day-to-day database operations. It tests whether you can run an Oracle database instance and keep it healthy: how the instance and database architecture fit together, how storage is allocated and monitored, how users and privileges are managed, how the database is created and started or stopped, how schema objects and data are maintained, how undo and redo support transactions and recovery, how backup, recovery, and flashback work at a conceptual and practical level, how clients connect through Oracle Net, and how to read the built-in performance and diagnostic tooling. The Oracle Database Administration I case studies are 5 cases and about 3,934 words.
1ORA-01653 in a uniform-extent tablespace with 2.4 GB "free"
FINAPP runs on a single-instance Oracle 19c database with 8 KB blocks and a locally managed tablespace RPT DATA created with UNIFORM SIZE 64M. The tablespace has exactly one 120 GB datafile, AUTOEXTEND ON NEXT 1G MAXSIZE 120G, on a mount with only 3 GB free.
792 words, about 4 min2ORA-01555 on a 55-minute report with a 20 GB undo tablespace
GLBATCH is a 24/7 order-processing database running with UNDO MANAGEMENT=AUTO. UNDOTBS1 is 20 GB with AUTOEXTEND OFF, UNDO RETENTION=900, and retention guarantee is disabled.
777 words, about 4 min3Recovering a 60-million-row DELETE with a nearly full FRA
HRPROD is Oracle 19c in ARCHIVELOG mode. DB RECOVERY FILE DEST is 500 GB with RMAN retention RECOVERY WINDOW OF 3 DAYS, backup compression and control file autobackup ON.
773 words, about 4 min4Intermittent ORA-12170 at pool recycle time on a 3-node RAC cluster
ORDER runs on a 3-node RAC cluster: SCAN with three VIPs, service ORDER svc with two preferred instances, and 180 Java application servers each holding a 40-connection pool. Pools recycle connections between 07:55 and 08:10, and roughly 6% of new connections fail after about 60 seconds with "ORA-12170: TNS:Connect timeout occurred".
751 words, about 4 min5Shared developer account, expiring batch password, and a 02:40 lockout
FIN APP owns the schema behind an internal payroll web application. Twenty developers share one database account, APP DEV, whose password sits on a wiki page and which holds DDL privileges on FIN APP's objects; 300 business users reach the schema only through the middle tier, which connects as FIN APP itself.
841 words, about 4 min