Buhaiqing Aliyun Skills Alicloud Polar Oracle Ops

Alibaba Cloud PolarDB Oracle-compatible Operations Skill

Overview

PolarDB Oracle-compatible (PolarDB O / PolarDB IO) is Alibaba Cloud's cloud-native database fully compatible with Oracle PL/SQL syntax, designed for enterprise Oracle migration scenarios. This skill is an operational runbook for agents: explicit scope, credential rules, pre-flight checks, dual-path execution (official SDK/API and CLI flows), response validation, and failure recovery.

CLI applicability (repository policy)

• cli_applicability: dual-path: Official aliyun supports PolarDB-O via the polardb-io product slug. Each execution flow documents both the SDK step and the aliyun step for every operation.

Trigger & Scope (Agent-Readable)

SHOULD Use This Skill When

• User mentions "PolarDB Oracle" OR "PolarDB O" OR "PolarDB-O" OR "PolarDB IO" OR "云原生数据库PolarDB 兼容Oracle版" OR "PolarDB O引擎" OR "兼容Oracle"
• Task involves CRUD/lifecycle on PolarDB-O DBClusters (create, describe, modify, delete, start, stop, restart)
• Task involves Oracle migration assessment (ADAM, OMS compatibility)
• Task involves accounts, databases, backups, endpoints, performance monitoring
• Task keywords: PL/SQL, stored procedure, Oracle迁移 (Oracle migration), O引擎

SHOULD NOT Use This Skill When

• Task is pure billing / RAM → billing / alicloud-ram-ops
• Task is PolarDB MySQL → delegate to: alicloud-polar-mysql-ops
• Task is PolarDB PostgreSQL → delegate to: alicloud-polar-postgresql-ops
• Task is standalone Oracle Database (not PolarDB) → out of scope
• Task is RDS → delegate to: alicloud-rds-ops
• Task requires DAS diagnosis → delegate to: alicloud-das-ops

Delegation Rules

Variable Convention (Agent-Readable)

凭据安全（强制）： 参考 Credential Masking 规则

API and Response Conventions

• ClientToken: Generate UUID v4 for write operations for idempotency.

Response Field Table

Expected State Transitions

Changelog

Quick Start

Prerequisites

• aliyun CLI installed
• Credentials configured
• Region set

First Command

aliyun polardb-io DescribeDBClusters --RegionId "{{env.ALIBABA_CLOUD_REGION_ID}}"

Execution Flows (Agent-Readable)

Operation: Create DB Cluster

Pre-flight Checks

Execution — CLI (Primary Path)

aliyun polardb-io CreateDBCluster \
  --DBNodeClass "{{user.db_node_class}}" \
  --PayType Postpaid \
  --DBNodeNumber 2 \
  --RegionId "{{user.region}}" \
  --VPCId "{{user.vpc_id}}" \
  --VSwitchId "{{user.vswitch_id}}" \
  --DBClusterDescription "{{user.db_cluster_name}}" \
  --SecurityIPList "{{user.security_ip_list|10.0.0.0/8}}"

Execution — JIT Go SDK (Fallback Path)

package main

import (
	"fmt"
	"os"

	openapi "github.com/alibabacloud-go/darabonba-openapi/v2/client"
	"github.com/alibabacloud-go/tea/tea"
	polardbio "github.com/alibabacloud-go/polardb-io-20211126/v3/client"
)

func main() {
	config := &openapi.Config{
		AccessKeyId:     tea.String(os.Getenv("ALIBABA_CLOUD_ACCESS_KEY_ID")),
		AccessKeySecret: tea.String(os.Getenv("ALIBABA_CLOUD_ACCESS_KEY_SECRET")),
	}
	client, _ := polardbio.NewClient(config)

	req := &polardbio.CreateDBClusterRequest{
		DBNodeClass:          tea.String(os.Getenv("DB_NODE_CLASS")),
		PayType:              tea.String("Postpaid"),
		DBNodeNumber:         tea.Int32(2),
		RegionId:             tea.String(os.Getenv("REGION")),
		VPCId:                tea.String(os.Getenv("VPC_ID")),
		VSwitchId:            tea.String(os.Getenv("VSWITCH_ID")),
		DBClusterDescription: tea.String(os.Getenv("CLUSTER_NAME")),
		SecurityIPList:       tea.String(os.Getenv("SECURITY_IP_LIST")),
		ClientToken:          tea.String(os.Getenv("CLIENT_TOKEN")),
	}
	resp, _ := client.CreateDBCluster(req)
	fmt.Printf("Created PolarDB-O cluster: %s\n", tea.ToString(resp.Body.DBClusterId))
}

Post-execution Validation

Poll until DBClusterStatus is Running:

for i in $(seq 1 60); do
  STATUS=$(aliyun polardb-io DescribeDBClusterAttribute \
    --DBClusterId "{{output.db_cluster_id}}" \
    --output cols=DBClusterStatus rows=DBClusterStatus)
  [ "$STATUS" = "Running" ] && break
  sleep 10
done

Failure Recovery

Operation: Describe DB Clusters

Execution — CLI

# List all Oracle-compatible clusters
aliyun polardb-io DescribeDBClusters --RegionId "{{user.region}}"

# Describe specific cluster
aliyun polardb-io DescribeDBClusterAttribute --DBClusterId "{{user.db_cluster_id}}"

# Extract key fields
aliyun polardb-io DescribeDBClusters --RegionId "{{user.region}}" \
  --output cols=DBClusterId,DBClusterStatus,DBVersion,PayType rows=Items.DBCluster[].{DBClusterId,DBClusterStatus,DBVersion,PayType}

