Skip to content
Skills Library
DevOps & cloud · Tool integration

oci-database-cloud

/oci-database-cloud

Operate OCI Base Database Service and Exadata Database Service control-plane lifecycle: DB systems, Exadata infrastructure and VM clusters, DB homes, databases and PDB resources, backups and restores, scaling, maintenance, patching, upgrades, and Data Guard associations. Use when the request mentions Base Database, Exadata, DB systems, DB homes, PDB lifecycle, cloud backups, maintenance, or Data Guard associations. Do not use for Autonomous Database, observability onboarding, or in-database SQL, RMAN, and tuning.

Repository
oci-skills ↗
Licence
MIT
Last repository change
26.10.2026

Assessment and security

100/ 100Class: good
Format25 / 25
Frontmatter with name and description, valid name, description up to 1,024 characters, name matching the folder.
Discoverability25 / 25
Description explains when to use the skill, has a reasonable length and uses third person.
Content35 / 35
At least 150 words and at most 500 lines, headings, step lists, examples or code.
Hygiene15 / 15
No placeholders such as TODO, no Windows paths, with a licence.
Riskno signals detected in the scan
Files in this package
2
Scripts
0
HTML comments
0
URLs in SKILL.md
3
Deprecation

No signals detected. Repository changed on 26.10.2026, without references to retired models or APIs.

Licence

MIT, open: use and modify while retaining author attribution.

What it does and when to use it

Operate OCI Base Database Service and Exadata Database Service control-plane lifecycle: DB systems, Exadata infrastructure and VM clusters, DB homes, databases and PDB resources, backups and restores, scaling, maintenance, patching, upgrades, and Data Guard associations. Use when the request mentions Base Database, Exadata, DB systems, DB homes, PDB lifecycle, cloud backups, maintenance, or Data Guard associations. Do not use for Autonomous Database, observability onboarding, or in-database SQL, RMAN, and tuning.

Original author description

Operate OCI Base Database Service and Exadata Database Service control-plane lifecycle: DB systems, Exadata infrastructure and VM clusters, DB homes, databases and PDB resources, backups and restores, scaling, maintenance, patching, upgrades, and Data Guard associations. Use when the request mentions Base Database, Exadata, DB systems, DB homes, PDB lifecycle, cloud backups, maintenance, or Data Guard associations. Do not use for Autonomous Database, observability onboarding, or in-database SQL, RMAN, and tuning.

How it works

  1. First move
  2. Routing
  3. Common multi-step flows
  4. Safety boundaries
  5. Verification and rollback
  6. Expected output
  7. Official documentation
Original SKILL.md headings · 86 lines, 615 words
SKILL.md preview
---
name: oci-database-cloud
description: >-
  Operate OCI Base Database Service and Exadata Database Service control-plane
  lifecycle: DB systems, Exadata infrastructure and VM clusters, DB homes,
  databases and PDB resources, backups and restores, scaling, maintenance,
  patching, upgrades, and Data Guard associations. Use when the request mentions
  Base Database, Exadata, DB systems, DB homes, PDB lifecycle, cloud backups,
  maintenance, or Data Guard associations. Do not use for Autonomous Database,
  observability onboarding, or in-database SQL, RMAN, and tuning.
---

# OCI Database Cloud

Manage the OCI control plane around Base Database and Exadata deployments. Read
the complete dependency graph and maintenance/backup posture before mutation;
keep database credentials out of argv and output.

## First move

```bash
./scripts/oci_preflight.sh -c "$COMPARTMENT_OCID"
python3 scripts/kb_lookup.py "<symptom>" database-cloud
```

If the resolved tenancy/compartment does not match the intended target, stop
before reading DB-system or Exadata state.

## Routing

