- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 68 Insurance
- 536.9K On-Premises Infrastructure
- 138.5K Analytics Software
- 38.6K Application Development Software
- 5.9K Cloud Platform
- 109.5K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Provisioning DBs in a 'Private Database Cloud'
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'?