terraform-aws-rds icon indicating copy to clipboard operation
terraform-aws-rds copied to clipboard
verified publisher icon terraform-aws-modules

Support for Multi-Tenant Oracle RDS Architecture

Open prashanthparsi opened this issue 7 months ago • 4 comments

Description

Currently, it is not possible to create an Oracle RDS instance with multi-tenant architecture using the Terraform AWS RDS module. The issue arises because the enable_pluggable_database parameter is a static, non-modifiable parameter tied to the engine default parameter group. AWS does not allow this parameter to be set or overridden in a custom parameter group.

Steps to Reproduce

  1. Attempt to create a custom parameter group with enable_pluggable_database set to TRUE.
  2. Assign the custom parameter group to an Oracle RDS instance during creation.
  3. Observe that the instance is created with single-tenant architecture, and Terraform throws an error indicating that the parameter cannot be modified.

Expected Behavior

The module should provide a way to create Oracle RDS instances with multi-tenant architecture by leveraging the engine default parameter group or other AWS-supported mechanisms.

Actual Behavior

Terraform cannot explicitly set the enable_pluggable_database parameter, and the instance defaults to single-tenant architecture.

Environment

  • Terraform AWS Provider Version: 5.94.1
  • Terraform Version: 1.11.4
  • AWS Region: us-east-1

Additional Context

This limitation is due to AWS's handling of the enable_pluggable_database parameter. It would be helpful if the module documentation clarified this limitation and provided guidance on creating multi-tenant Oracle RDS instances.

References

prashanthparsi avatar May 12 '25 20:05 prashanthparsi

This limitation is due to AWS's handling of the enable_pluggable_database parameter. It would be helpful if the module documentation clarified this limitation and provided guidance on creating multi-tenant Oracle RDS instances.

This sounds like something that is not related to the module but AWS RDS itself - unless I am mistaken, it doesn't sound like there is anything we need to do here in the module

bryantbiggs avatar May 12 '25 22:05 bryantbiggs

This issue has been automatically marked as stale because it has been open 30 days with no activity. Remove stale label or comment or this issue will be closed in 10 days

github-actions[bot] avatar Jun 12 '25 00:06 github-actions[bot]

Any update on this? Is there any plan on supporting this?

prashanthparsi avatar Jun 12 '25 05:06 prashanthparsi

This limitation is due to AWS's handling of the enable_pluggable_database parameter. It would be helpful if the module documentation clarified this limitation and provided guidance on creating multi-tenant Oracle RDS instances.

This sounds like something that is not related to the module but AWS RDS itself - unless I am mistaken, it doesn't sound like there is anything we need to do here in the module

@bryantbiggs AWS supports creating RDS with multi tenant architecture. Are you telling this is the limitation on AWS providers of terraform?

prashanthparsi avatar Jun 12 '25 05:06 prashanthparsi

This issue has been automatically marked as stale because it has been open 30 days with no activity. Remove stale label or comment or this issue will be closed in 10 days

github-actions[bot] avatar Jul 13 '25 00:07 github-actions[bot]

This issue was automatically closed because of stale in 10 days

github-actions[bot] avatar Jul 23 '25 00:07 github-actions[bot]

I'm going to lock this issue because it has been closed for 30 days ⏳. This helps our maintainers find and focus on the active issues. If you have found a problem that seems similar to this, please open a new issue and complete the issue template so we can capture all the details necessary to investigate further.

github-actions[bot] avatar Aug 22 '25 02:08 github-actions[bot]