Unix for Oracle DBAs
The text-processing and shell skills you actually need on the job — awk, sed, vi, and the SQL*Plus scripting patterns that show up in every DBA's bag of tricks.
Learn
4 articlesAbout Unix for DBAs
The Unix concepts and commands that come up most in Oracle DBA work.
Learn the awk command
Slides — patterns, field separators, and the one-liners every DBA uses.
Learn the sed command
Practical examples — substitution, line ranges, in-place editing.
vi editor — essentials
The commands you'll actually use, and the muscle memory worth building.
Scenarios
4 articlesConnect to Oracle and DB2 from Unix
The actual commands and how to spot whether a connection failed silently.
Connect to Oracle without exposing credentials
OS auth, wallet, and how to script SQL*Plus calls on a shared host safely.
Send mail in Excel format from SQL*Plus
The mime tricks to make Outlook open a SQL result as a real spreadsheet.
Send mail in text format from SQL*Plus
The simplest version of the script, with the gotchas around mailx on AIX.