terraform-examples
terraform-examples copied to clipboard
Issue for Creating the dbcs-instance-classic
Hi following the Guide I came across the issue with the part : backups {
cloud_storage_container = "Storage-${var.domain}/my-terraformed-database-backup"
create_if_missing = true
} so while creating the DBCS it fails at this step and says:
Failed to configure Oracle Database Server...[ SCRIPT execution errors in [129.157.177.107]: * getaddrinfo(3) failed for idcs-abcdefghijklmnopqrstuvwxyz.storage.oraclecloud.com:443 * Couldn't resolve host 'idcs-abcdefghijklmnopqrstuvwxyz.storage.oraclecloud.com' * Closing connection #0 ERROR : Connectivity problem with OSS server. ERROR : Assistant bkup has failed, please check ocde logfile /var/opt/oracle/log/ORCL/ocde/ocde_2018-08-28_15:24:06.log INFO: Total time taken by ocde is 863 seconds #### Completed OCDE with errors, please check logs #### data/ORCL/control01.ctl" control_files = "/u03/app/oracle/fast_recovery_area/ORCL/control02.ctl" ]

For the vars I am using : domain="idcs-abcdefghijklmnopqrstuvwxyz" (whatever circled in the image ) user="cloud.admin" password="******" endpoint=https://dbaas.oraclecloud.com
and for the main file I am using : https://github.com/oracle/terraform-examples/blob/master/examples/oraclepaas/dbcs-instance-classic/main.tf Let me know if I am missing something here or if things have got changed.
I see that API endpoint for storage : https://gse*******.us.storage.oraclecloud.com/v1/Storage-******* so in file it is Storage-${var.domain}/my-terraformed-database-backup which I think needs modification.
The example needs to be updated to distinguish between using the domain id in the provider details and the domain name in the storage container name - for Traditional accounts these are the same value, but for IDCS Cloud Accounts the domain id is the IDCS id (e.g. idcs-abcdefghijklmnopqrstuvwxyz) and the domain name is the cloud account name (e.g gse12345)
variable "domain_id" {}
variable "domain_name" {}
provider "oraclepaas" {
identity_domain = "${var.domain_id}"
...
}
...
backups {
cloud_storage_container = "Storage-${var.domain_name}/my-terraformed-database-backup"
...
}
...
There also appears to be a separate issue specific to GSE environments that are not exposing the storage endpoint in the required format for the DBCS provisioning - as gse*****.storage.oraclecloud.com is not accessible, but gse*****.us.storage.oraclecloud.com is.