When creating Autonomous or DBCS, it is not possible to specify region

[hyder]

When creating a new Autonomous DB or Base DB system, it is currently not possible to specify the region where we want the database created. This is because the CRD itself doesn't define it and this imposes an unnecessary constraint of having to run a Kubernetes cluster in the same region just to provision the database in the target region.

It would be very desirable to be able to specify the target database's region and allow the operator to create it.

[laguvard]

I suppose you use instance principal. If you use the ociConfig section, you can create ADB in any tenancy & region. I've been doing that lately from a minikube cluster on my dev machine.

[anders-swanson]

Instance principal, yes, region is not configurable. But that's OK, usually we want to use instance principal in the same region as the instance.

While ociConfig may be available for user principal and workload identity, I couldn't find the documentation specifying how to use ociConfig. E.g., I was looking for something like:

To authenticate with user principal, set ociConfig to a configmap and secret with the following values...

configmap, secret definitions

... another example for workload identity

[s1saurabh]

Refer this https://github.com/oracle/oracle-database-operator/blob/main/docs/dbcs/README.md#1-create-a-kubernetes-configmap-in-this-example-we-create-a-kubernetes-configmap-named-oci-cred-with-the-oci-account-we-are-using

Now there is option to specify region for Oracle Base Database Service to create Database in specified region in Configmap, If this the same you are looking for DBCS, then i think we can close this now.

[psaini79]

Please refer the above links posted by @s1saurabh. If you see any issue, please reopen it.