oci_database_db_system resource missing necessary pdb settings

[luckeyca]

Community Note

• Please vote on this issue by adding a 👍 reaction to the original issue to help the community and maintainers prioritize this request
• Please do not leave "+1" or "me too" comments, they generate extra noise for issue followers and do not help prioritize the request
• If you are interested in working on this issue or have submitted a pull request, please leave a comment

Terraform Version and Provider Version

Terraform v1.9.3
on linux_amd64

• provider registry.terraform.io/oracle/oci v6.31.0

Affected Resource(s)

oci_database_db_system

Terraform Configuration Files

resource "oci_database_db_system" "this" {
   ......
    pdb_name       = "clpdb01"
   ......

Debug Output

Panic Output

Expected Behavior

for the very first pdb created along with the db system using oci_database_db_system resource, it should have all the necessary settings for this pdb.

Actual Behavior

there is only one argument to set pdb_name which greatly limits the settings for the very first pdb.
instead of one single argument, pdb settings should have its own block inside the database block and also allows multiple pdbs to be created at the same time as the db system is created using the terraform "dynamic" blocks feature.

Steps to Reproduce

N/A

Important Factoids

References

[tf-oci-pub]

Thank you for reporting the issue. We have raised an internal ticket to track this. Our service engineers will get back to you.

[luckeyca]

Hi, just to add. we need to make sure all the pdbs are created consistently. with this current behavior, the very first pdb is created differently with all other pdbs. it should be created in the same way as using the oci_database_pluggable_database terraform resource, or using the oci console after the db system is created. So instead of a single argument, it should be its own block, just like db_home and database blocks in the oci_database_db_system resource with all the available argument in the oci_database_pluggable_database resource