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

• AWS Documentation on Oracle RDS
• Terraform AWS RDS Module Documentation