{"id":3373,"date":"2013-12-20T12:01:00","date_gmt":"2013-12-20T11:01:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-database-as-a-service-dbaas\/"},"modified":"2013-12-20T12:01:00","modified_gmt":"2013-12-20T11:01:00","slug":"oracle-database-as-a-service-dbaas","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-database-as-a-service-dbaas\/","title":{"rendered":"Implementing Oracle Database as a Service (DBAAS)"},"content":{"rendered":"<p>Oracle DBAAS (Database As a Service) offers a good solution for on demand access to software and infrastructure. In this posting, I will describe the DBAAS implementation with Enterprise Manager Cloud 12c.<\/p>\n<h3>Why Database as a Service is interesting<\/h3>\n<p>When a developer team needs a new database, the system administrator has to configure the host, the storage administrator has to configure the storage, and the database administrator has to download the latest oracle database version and install it on a host. These configuration operations last at least two days. If we need to implement a high availability solution and to configure the backup operations correctly, the total implementation time can go up to one week.<\/p>\n<p>All these operations have a cost and as organizations have more and more applications to maintain, the IT directors are starting to have a closer look at data management.<\/p>\n<p>This is why Oracle DBAAS (Database As a Service) can be an interesting solution.<\/p>\n<h3>Installing Oracle Database as a Service (DBAAS)<\/h3>\n<p>First, you have to implement the following plugins, which are required to enable Database as a Service (DbaaS) in EM Cloud 12.1.0.3.0:<\/p>\n<ul>\n<li>Enterprise Manager for Oracle Cloud<\/li>\n<li>Enterprise Manager for Oracle Virtualization<\/li>\n<li>Enterprise Manager for Oracle Consolidation Planning and Chargeback<\/li>\n<li>Enterprise Manager for Oracle Database<\/li>\n<li>Enterprise Manager for Storage Management<\/li>\n<\/ul>\n<p>We have to deploy the plugin on the management server:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas11.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12215\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas11.png\" alt=\"dbaas1\" width=\"476\" height=\"295\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12216\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas2.png\" alt=\"dbaas2\" width=\"440\" height=\"275\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12217\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas3.png\" alt=\"dbaas3\" width=\"442\" height=\"276\" \/><\/a><br \/>\nThere will be a downtime during the plugin installation; the OMS server won\u2019t be available during the configuration.<br \/>\nThe following command will show us how the deployment is running on the OMS server:<\/p>\n<pre class=\"brush: sql; gutter: false; first-line: 1\">oracle@vmtestoraem12c:\/u01\/app\/oracle\/MiddleWare_12103\/oms\/ [oms12c] emctl status oms -details\nOracle Enterprise Manager Cloud Control 12c Release 3\nWebTier is Down\nUnable to deploy or undeploy the plug-in. Oracle Management Server is down possibly because the following plug-ins are being deployed or undeployed from it. Try again after some time.\nPlug-in Deployment\/Undeployment Status\nPlug-in Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : Oracle Virtualization\nVersion\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : 12.1.0.5.0\nID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : oracle.sysman.vt\nContent\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : Plug-in\nAction\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : Deployment\nStatus\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : Deploying\nSteps Info:\nStep\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Start Time\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 End Time\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Status\nSubmit job for deployment\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 9\/6\/13 9:16:34 AM CEST\u00a0\u00a0\u00a0 9\/6\/13 9:16:34 AM CEST\u00a0\u00a0\u00a0 Success\nInitialize\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 9\/6\/13 9:16:37 AM CEST\u00a0\u00a0\u00a0 9\/6\/13 9:16:43 AM CEST\u00a0\u00a0\u00a0 Success\nInstall software\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 9\/6\/13 9:16:44 AM CEST\u00a0\u00a0\u00a0 9\/6\/13 9:16:45 AM CEST\u00a0\u00a0\u00a0 Success\nValidate plug-in home\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 9\/6\/13 9:16:47 AM CEST\u00a0\u00a0\u00a0 9\/6\/13 9:16:47 AM CEST\u00a0\u00a0\u00a0 Success\nPerform custom preconfiguration\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 9\/6\/13 9:16:47 AM CEST\u00a0\u00a0\u00a0 9\/6\/13 9:16:47 AM CEST\u00a0\u00a0\u00a0 Success\nCheck mandatory patches\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 9\/6\/13 9:16:47 AM CEST\u00a0\u00a0\u00a0 9\/6\/13 9:16:47 AM CEST\u00a0\u00a0\u00a0 Success\nGenerate metadata SQL\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 9\/6\/13 9:16:47 AM CEST\u00a0\u00a0\u00a0 9\/6\/13 9:16:47 AM CEST\u00a0\u00a0\u00a0 Success\nPreconfigure Management Repository\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 9\/6\/13 9:16:47 AM CEST\u00a0\u00a0\u00a0 9\/6\/13 9:16:47 AM CEST\u00a0\u00a0\u00a0 Success\nStop management server\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 9\/6\/13 9:16:51 AM CEST\u00a0\u00a0\u00a0 9\/6\/13 9:17:44 AM CEST\u00a0\u00a0\u00a0 Success\nRegister DLF\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 9\/6\/13 9:17:44 AM CEST\u00a0\u00a0\u00a0 N\/A\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Running\nConfigure Management Repository\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 9\/6\/13 9:17:45 AM CEST\u00a0 \u00a0\u00a0N\/A\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Running\nConfigure middle tier\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 9\/6\/13 9:17:45 AM CEST\u00a0\u00a0\u00a0 N\/A\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Running<\/pre>\n<p>&nbsp;<\/p>\n<p>After a few minutes, the Web Tier and the Oracle Management server are up and running and the needed plugins are correctly deployed.<br \/>\nWe also have to install the Cloud plugin in the same way we deployed the previous plugins.<br \/>\nFinally, the setup menu has the new Cloud infrastructure menu:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12218\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas4.png\" alt=\"dbaas4\" width=\"333\" height=\"241\" \/><\/a><\/p>\n<p>We have to create roles and users via the setup security administrators menu with its own Cloud User privileges in the following way:<br \/>\nA user named cloud_admin with the EM_CLOUD_ADMINISTRATOR role allowing it to setup and deploy the cloud.<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas6.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12219\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas6.png\" alt=\"dbaas6\" width=\"245\" height=\"236\" \/><\/a><\/p>\n<p>A user named dbaas_administrator who has the em_ssa_administrator role to define quotas and constraints for the self-service user and grant them access privileges:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12220\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas5.png\" alt=\"dbaas5\" width=\"295\" height=\"285\" \/><\/a><\/p>\n<p>And finally, a user named dbaas_exploit will be the self-service portal user:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas7.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12221\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas7.png\" alt=\"dbaas7\" width=\"311\" height=\"295\" \/><\/a><\/p>\n<p>Once all the plugins are installed, the first operation consists in creating a PaaS infrastructure zone. A Paas (Paltform As A Service) zone is a group of hosts discovered in Enterprise Manager Cloud 12c.<br \/>\nConnected as cloud_admin. From the Enterprise menu, Middleware and database Cloud, we select Create Paas Infrastructure Zone:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas8.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12222\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas8.png\" alt=\"dbaas8\" width=\"229\" height=\"166\" \/><\/a><\/p>\n<p>We define a development zone with members of type host and we define the maximum CPU and memory utilization:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas9.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12223\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas9.png\" alt=\"dbaas9\" width=\"397\" height=\"218\" \/><\/a><\/p>\n<p>We define credentials and we add hosts:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas10.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12224\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas10.png\" alt=\"dbaas10\" width=\"605\" height=\"171\" \/><\/a><\/p>\n<p>We select the roles that can access this Paas zone:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas111.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12225\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas111.png\" alt=\"dbaas11\" width=\"520\" height=\"180\" \/><\/a><\/p>\n<p>Finally, the Pass infrastructure zone is correctly created:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas12.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12227\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas12.png\" alt=\"dbaas12\" width=\"605\" height=\"255\" \/><\/a><\/p>\n<p>In the same way, we can create a Production zone made of production hosts:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas13.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12228\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas13.png\" alt=\"dbaas13\" width=\"605\" height=\"154\" \/><\/a><\/p>\n<p>A database pool is a set of resources that can be used to provision a database instance in a Paas infrastructure zone. We can define pools for databases and pool for schemas.<br \/>\nA pool for databases is a collection of servers with database software installed.<br \/>\nA pool for schemas is a collection of databases containing schemas.<\/p>\n<p>From a practical point of view, the database administrator will create provisioning profiles which will be stored in the software library. A provisioning profile can be an Oracle database with or without the software, or can an extract of a database. Provisioning profiles can be created using rman backups, dbca templates, snapshots, or expdp dumps.<\/p>\n<p>In the following example, I will show you how to create a database pool with a rman backup and a schema pool.<br \/>\nConnected as DBAAS_ADMINISTRATOR, we can create a database pool as follows:<br \/>\nFrom the setup menu, we select Cloud and Database:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas14.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12229\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas14.png\" alt=\"dbaas14\" width=\"242\" height=\"193\" \/><\/a><\/p>\n<p>We fill in the pool name, the credentials, the PaaS zone, the platform version, and the oracle software version.<br \/>\nYou should then immediately test the credentials:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas15.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12230\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas15.png\" alt=\"dbaas15\" width=\"464\" height=\"194\" \/><\/a><\/p>\n<p>Concerning the &#8220;Request Settings&#8221;, I set everything on &#8220;No restriction&#8221;:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas16.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12231\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas16.png\" alt=\"dbaas16\" width=\"328\" height=\"263\" \/><\/a><\/p>\n<p>I define the following quotas: 4 Gb memory, 100 Gb storage, and 10 schema service requests:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas17.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12232\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas17.png\" alt=\"dbaas17\" width=\"605\" height=\"114\" \/><\/a><\/p>\n<p>It\u2019s time now to define a database provisioning profile. In my example, I will chosse Structure only with a database template:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas18.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12233\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas18.png\" alt=\"dbaas18\" width=\"605\" height=\"167\" \/><\/a><\/p>\n<p>Or an RMAN backup:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas19.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12234\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas19.png\" alt=\"dbaas19\" width=\"605\" height=\"185\" \/><\/a><\/p>\n<p>We submit the Database Provisioning Profile creation; we can view the deployment in the Procedure Activity screen:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas20.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12235\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas20.png\" alt=\"dbaas20\" width=\"605\" height=\"256\" \/><\/a><\/p>\n<p>The next page shows that the Profile has been correctly created in the Procedure Activity page:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas21.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12236\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas21.png\" alt=\"dbaas21\" width=\"605\" height=\"182\" \/><\/a><\/p>\n<p>The next step consists in creating a service template: We give a name and a description, and choose the database type.<br \/>\nWe also have to specify a prefix for the database to be created in the future, as well as a domain name:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas22.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12237\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas22.png\" alt=\"dbaas22\" width=\"605\" height=\"190\" \/><\/a><\/p>\n<p>We define the storage type (ASM or File System), administrator Credentials, and select &#8220;Next&#8221;:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas23.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12238\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas23.png\" alt=\"dbaas23\" width=\"605\" height=\"256\" \/><\/a><\/p>\n<p>We can also define specific initialization parameters:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas24.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12239\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas24.png\" alt=\"dbaas24\" width=\"605\" height=\"134\" \/><\/a><\/p>\n<p>We also have the possibility to define scripts to be run before and after the service instance creation:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas25.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12240\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas25.png\" alt=\"dbaas25\" width=\"605\" height=\"195\" \/><\/a><\/p>\n<p>Then we select a zone and assign a pool and define a role:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas26.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12241\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas26.png\" alt=\"dbaas26\" width=\"605\" height=\"127\" \/><\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas27.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12242\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas27.png\" alt=\"dbaas27\" width=\"605\" height=\"115\" \/><\/a><\/p>\n<p>We can review our settings before submitting:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas28.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12243\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas28.png\" alt=\"dbaas28\" width=\"561\" height=\"238\" \/><\/a><\/p>\n<p>We can also define a schema pool. Let&#8217;s create a new database pool:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas29.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12244\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas29.png\" alt=\"dbaas29\" width=\"605\" height=\"217\" \/><\/a><\/p>\n<p>As before, we set the services requests to no restrictions and allow the same quotas.<br \/>\nThen we create a profile and select export Schema definition:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas30.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12245\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas30.png\" alt=\"dbaas30\" width=\"605\" height=\"168\" \/><\/a><\/p>\n<p>We select the schema name and the directory location:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas31.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12246\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas31.png\" alt=\"dbaas31\" width=\"605\" height=\"196\" \/><\/a><\/p>\n<p>Let&#8217;s review our settings before submitting:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas32.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12247\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas32.png\" alt=\"dbaas32\" width=\"605\" height=\"223\" \/><\/a><\/p>\n<p>Then we create a service template that will be available in the self-service portal:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas33.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12248\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas33.png\" alt=\"dbaas33\" width=\"284\" height=\"201\" \/><\/a><\/p>\n<p>We have the possibility to define the schemas details:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas34.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12249\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas34.png\" alt=\"dbaas34\" width=\"260\" height=\"229\" \/><\/a><\/p>\n<p>We select the zone and the resource pool the service template will provision:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas35.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12250\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas35.png\" alt=\"dbaas35\" width=\"448\" height=\"261\" \/><\/a><\/p>\n<p>We define the roles authorized to use this service template:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas36.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12251\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas36.png\" alt=\"dbaas36\" width=\"277\" height=\"169\" \/><\/a><\/p>\n<p>We review our settings:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas37.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12252\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas37.png\" alt=\"dbaas37\" width=\"545\" height=\"234\" \/><\/a><\/p>\n<p>Finally we have created two service templates: one for creating a 11.2.0.3 database and another containing a schema dump.<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas38.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12253\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas38.png\" alt=\"dbaas38\" width=\"605\" height=\"221\" \/><\/a><\/p>\n<p>Notice that the provisioning profiles can be seen in the software library:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas39.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12254\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas39.png\" alt=\"dbaas39\" width=\"591\" height=\"157\" \/><\/a><\/p>\n<p>Now we have to access the self-service portal as a normal user. We will use the dbaas_exploit user and the Schema as a service.<br \/>\nFrom the Enterprise Menu, we select the Cloud and Self Service Portal:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas40.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12255\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas40.png\" alt=\"dbaas40\" width=\"214\" height=\"219\" \/><\/a><\/p>\n<p>Select My Database, and in the Request tab, select schema:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas41.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12256\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas41.png\" alt=\"dbaas41\" width=\"283\" height=\"162\" \/><\/a><\/p>\n<p>We select the Service Template named HR:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas42.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12257\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas42.png\" alt=\"dbaas42\" width=\"286\" height=\"201\" \/><\/a><\/p>\n<p>The original schema name HR will be created in the target database with the new name DBAAS_EXPLOIT_HR.<br \/>\nWe fill in the password for this new schema and select submit:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas43.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12258\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas43.png\" alt=\"dbaas43\" width=\"605\" height=\"179\" \/><\/a><\/p>\n<p>The next screen shows the provisioning screen:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas44.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12259\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas44.png\" alt=\"dbaas44\" width=\"605\" height=\"146\" \/><\/a><\/p>\n<p>By selecting DBAAS_CREATE#63, we can follow the deployment:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas45.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12260\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas45.png\" alt=\"dbaas45\" width=\"522\" height=\"307\" \/><\/a><\/p>\n<p>In the target database, the dbass_exploit_hr schema is created and the data is successfully imported:<\/p>\n<div style=\"background: #ffff99;padding: 1pt 4pt;border: 1pt solid windowtext\">\n<p style=\"background: #ffff99;padding: 0in\">SQL&gt; select username from dba_users where username like &#8216;DBAAS%&#8217;;<\/p>\n<p style=\"background: #ffff99;padding: 0in\"><strong>DBAAS_EXPLOIT_HR<\/strong><\/p>\n<p style=\"background: #ffff99;padding: 0in\">DBAAS_EXPLOIT<\/p>\n<p style=\"background: #ffff99;padding: 0in\">DBAAS_ADMINISTRATOR<\/p>\n<\/div>\n<p>This way, non-privileged users have the possibility to acces specific Enterprise Manager Cloud 12c interface allowing them to use resources such as create database or import schemas.<br \/>\nThe provisioning process creates a database service that is completely manageable by Oracle Enterprise Manager Cloud 12c:<br \/>\nConnected as DBAAS_ADMINISTRATOR.<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas46.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12261\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas46.png\" alt=\"dbaas46\" width=\"317\" height=\"273\" \/><\/a><\/p>\n<p>Select Middleware and Database Home:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas47.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12262\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas47.png\" alt=\"dbaas47\" width=\"605\" height=\"151\" \/><\/a><\/p>\n<p>A new service template has been defined:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas48.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-12263\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas48.png\" alt=\"dbaas48\" width=\"605\" height=\"203\" \/><\/a><\/p>\n<h3>Conclusion<\/h3>\n<p>Database as a service presents a lot of advantages for the managing of huge infrastructures:<\/p>\n<ul>\n<li>The DBAs can define a catalog in the software library containing multiple Oracle Software versions, different kind of database instances (RAC or Cluster instances), or a list of schema dumps that will be available to end-users for deployment.<\/li>\n<li>Even if the DBAAS configuration and usage can be a hard and long work, in the end, it is a very efficient way to optimize and standardize the IT environment.<\/li>\n<li>Adding the DBAAS functionality speeds up the application deployment &#8211; and, as a result, enables significant cost savings.<\/li>\n<li>Obviously, the Oracle Cloud Management Pack and the Database Lifecycle Management Pack are necessary to use those features.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Oracle DBAAS (Database As a Service) offers a good solution for on demand access to software and infrastructure. In this posting, I will describe the DBAAS implementation with Enterprise Manager Cloud 12c. Why Database as a Service is interesting When a developer team needs a new database, the system administrator has to configure the host, [&hellip;]<\/p>\n","protected":false},"author":27,"featured_media":3422,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198],"tags":[407,209,218],"type_dbi":[],"class_list":["post-3373","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-management","tag-database-as-a-service-dbaas","tag-oracle-12c","tag-oracle-enterprise-manager-cloud-12c"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Implementing Oracle Database as a Service (DBAAS) - dbi Blog<\/title>\n<meta name=\"description\" content=\"Oracle DBAAS (Database As a Service) offers a good solution for on demand access to software and infrastructure. In this posting, I will describe the DBAAS implementation with Enterprise Manager Cloud 12c.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/oracle-database-as-a-service-dbaas\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Implementing Oracle Database as a Service (DBAAS)\" \/>\n<meta property=\"og:description\" content=\"Oracle DBAAS (Database As a Service) offers a good solution for on demand access to software and infrastructure. In this posting, I will describe the DBAAS implementation with Enterprise Manager Cloud 12c.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-database-as-a-service-dbaas\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2013-12-20T11:01:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"476\" \/>\n\t<meta property=\"og:image:height\" content=\"295\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-as-a-service-dbaas\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-as-a-service-dbaas\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Implementing Oracle Database as a Service (DBAAS)\",\"datePublished\":\"2013-12-20T11:01:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-as-a-service-dbaas\/\"},\"wordCount\":1361,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-as-a-service-dbaas\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas1.png\",\"keywords\":[\"Database As A Service (DBAAS)\",\"Oracle 12c\",\"Oracle Enterprise Manager Cloud 12c\"],\"articleSection\":[\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-database-as-a-service-dbaas\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-as-a-service-dbaas\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-as-a-service-dbaas\/\",\"name\":\"Implementing Oracle Database as a Service (DBAAS) - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-as-a-service-dbaas\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-as-a-service-dbaas\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas1.png\",\"datePublished\":\"2013-12-20T11:01:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"description\":\"Oracle DBAAS (Database As a Service) offers a good solution for on demand access to software and infrastructure. In this posting, I will describe the DBAAS implementation with Enterprise Manager Cloud 12c.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-as-a-service-dbaas\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-database-as-a-service-dbaas\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-as-a-service-dbaas\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas1.png\",\"width\":476,\"height\":295},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-as-a-service-dbaas\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Implementing Oracle Database as a Service (DBAAS)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Implementing Oracle Database as a Service (DBAAS) - dbi Blog","description":"Oracle DBAAS (Database As a Service) offers a good solution for on demand access to software and infrastructure. In this posting, I will describe the DBAAS implementation with Enterprise Manager Cloud 12c.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/oracle-database-as-a-service-dbaas\/","og_locale":"en_US","og_type":"article","og_title":"Implementing Oracle Database as a Service (DBAAS)","og_description":"Oracle DBAAS (Database As a Service) offers a good solution for on demand access to software and infrastructure. In this posting, I will describe the DBAAS implementation with Enterprise Manager Cloud 12c.","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-database-as-a-service-dbaas\/","og_site_name":"dbi Blog","article_published_time":"2013-12-20T11:01:00+00:00","og_image":[{"width":476,"height":295,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas1.png","type":"image\/png"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-as-a-service-dbaas\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-as-a-service-dbaas\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Implementing Oracle Database as a Service (DBAAS)","datePublished":"2013-12-20T11:01:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-as-a-service-dbaas\/"},"wordCount":1361,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-as-a-service-dbaas\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas1.png","keywords":["Database As A Service (DBAAS)","Oracle 12c","Oracle Enterprise Manager Cloud 12c"],"articleSection":["Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-database-as-a-service-dbaas\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-as-a-service-dbaas\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-database-as-a-service-dbaas\/","name":"Implementing Oracle Database as a Service (DBAAS) - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-as-a-service-dbaas\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-as-a-service-dbaas\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas1.png","datePublished":"2013-12-20T11:01:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"description":"Oracle DBAAS (Database As a Service) offers a good solution for on demand access to software and infrastructure. In this posting, I will describe the DBAAS implementation with Enterprise Manager Cloud 12c.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-as-a-service-dbaas\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-database-as-a-service-dbaas\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-as-a-service-dbaas\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/dbaas1.png","width":476,"height":295},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-as-a-service-dbaas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Implementing Oracle Database as a Service (DBAAS)"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/3373","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=3373"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/3373\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/3422"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=3373"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=3373"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=3373"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=3373"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}