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.

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 direct NFS or dNFS introduced in Oracle 11gR2 allows the NFS operations to be moved to the database layer instead of operating system kernel. After installing Oracle RAC 12.1.0.1 it appears the direct NFS is enabled by default. You can check the alert log to verify that the direct NFS ODM library has been loaded. Messages similar to the following will be displayed. Oracle instance running with ODM: Oracle Direct NFS ODM Library Version 3.0 Direct NFS may use several configuration files to determine the mount points on which it is used. $ORACLE_HOME/dbs/oranfstab /etc/oranfstab /etc/mtab If oranfstab is not configured then it will check the currently mounted filesystems from /etc/mtab and if the mount options are correct it will use dNFS for database I/O. For example: cat /etc/mtab | grep oraclelinuxtest filer1:/vol/volnds001_oraclelinuxtest_db/nds001 /u03/oradata nfs rw,bg,hard,nointr,tcp,nfsvers=3,timeo=600,rsize=32768,wsize=32768,actimeo=0,addr=10.10.88.19 0 0 f...

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