Individual skill
rds-oracle
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.
skills/specialized-skills/database-skills/rds-oracle/SKILL.md
Source commit 1761e96813ebcbd43ed81d19e837219033f0afe5
What was checked
- Matches the observed repository HEAD
- Yes
- Scanner rules are current
- Yes
- Repository scan complete
- No
- Skill scan complete
- No
- Observed behavior
- Network or broad shell
- Last checked
- Nov 9, 2026
These are observations at the recorded commit, not a guarantee of safety. Review the source before running it.
Install this skill
Choose an agent in your Stack or copy a command below. Commands fetch the pinned commit and copy only this skill directory. Existing destinations are refused. Copying a command does not install anything.
An install command is unavailable: current rules, complete repository and skill scans, an eligible behavior level and a permitted license are required.
Repository context
- Repository stars (not skill ratings)
- 3,438
- Repository last updated
- Nov 8, 2026
- License
- Apache-2.0
Observed agent integration: No specific integration evidence. Standard SKILL.md installation does not imply verified compatibility.
- engineering Derived category
- data Derived category
- security Derived category
- data-databases Derived category
Files and excerpt
File metadata and permitted, redacted excerpts come from the recorded scan. Source links are pinned to that commit.
Browse files
SKILL.mdcore · 25,073 bytesSKILL.mdcore · 25,073 bytesSKILL.mdcore · 25,073 bytesSKILL.mdcore · 25,073 bytesreferences/client-tools.mddoc · 8,339 bytesreferences/cman-proxy.mddoc · 7,531 bytesreferences/compute-runtime.mddoc · 8,265 bytesreferences/connection-auth.mddoc · 7,365 bytesreferences/dotnet.mddoc · 6,611 bytesreferences/encryption.mddoc · 7,196 bytesreferences/java.mddoc · 6,332 bytesreferences/networking.mddoc · 6,652 bytesreferences/nodejs.mddoc · 6,119 bytesreferences/python.mddoc · 5,602 bytesreferences/ssm-tunneling.mddoc · 6,533 bytesreferences/troubleshooting.mddoc · 9,838 bytesscripts/check_rds_status.shruns · 4,460 bytesscripts/check_security_groups.shruns · 3,456 bytesscripts/check_ssl_status.sqlasset · 1,166 bytesscripts/test_connectivity.shruns · 2,203 bytesscripts/test_oracle_connection.pyruns · 6,057 bytes
Read excerpt
# 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`