Grid DBA

Database-as-a-Service (DBaaS) has now become a buzzword in the IT industry. Organizations are starting to r ealize the benefits of database as a service thanks to the ubiquity of "The Cloud". Companies relying on Oracle databases for managing their data can also get on the DBaaS fast track thanks to Oracle Enterprise Manager Cloud Control 12c. Using EM12c you can enable self-service and rapid provisioning of Oracle databases and enjoy all the benefits (well most) of Cloud computing.  EM12c supports both IaaS and PaaS models. These are also tightly integrated with Oracle VM Server along with their engineered systems including Oracle Exadata Database Machine. Setting up and configuring DBaaS requires several steps. While these are well-documented , it seems like a daunting task for those who are unfamiliar with process. A list of steps required to setup DBaaS include the following: ■Create Roles and Users ■Setup Privilege Delegation ■Add Hosts ■Configure Software Lib...

This is a quick note on some useful EMCLI commands for enabling and managing Pluggable Database-as-a-Service (PDBaaS). Get Paas Zone details emcli get_paas_zone_detail -name="DBA_Test_Zone"   Name                               DBA_Test_Zone   Named Credentials                NC_HOST_2012-10-20-160312   Number of Hosts                  5   Roles                            CLOUD_DBA   Maximum Memory Allocation (%)    90   Maximum CPU Utilization (%)      8 0 Update PaaS zone placement policy constraints ...