后端与数据库

rds-oracle

aws/agent-toolk…-for-aws

Diagnoses and resolves Amazon RDS for Oracle connectivity, authentication, networking, and driver troubleshooting. Applicable to any RDS-for-Oracle question including connecting a Python Lambda to RDS Oracle in a VPC with pooling and cold-start optimization, EKS pods to RDS Oracle via the Secrets Manager CSI driver with IRSA and SecretProviderClass, ORA-12170 cross-VPC timeouts from EC2, DPI-1047 cannot-locate-64-bit-Oracle-Client errors, and Oracle Connection Manager (CMAN) on EC2 as a proxy with HA across two AZs. Covers python-oracledb thin vs thick mode, init_oracle_client, RDS Proxy does NOT support RDS Oracle, port 1521, VPC peering, Transit Gateway, Kerberos with AWS Managed Microsoft AD, SSL/TLS/NNE, SSM port forwarding, EC2/ECS Fargate/EKS/Lambda, SQL Developer/DBeaver/Toad/SQLcl, and Secrets Manager.

  • 4692 次安装
  • 3300 星标
  • 收录于

安装命令

npx skills add https://github.com/aws/agent-toolkit-for-aws --skill rds-oracle

SKILL.md

Amazon RDS for Oracle — Connectivity

Safety guidance

This skill covers creating and modifying RDS for Oracle resources when the user requests it. The agent MUST confirm the action with the user before executing. Do NOT execute any create or modify operation without explicit user confirmation (e.g., "yes", "proceed", "confirmed", "go ahead"). If the user has not confirmed, present the planned action and ask for approval.

Execute these operations (after user confirmation)

  • Create an instance: create-db-instance (requires a DB subnet group; RDS Oracle is VPC-only and not publicly accessible by default)
  • Create a custom parameter group: create-db-parameter-group (family oracle-se2-19, oracle-ee-19, etc.)
  • Create an option group: create-option-group (for Oracle Native Network Encryption, TLS/TCPS, S3 integration, APEX, Spatial)
  • Change backup retention: modify-db-instance --backup-retention-period
  • Enable/disable deletion protection: modify-db-instance --deletion-protection
  • Change CloudWatch log exports: modify-db-instance --cloudwatch-logs-export-configuration
  • Attach/detach parameter group or option group: modify-db-instance --db-parameter-group-name / --option-group-name
  • Tag resources: add-tags-to-resource, remove-tags-from-resource

Resource tagging (always apply on resource creation)