How Do I Resolve a "Failed to verify the target database" Error When Switching the Tenant's Database

If you are a tenant Administrator and you get an error Failed to verify the target database. in the Change Tenant Database dialog when switching the database used by Visual Builder, it might be because the database is not reachable, or because you don't have the required privileges.

To resolve the error, try the following:

1. Confirm the target database is publicly accessible. Visual Builder cannot reach databases in private subnets.
2. Create the ADMIN user (adminuser) and grant the user the required roles:

   CREATE USER [adminuser] IDENTIFIED BY [password];
   GRANT CONNECT, RESOURCE, DBA TO [adminuser];
   GRANT SELECT ON SYS.DBA_PROFILES TO [adminuser] WITH GRANT OPTION;
   GRANT SELECT ON SYS.DBA_USERS TO [adminuser] WITH GRANT OPTION;
   GRANT SELECT ON SYS.DBA_DATA_FILES TO [adminuser] WITH GRANT OPTION;
   GRANT SELECT ON SYS.DBA_SEGMENTS TO [adminuser] WITH GRANT OPTION;

3. Assign the SYSOPER and SYSDBA roles to the ADMIN user (adminuser):

   GRANT SYSOPER, SYSDBA TO [adminuser];

You can run the following query to confirm the ADMIN user has the necessary privileges:

select * from v$pwfile_users;