How to resolve OCI Storage permission issue during provisioning DBaaS
Mrityunjay Kant
CTO | Product & Engineering at CloudNuro.ai | B2B SaaS & AI Platforms | Scaling AI-as-a-Service | Cloud & Data-Driven Growth | Building for Operators & Innovators
Recently we faced an issue when provisioning DBaaS instance on Oracle Cloud Infrastructure (OCI). We followed the pre-requisites for initializing PaaS on OCI and followed this tutorial to create the DBaaS instance. Our final provisioning screen looked like below with all of the values filled in.
However, clicking next would give the following error: "Could not connect to Oracle Storage Cloud Service using the given username and password."
The error itself is misleading since the username and password were obviously correct and use of incorrect credentials caused failure to connect to the service. We switched to different users and Auth tokens with same results.
In our investigation, we found that the user permissions were not correctly set up and there is a missing step when following pre-requisites for PaaS on OCI. To fix follow these steps:
Go to OCI Console and click on hamburger icon at the top left of the screen, select Users.
Select the user being used for authentication and click on option "View User Details".
Click on Groups link in left-hand menu options. You'll notice the user is not a member of any Groups. Click on "Add User to Group" button and choose "Administrators" as the group to add.
Go back to DBaaS provisioning wizard and you should be able to move past the earlier error.