Index of every page on this site: llms.txt
All skills
Run it yourself

Use when the user asks to "provision Autonomous AI Database", "estimate ADB ECPU cost", "configure ADB auto scaling", "fix ADB wallet or mTLS connection", or "manage ADB backups and clones".

Use this Skill: https://skilld.dev/gh/acedergren/agentic-tools/oracle-dba

Nothing lands on disk. Nothing to clean up.

Fork this Skill

Edit a local copy. It keeps the author and licence.

referencesadb-cli-reference.md

≈1.2k tokens on demand. Your agent reads this file only when SKILL.md points to it.

Autonomous AI Database CLI Reference

Last verified: 2026-09-30 against OCI CLI 3.94.1 (oci db autonomous-database* --help). Every flag below exists in that version. Values in <> are placeholders.

Provision

oci db autonomous-database create \
  --compartment-id "$C" \
  --db-name APPDB01 \
  --display-name app-prod \
  --db-workload OLTP \
  --compute-model ECPU \
  --compute-count 2 \
  --data-storage-size-in-gbs 1024 \
  --is-auto-scaling-enabled true \
  --is-auto-scaling-for-storage-enabled false \
  --license-model LICENSE_INCLUDED \
  --admin-password "$ADMIN_PW" \
  --subnet-id "$PRIVATE_SUBNET" \
  --nsg-ids '["<nsg-ocid>"]' \
  --backup-retention-period-in-days 30 \
  --wait-for-state AVAILABLE

--db-workload: OLTP (Transaction Processing), DW / LH (Lakehouse), AJD (JSON), APEX. Free or developer databases: --is-free-tier true / --is-dev-tier true.

Scale, stop, start, shrink

# Change base ECPUs (compute auto scaling can still use up to 3x this)
oci db autonomous-database update --autonomous-database-id "$ADB_ID" --compute-count 4

# Turn compute auto scaling off (no other cap exists)
oci db autonomous-database update --autonomous-database-id "$ADB_ID" --is-auto-scaling-enabled false

# Stop / start (ECPU billing stops while stopped; storage and backups still bill)
oci db autonomous-database stop  --autonomous-database-id "$ADB_ID" --wait-for-state STOPPED
oci db autonomous-database start --autonomous-database-id "$ADB_ID" --wait-for-state AVAILABLE

# Reduce allocated storage after deleting data
oci db autonomous-database shrink --autonomous-database-id "$ADB_ID"

For scheduled stop/start, use OCI Resource Scheduler, or --scheduled-operations on the database.

Network access and wallets

# Public endpoint with an ACL, allow walletless TLS
oci db autonomous-database update --autonomous-database-id "$ADB_ID" \
  --whitelisted-ips '["203.0.113.0/24","<vcn-ocid>"]' \
  --is-mtls-connection-required false

# Instance wallet (preferred for apps)
oci db autonomous-database generate-wallet --autonomous-database-id "$ADB_ID" \
  --password "$WALLET_PW" --file wallet.zip --generate-type SINGLE

# Regional wallet: covers every ADB in the region; rotating it affects all of them
oci db autonomous-database generate-wallet --autonomous-database-id "$ADB_ID" \
  --password "$WALLET_PW" --file regional-wallet.zip --generate-type ALL

Rotate or inspect wallet state with oci db autonomous-database-wallet (get-metadata, rotate, get-regional-wallet-metadata, rotate-regional-wallet).

Backups

# Automatic backup retention (ECPU model: 1–60 days, billed separately)
oci db autonomous-database update --autonomous-database-id "$ADB_ID" \
  --backup-retention-period-in-days 14

# Long-term backup: 90 days to 10 years; needs one automatic backup first
oci db autonomous-database-backup create --autonomous-database-id "$ADB_ID" \
  --display-name "pre-upgrade" --is-long-term-backup true --retention-period-in-days 90

oci db autonomous-database-backup list --autonomous-database-id "$ADB_ID" --all \
  --query 'data[].{name:"display-name",type:type,state:"lifecycle-state",ended:"time-ended"}' \
  --output table

Clones

# FULL (data + metadata), METADATA (schema only), PARTIAL
oci db autonomous-database create-from-clone \
  --compartment-id "$C" --source-id "$ADB_ID" --clone-type METADATA \
  --db-name APPTEST --display-name app-test \
  --compute-model ECPU --compute-count 2 --data-storage-size-in-gbs 256 \
  --admin-password "$ADMIN_PW"

# Refreshable clone (read-only copy refreshed from the source)
oci db autonomous-database create-refreshable-clone \
  --compartment-id "$C" --source-id "$ADB_ID" \
  --db-name APPRPT --display-name app-reporting \
  --compute-model ECPU --compute-count 2 --refreshable-mode AUTOMATIC \
  --admin-password "$ADMIN_PW"

oci db autonomous-database list-clones --autonomous-database-id "$ADB_ID"

Metrics (namespace oci_autonomous_database)

oci monitoring metric-data summarize-metrics-data \
  --compartment-id "$C" --namespace oci_autonomous_database \
  --query-text "CpuUtilization[5m]{resourceId = \"$ADB_ID\"}.mean()"
  • CpuUtilization is relative to the ECPU count (with auto scaling on, Database Actions shows it relative to 3x).
  • StorageUtilization is emitted hourly; alarm on it with a [1h] interval.

Official sources

Source: SKILL.md on GitHub

skilld matched fixed text patterns in SKILL.md and file names. Patterns miss obfuscated code.

skilld run checks every file with the same patterns. It asks for approval before it loads a Skill with a behavior marked Needs approval.

No alerts7mo4 checks · Risk SAFE
  • Gen Agent Trust Hub8mo

    The skill provides a comprehensive set of resources, OCI CLI commands, and SQL scripts for managing Oracle Autonomous Database. All external references target official and trusted sources.

  • Socket8mo

    No alerts

  • Snyk8mo

    Risk: LOW · No issues

  • ZeroLeaks7mo

    Score: 93/100 · 2 sections analyzed

Signed by skilld at 641a79b. This ties the file your Agent reads to that commit on GitHub. It does not review the instructions.

Last checked against GitHub last month.

Steadyupdated 2 months ago
version
3.0.0
aliases
[
  "autonomous-database",
  "oracle-autonomous-database",
  "adb"
]
domains
[
  "oracle",
  "database"
]
Other metadata
keywords
[
  "Autonomous AI Database",
  "ADB",
  "ECPU",
  "auto scaling",
  "wallet",
  "mTLS",
  "long-term backup",
  "refreshable clone",
  "oci db autonomous-database"
]

README badge

README badge for acedergren/agentic-tools/oracle-dba