oracle-dba-cloud-autonomous-ocilisted

USE THIS SKILL WHENEVER the user mentions Oracle Cloud / OCI, Autonomous Database (ADB / ATP / ADW / AJD / APEX), Autonomous DB monitoring or auto-patching, OCI Base Database Service / DB systems, cloud-managed backups / backup retention / long-term backups, ECPU/OCPU or storage auto-scaling, OCI IAM / database-access policy, the OCI CLI (`oci db ...`, `oci iam ...`), Exadata Cloud@Customer (ExaCC) / ExaDB-C / VM clusters, or cloud migration via Zero Downtime Migration (ZDM / zdmcli) or the OCI Database Migration Service (DMS) — EVEN IF they do not name the specific task. Covers Autonomous DB & Base DB provisioning (T2, dry-run-default), cloud backup configuration, auto-scaling configuration, OCI IAM policy-as-code (create/update), read-only ADB health and auto-patch monitoring, and the (plan-only, human-driven) Tier-3 runbooks for ExaCC management and cloud migration. Follows the oracle-dba-common contracts: SQLcl MCP saved connection dba_ai_conn for in-DB work, OCI CLI for control-plane host ops, Oracle Wal
Shreyas70773/oracle-dba-agentic-skills · ★ 0 · DevOps & Infrastructure · score 62

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

# Oracle DBA - Cloud / Autonomous (OCI) Oracle on OCI for 19c and 23ai (EE; single-instance and Data Guard topologies; the same contracts apply whether on-prem-managed or cloud-managed). In-DB observability runs through the SQLcl MCP saved connection **`dba_ai_conn`**; cloud control-plane operations run through the **OCI CLI** (host op — cannot go through SQLcl MCP, so these are `.sh`/`.ps1` "script" mechanisms, later to front a guarded `oracle-dba-ops` MCP). Everything self-executing is **T1 (observe)** or **T2 (reversible, dry-run-default)**. Provisioning-**terminate**, ExaCC management, cloud **migration** (ZDM/DMS), and IAM policy **delete** are **T3** and live only in `references/runbooks.md` — they print commands for a human and never self-execute. Skill log segment: **`cloud-oci`** (logs to `/var/log/oracle-dba/cloud-oci/` on Linux, `C:/ProgramData/oracle-dba/logs/cloud-oci/` on Windows). ## Scope & risk map | Task | Level | Tier | Mechanism (script / sql / runbook path) | Idempotent? | |------|-------|------|------------------------------------------|-------------| | Autonomous DB monitoring | L1 | T1 | `scripts/checks/check_adb_health.sh` / `.ps1` + `sql/autonomous_db_monitoring.sql` (+ OCI CLI get) | yes — read-only (emits metrics + findings, never mutates) | | Autonomous patching (auto-applied) — observe only | L1 | T1 | `scripts/checks/check_patch_status.sh` / `.ps1` + `sql/patch_status.sql` (+ OCI CLI maintenance get) | yes — read-only; ADB auto-patches, this