Operation: Delete DB Cluster

Pre-flight (Safety Gate)**

• MUST obtain explicit confirmation before irreversible delete.
• Recommend final backup.

Execution — CLI

aliyun polardb-io DeleteDBCluster --DBClusterId "{{user.db_cluster_id}}"

Post-execution Validation

Poll until cluster is absent.

Operation: Manage Nodes

Add DB Nodes — CLI

aliyun polardb-io AddDBNodes \
  --DBClusterId "{{user.db_cluster_id}}" \
  --DBNodeClass "{{user.db_node_class}}" \
  --DBNodesCount "{{user.db_nodes_count|1}}"

Remove DB Nodes — CLI

Safety Gate: Confirm before removing.

aliyun polardb-io RemoveDBNodes \
  --DBClusterId "{{user.db_cluster_id}}" \
  --DBNodeIds "{{user.db_node_ids}}"

Describe DB Nodes — CLI

aliyun polardb-io DescribeDBNodes --DBClusterId "{{user.db_cluster_id}}"

Operation: Manage Accounts

Create Account — CLI

aliyun polardb-io CreateAccount \
  --DBClusterId "{{user.db_cluster_id}}" \
  --AccountName "{{user.account_name}}" \
  --AccountPassword "{{user.account_password}}" \
  --AccountType "Super"

Describe Accounts — CLI

aliyun polardb-io DescribeAccounts --DBClusterId "{{user.db_cluster_id}}"

Operation: Manage Databases

Create Database — CLI

aliyun polardb-io CreateDatabase \
  --DBClusterId "{{user.db_cluster_id}}" \
  --DBName "{{user.db_name}}" \
  --AccountName "{{user.account_name}}" \
  --AccountPrivilege "ReadWrite"

Operation: Backup Management

Create Backup — CLI

aliyun polardb-io CreateBackup --DBClusterId "{{user.db_cluster_id}}"

Describe Backups — CLI

aliyun polardb-io DescribeBackups \
  --DBClusterId "{{user.db_cluster_id}}" \
  --StartTime "{{user.start_time}}" \
  --EndTime "{{user.end_time}}"

Configure Backup Policy — CLI

aliyun polardb-io ModifyBackupPolicy \
  --DBClusterId "{{user.db_cluster_id}}" \
  --PreferredBackupTime "02:00Z-03:00Z" \
  --PreferredBackupPeriod "Monday,Tuesday,Wednesday,Thursday,Friday,Saturday,Sunday" \
  --BackupRetentionPeriod 30

Operation: Manage Endpoints

Describe Endpoints — CLI

aliyun polardb-io DescribeDBClusterEndpoints --DBClusterId "{{user.db_cluster_id}}"

Operation: Start / Stop Cluster

# Stop cluster
aliyun polardb-io StopDBCluster --DBClusterId "{{user.db_cluster_id}}"

# Start cluster
aliyun polardb-io StartDBCluster --DBClusterId "{{user.db_cluster_id}}"

Operation: Upgrade Cluster

Pre-flight (Safety Gate)

• MUST obtain explicit confirmation before upgrade.
• Suggest backup before upgrade.

Execution — CLI

aliyun polardb-io UpgradeDBCluster \
  --DBClusterId "{{user.db_cluster_id}}" \
  --DBNodeClass "{{user.target_node_class}}"

Operation: Intelligent Inspection

Purpose: Proactive discovery of PolarDB Oracle performance bottlenecks, storage risks, and session anomalies.

5-step workflow: Discovery (list clusters) → Collection (CPU/Memory/IOPS/Storage/Sessions) → Detection (4 anomaly pattern rules) → Diagnosis (slow SQL, tablespace, sessions) → Report (Markdown).

Full CLI script template at references/cli-usage.md.

Inspection scoring:

Total < 40 → Critical (immediate action required)

Anomaly detection rules:

PolarDB IO Cruise (Health Check)

Prerequisites

1. Install CLI: /bin/bash -c "$(curl -fsSL https://aliyuncli.alicdn.com/install.sh)"
2. Configure Credentials: export ALIBABA_CLOUD_ACCESS_KEY_* env vars
3. Verify: aliyun polardb-io DescribeDBClusters

Well-Architected Assessment

Evaluated per Alibaba Cloud Well-Architected Framework.

Reference Directory

• Core Concepts
• API & SDK Usage
• CLI Usage
• Troubleshooting Guide
• Monitoring & Alerts
• Integration

Operational Best Practices

• Least privilege: RAM scoped to polardb-io:* APIs.
• Migration assessment: Use ADAM before migrating Oracle workloads.
• Security: Minimum SecurityIPList; SSL encryption.
• Backup: Daily automated backups with 30+ day retention.
• Monitoring: CMS alarms for CPU > 85%, Connections > 80%.

Quality Gate (GCL)

Thirteenth rollout of GCL per AGENTS.md §12. Inherits canonical from alicloud-polar-mysql-ops + Oracle-specific deviations. See references/rubric.md and references/prompt-templates.md.

Changelog

1.0.0 | 2026-06-04 | Thirteenth rollout; inherits canonical + Oracle-specific.

See Also — Meta-Skill Rules

This skill is subject to cross-cutting rules defined by the alicloud-skill-generator meta-skill.

• Code Snippets Rule — When cli_applicability: sdk-only (CLI 不足以覆盖完整功能，必须依赖 SDK/API 方式), the skill MUST provide assets/code-snippets/ with runnable Go SDK code. DOES NOT APPLY — 本 skill 为 dual-path，CLI/SDK 已覆盖，无需 code snippets.

Source: buhaiqing/aliyun-skills — distributed by TomeVault.