skills.rest
acedergren
acedergrenCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

database-management

Troubleshoot OCI Autonomous Database connections and manage backups, clones, and PDBs.

16|3|Updated Jan 26, 2026
Search Tags:#troubleshooting#database#cost optimization#oci#adb#autonomous database#connection strings
One-click install
npx skills add https://github.com/acedergren/oci-agent-skills --skill database-management-acedergren
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-management
Source: https://github.com/acedergren/oci-agent-skills/tree/main/skills/database-management
Command: npx skills add https://github.com/acedergren/oci-agent-skills --skill database-management-acedergren

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill addresses the common knowledge gaps and complexities in managing Oracle Cloud Infrastructure (OCI) databases, particularly Autonomous Databases (ADB), ensuring efficient operation, cost control, and secure connections.

Core Features & Use Cases

  • Connection Troubleshooting: Guides users through resolving wallet errors, service name confusion, and network access issues.
  • Cost Optimization: Provides detailed calculations and strategies for stopping/starting databases, choosing license models (BYOL vs. Included), and managing auto-scaling to reduce cloud spend.
  • Backup & Clone Management: Clarifies the differences between clone types, retention policies, and best practices for data protection and environment provisioning.
  • PDB Management: Explains the hierarchy and connection specifics for Pluggable Databases within Container Databases.
  • Security Best Practices: Highlights critical "NEVER DO THIS" scenarios, such as using the ADMIN user in applications or improper password complexity.

Quick Start

Use the database-management skill to troubleshoot an OCI Autonomous Database connection error.

Frequently Asked Questions about database-management

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I troubleshoot OCI Autonomous Database connection string errors?▼

Troubleshoot OCI Autonomous Database connection string errors by resolving wallet configuration issues, correcting service name confusion, and verifying network access rules. This guidance ensures secure connectivity by addressing common pitfalls like missing credentials or incorrect network endpoints.

What is the best way to optimize OCI database costs?▼

Optimize OCI database costs by calculating stop/start strategies, choosing appropriate license models like BYOL versus Included, and managing auto-scaling configurations. These actions reduce cloud spend while maintaining performance for Autonomous Databases and DB Systems.

How does clone type selection affect OCI Autonomous Database backups?▼

Clone type selection affects OCI Autonomous Database backups by determining the provisioning speed and storage cost for new environments. Clarifying the differences between clone types and retention policies ensures proper data protection and efficient environment replication.

Why does connecting to an OCI PDB require specific hierarchy knowledge?▼

Connecting to an OCI PDB requires specific hierarchy knowledge because Pluggable Databases reside within Container Databases. Understanding this structure and its connection specifics is necessary to successfully access the target database without encountering authentication failures.

What are the security risks of using the ADMIN user in OCI database applications?▼

Security risks of using the ADMIN user in OCI database applications include exposing privileged credentials to potential breaches. Never use the ADMIN user for app connections; enforce proper password complexity to secure Autonomous Database deployments.

Related Skills

Explore More Software Engineering Skills→
Snowflake-LabsSnowflake-Labs
1

oracle-connection

Configure and verify Oracle database connections for schema extraction.

Official
Intermediate
ActiveInferenceInstituteActiveInferenceInstitute
13

geo-infer-ops

Deploy and monitor AI agents on Kubernetes with auto-scaling and observability.

Community
Advanced
HeyvhuangHeyvhuang
339

mcp-cloudflare

Diagnose and manage Cloudflare MCP resources with tiered permissions and audit trails.

Community
Advanced
Nir-BhayNir-Bhay
19

backup-retention-policy

Design backup retention policies with the 3-2-1-1-0 rule and tiered storage.

Community
Advanced