Oracle Scripts

Search UNIX Man Pages for Oracle DBA Tools with man -k Purpose Where Google answers most "how do I do X in UNIX" questions for a DBA today, man -k answers the narrower one — what tools the host actually has installed, and what each one does, without leaving the SSH session. Production Oracle hosts often run in …

Enable vi Command-Line Editing in ksh for Oracle DBA Shells Purpose Recalling and editing the prior command without retyping it is the single most-used operation in a long DBA shift on an Oracle host. On the Korn shell (ksh) — the default login shell on AIX 7.x, Solaris 11, HP-UX 11i, and many older Oracle 11g/12c …

Disable vi Autoindent Before Pasting SQL Scripts on Oracle Hosts Purpose Pasting a SQL script copied from email, a Confluence page, or a ticket comment into a vi buffer over SSH — and watching every line shift one indent right of the previous one — is the most common and most frustrating vi failure mode an Oracle DBA …

vi Editor Commands Reference for Oracle DBAs Every Oracle DBA on Unix or Linux ends up in vi whether they planned to or not. It opens by default when you crontab -e, it is what visudo drops you into, and it is the editor on most Oracle Linux and AIX hosts before anyone has installed nano or configured EDITOR. Knowing …

Scan Every Oracle Alert and Trace Log for ORA- Errors with grep Purpose Every Oracle environment generates alert logs and process trace files recording instance events, errors, and diagnostics. When a support call comes in — "the database was slow last night, can you check the logs?" — the fastest first pass is a …

Find the Biggest Files First When an Oracle Filesystem Fills Up Purpose A full Oracle filesystem is a five-alarm incident. Whether it is the /u01/oradata mount holding datafiles, the Fast Recovery Area filling with archive logs, or the diag directory overflowing with trace files, the first question is always the same: …

Recursive find and grep to Search Oracle Trace Files for Any String Purpose Oracle's Automatic Diagnostic Repository (ADR) accumulates hundreds or thousands of trace files — one per background process event, one per incident, one per session that hits an error deep enough to dump. Finding the trace file that contains …

Oracle Export Through a Named Pipe with mknod for Space-Constrained Hosts Purpose Oracle's original Export utility (exp) writes a binary dump file. On production hosts where disk space is tight — where staging a full-database dump and its compressed copy simultaneously would exhaust the filesystem — the classic …

Unpacking Oracle Patch and Install Media with cpio Purpose Before Oracle began shipping all patches as .zip files, the standard delivery format for Oracle install media and large patch bundles was cpio — a tape archive format that predates tar and is still the underlying format used inside every RPM package. DBAs …

Diagnose Oracle Net and RAC Interconnect Routing with netstat -r Purpose Oracle Net connections and Oracle RAC private interconnect traffic both depend on correct IP routing. When an Oracle client cannot connect to the listener, when RAC Cache Fusion or heartbeat traffic is routing over the wrong interface, or when …