Forum Stats

  • 3,855,546 Users
  • 2,264,521 Discussions


Provisioning DBs in a 'Private Database Cloud'

flying_penguin Member Posts: 256 Bronze Badge
edited May 20, 2019 1:50AM in Multitenant

DB version: 19C

OS : Orace Linux 7.6

In my shop, DBA team want to make provisioning of databases a self-service thing for the application team.

ie Application team lead can log in to DBA team's internal portal and specify their Database requirements and a DB will be provisioned for him/her.

For starters, we are planning to build a CDB in a 4 node RAC cluster consisting of Physical servers (Oracle Hardware) with 512 GB RAM on each server. 40 Physical cores (80 CPUs) on each node.This clustered DB will be connected to a Hitachi SAN storage system.

This CDB will host a large , 'common' PDB .

Based on the criticality of the requirement, requestors will be provisioned just a schema in the common PDB or a dedicated pluggable DB if the requirement is more critical.

Inputs in the web portal will be captured in a json file and the Schema or PDB will be created most likely by a bash shell script which will read the json file.

What do you guys think of this idea ? Any comments, recommendations however trivial are welcome.

BTW Is it technically accurate to call this setup a 'Private Database Cloud'?