| Intent | Owner |
|---|---|
| VM/BM DB system, DB home, database/PDB resource, backup/restore, patch/upgrade, scale, Data Guard association | This skill |
| Exadata infrastructure, cloud VM cluster, maintenance, capacity | This skill |
| Autonomous Database lifecycle, wallet, private endpoint | **oci-autonomous-db** |
| DBM/OPSI, Performance Hub, AWR/ASH service onboarding | **oci-dbm-opsi** |
| Metrics, alarms, Logging, APM | **oci-observability-db** |
| SQL/PLSQL, RMAN, schema migration, SQL tuning, Data Guard internals | Official `oracle/skills` **db/** hard handoff |
| Terraform HCL/import | **oci-terraform-authoring** |

Control-plane Data Guard association lifecycle stays here; redo design, broker
internals, and database-side repair stop at the official `db/` handoff.

Read [database-cloud.md](../../references/database-cloud.md) for lifecycle,
maintenance, backup, safety, and official-source contracts.

## Common multi-step flows

| Task | Sequence |
|---|---|
| Create a Base DB system | preflight → limits/capacity/network/KMS/backup reads → ownership check → additive reviewed plan → work-request wait → database/backup/agent verification |
| Patch or upgrade | read DB system, DB home, database, Data Guard, backups, and maintenance → precheck → in-place approval → rolling order → health and version verification → rollback/escalation decision |
| Backup and restore | read policy and latest usable backup → validate destination and recovery objective → additive backup or risk-classified restore → work-request wait → recovery validation |
| Data Guard lifecycle | read both sites and association health → validate backup/network/version/maintenance separation → create or role transition → verify roles and apply health → rehearse rollback |
| Exadata lifecycle | read infrastructure/VM-cluster capacity and maintenance → dependency/ownership check → additive or in-place action → prechecks/work requests → cluster/database verification |
| Teardown | inventory Data Guard, databases/PDBs, homes, backups, VM clusters, infrastructure, and Terraform state → destructive preview → exact approval → dependency-order removal → verify absence |

## Safety boundaries

- Passwords, wallet material, TDE/HSM secrets, and key material never appear on
  argv. Use a reviewed `0600` `file://` command document with `--from-json` only
  after installed help validates its fields.
- Creates and out-of-place restores are additive; scaling, patching, upgrades,
  configuration restores, and planned role transitions are in-place unless the
  reviewed impact requires destructive classification. Failover or any action
  that can discard data is destructive.
- Database/PDB deletion, backup deletion, DB-system termination, VM-cluster or
  Exadata-infrastructure deletion require dependency inventory, dry-run preview,
  and exact destructive approval.
- A current successful backup, maintenance precheck, and rollback path are
  prerequisites for patch/upgrade. Separate primary and standby maintenance.
- Never infer availability, limits, supported versions, shapes, or pricing from
  this skill. Resolve them from live reads and current official documentation.
- Validate exact command paths and flags with `oci_cli_help.py`; every mutation
  uses `run_action` with the target compartment.

## Verification and rollback

Verify work requests, lifecycle state, DB-node/VM-cluster health, database/PDB
availability, backup recoverability, Data Guard roles/apply health, maintenance
result, and monitoring continuity. Rollback is operation-specific: restore the
previous configuration or software home, reinstate/switchover only after health
review, or remove newly created resources in reverse dependency order.

## Expected output

Report named resources and dependency graph, redacted evidence, control-plane
owner, risk/approval, maintenance and backup posture, work-request result,
verification, rollback, and the boundary to database-internal work.

## Official documentation

[Database service](https://docs.oracle.com/en-us/iaas/Content/Database/home.htm) · [Base Database](https://docs.oracle.com/en-us/iaas/base-database/index.html) · [Exadata maintenance](https://docs.oracle.com/en-us/iaas/exadatacloud/doc/exa-conf-oracle-man-infra.html). Full index in [oracle-docs.md](../../references/oracle-docs.md).

**Open Knowledge Format grounding** — every Oracle documentation link is
registered and liveness-checked in the pack's central index.
Files in this package (2)
  • SKILL.md 5 KB
  • agents/openai.yaml 1 KB

Versions

The database has no other skills named oci-database-cloud.

Database snapshot: 13.11.2026 · package version 00c489340ccd (SHA-256 digest of the entire package)

Downloads in the last 30 days: 0 · ranking

Report a problem with this skill: harmful content, incorrect descriptions or an author’s removal request.

Similar skills

  • 95build-oci-exadata-database-main-tf
    Generate or update Terraform configuration only for OCI Exadata Database Service on Dedicated Infrastructure with the upstream `oci-landing-zones/terraform-oci-modules-oracle-database/tree/main/exadata-database` folder. Use for Cloud Exadata Infrastructure, Cloud VM Clusters, DB…
  • 87oci
    Oracle Cloud Infrastructure guidance for designing, operating, and troubleshooting OCI services, including OCI Kubernetes Engine (OKE), OCI Internet of Things Platform, OCI Functions deployment and troubleshooting, OCI Exadata Database Service Terraform configuration, OCI IAM…
  • 100oci-data-safe
    OCI Data Safe administration via oci-cli and the OCI SDK: target-database registration (Autonomous and Base DB / Exadata cloud service), Data Safe private endpoints, Security Assessment and User Assessment, Activity Auditing (scim_query time filters), Data Discovery (sensitive…
  • 100oci-administrator
    Default router for tenancy-agnostic Oracle Cloud Infrastructure engineering. Use for OCI administration, audit, security, IAM, Bastion, networking, compute, OKE, observability, storage, disaster recovery, Base Database, Exadata, DBM/OPSI, ADB, data platforms, OS Management Hub,…
  • 95oracle-cloud
    Use this skill when the user says 'oracle cloud', 'oci', 'oracle cloud infrastructure', 'oracle database cloud', 'oci compute', 'oci networking', 'oci storage', 'oci identity', 'oci iam', 'oracle autonomous database', 'oci load balancer', 'oci dns', 'oci functions', 'oci…
  • 100cloud-databases-onboarding
    Guides users through discovering their database requirements, recommends a Google Cloud database based on a recommendation matrix, and assists in database creation. Use when a user asks 'What database service should I use?', 'Help me pick a database', or when a user wants to…

Feedback and reports

Your message goes to Bartosz Sokoliński. An email address is needed only for a reply. See the privacy policy.