Grid DBA

Uploaded slide from my KScope 14 presentation: "Databases for the Masses: Self-Service Oracle Multitenant with APEX" Here are a couple of short demos on using the PDBSS application.

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 ...

Oracle Enterprise Manager Cloud Control 12c allows us to customize the page that self service users see when logging in instead of the usual EM Console login page. This is useful for Cloud Providers who offer private cloud services to their clients. With just a few small steps you can have your own customized login  page. Enable the SSA login page $ emctl set property -name oracle.sysman.ssa.logon.ssa_oms -value true Oracle Enterprise Manager Cloud Control 12c Release 2 Copyright (c) 1996, 2012 Oracle Corporation.   All rights reserved. SYSMAN password: Property oracle.sysman.ssa.logon.ssa_oms for oms oms.example.com:4889_Management_Service has been set to value true OMS restart is required to reflect the new property value Set a custom alternate text message for the Cloud Provider on the login page.  $ emctl set property -name oracle.sysman.ssa.logon.cloud_provider_alt_text -value "Nelson Cloud Provider" Oracle Enterprise Manag...

The information technology industry has been a tremendous growth in Cloud delivery models for IT services in the past couple of years. More recently, the PaaS service model including Database-as-as-Service (DBaaS) has been gaining traction rapidly. Amazon's RDS public DBaaaS service supports Oracle, MySQL and SQL Server and enable rapid development lifecycles by giving end-users the ability to provision databases on demand in a very short period. Security and control are two drawbacks seen in public cloud environments. How can this be overcome while delivering the same level of rapid provisioning, elasticity and multi-tenancy for databases? Oracle Enterprise Manager Cloud Control 12c provides a complete lifecycle management framework for databases - from provisioning to patching. The Database Cloud plug-in enables DBaaS for users on premise without the drawbacks of public clouds. If developers want copies of schemas then the Schema-as-a-Service sub-model can enable them to sel...