oracle-dba-patching-upgradeslisted

USE THIS SKILL WHENEVER the user mentions patching or upgrading Oracle: Release Updates (RU/RUR), one-off / interim patches, OPatch / opatchauto / datapatch, OJVM patches, patch conflicts / merge / napply / superset patches, patch rollback, Grid Infrastructure (GI) patching, rolling RAC patching, Data Guard standby-first patching, OS / host patch and reboot coordination, DST / time-zone file upgrades, database version upgrades (19c -> 23ai), AutoUpgrade (autoupgrade.jar analyze/fixups/deploy), DBUA / manual catupgrd, Fleet Patching & Provisioning (FPP / rhpctl), or cross-version / out-of-place migration — EVEN IF they do not name the specific tool. Covers read-only patch/upgrade observability and readiness reports, OPatch prereq/conflict analysis, datapatch SQL reconcile (+ rollback note), DST PREPARE analysis, AutoUpgrade analyze/fixups, OS-patch quiesce/resume coordination, and the plan-only Tier-3 runbooks for every destructive apply/upgrade/migration. Follows the oracle-dba-common contracts: SQLcl MCP sav
Shreyas70773/oracle-dba-agentic-skills · ★ 0 · DevOps & Infrastructure · score 62

Install: claude install-skill Shreyas70773/oracle-dba-agentic-skills

# Oracle DBA - Patching & Upgrades Patch level observability, pre-patch readiness & conflict analysis, the reversible SQL / DST / OS-coordination steps, and the plan-only Tier-3 runbooks for every destructive apply, upgrade, rollback, and migration on Oracle 19c and 23ai (EE; single_instance and Data Guard; on-prem). Everything self-executing is **T1 (observe)** or **T2 (reversible, dry-run default)**. Every **binary apply, GI/RAC patch, DST upgrade, OS reboot, version upgrade, AutoUpgrade deploy, patch rollback, FPP move, conflict resolution, and cross-version migration is T3** and lives only in `references/runbooks.md` — it PRINTS commands for a human and never self-executes. See `references/version-notes.md` for 19c-vs-23ai deltas. ## Scope & risk map | Task | Level | Tier | Mechanism (script / sql / runbook path) | Idempotent? | |------|-------|------|------------------------------------------|-------------| | Patch level / datapatch status report | L1 | T1 | `scripts/checks/patch_status.sh` / `.ps1` + `sql/patch_inventory.sql` + `sql/registry_patch_status.sql` | yes — read-only (opatch lsinventory + in-DB registry; flags home-vs-DB mismatch) | | Patch conflict / prereq DETECTION | L1 | T1 | `scripts/checks/patch_conflict_check.sh` / `.ps1` | yes — read-only opatch prereq analyzers; same verdict each run | | FPP inventory query | L1 | T1 | `scripts/checks/fpp_query.sh` / `.ps1` | yes — read-only `rhpctl query` only | | Pre-patch readiness snapshot | L1 | T1 | `sql/patc