Typically this can take days and sometimes weeks as well – using DBaaS with EM12c we reduce the time to deliver to minutes!
Not only is this time consuming and inefficient but this very process has caused the problems we face today around database and server sprawl, multiple versions and patch levels, high cost of deployment and operation, poor resource utilization – the current state of most database deployments is largely siloed and complex.
In this example we see a use case of DBaaS where a Developer is able to create an Oracle 12c pluggable database without any intervention of the DBA by submitting a Service Request using a Service Catalog– but the DBA still controls what the developers can and cannot do.
We will introduce DBaaS concepts like Platform as a Service (PaaS) Infrastructure Zones, Database Resource Pools, Service Templates, Quotas, Service Catalogs and finally an example of Chargeback and Metering as well.
We also associate the SSA role we created earlier so as to regulate access to the PaaS Infrastructure Zone.
The next step is to create a Database Resource Pool – this will be based on databases and Oracle Homes existing on the hosts that make up the PaaS Infrastructure Zone. A Database Pool is a collection of resources (homogenous databases and Oracle Homes) to provision a database instance within a PaaS Infrastructure Zone – so basically the same platform, type and version. We can create a Database Pool for Database as a Service, Schema as a Service or PDB as a service. Also at the Database Resource Pool level we can specify some placement constraints to control resource utilization. Through the use of Quotas we can also control and limit resource utilization at the SSA user or role level.
In this example we are creating a service template for provisioning an EMPTY PLUGGABLE DATABASE. The PaaS Infrastructure Zone earlier created is associated with the Service Template and we also assign the Database Resource Pool as well. The Service Template can also define other things like the number of tablespaces which will be created in the pluggable database, the total size of the PDB, init.ora parameters and other resource limits like number of database sessions etc. The DEV_SSA user will request the creation of a 12c Pluggable Database from the Service Catalog available via the Self Service Portal.


Note that the DEV_SSA user has been provided in this example a limit of just one single service request and a quota of 1 GB of RAM and 1 GB of disk space and this quota is exhausted when he submits the service request for the creation of the pluggable database.
After the request completes a Pluggable Database has been created and is now available for use by the developer. So in this case a developer has created a 12c Pluggable Database with no involvement of the DBA or the System Administrator or Storage Administrator in a few minutes.
Simply put,based on resource usage charges are calculated and then allocated or metered to individual cost centers who are consumers of the Database as a Service offering. In this example we create a charge plan for the Pluggable Database entity and the metric being used to calculate the charges is Uptime of the database. The SSA user can also view a number of reports of the Metering and Charges and there is an Enterprise Manager job which runs once in a 24 hour period collecting such data which is displayed in the reports. In this case we are forcing the manual collection of data and once the job completes we can see a number of graphical reports on Chargeback data showing the usage or consumption and amount which is payable for usage of the service and the same is displayed on a daily basis as well in case the user wishes to get a day by day breakdown of the Chargeback. If you have configured 11gR2 database already, then most of the below pre-requisites would be already configured. Here you can see the URLs to access Enterprise Manager Cloud Control and Admin Server via web browser.
The information in this weblog is provided "AS IS" with no warranties, and confers no rights.
Unlike previous releases OEM 12c can now detect and discover targets even before the management agents are deployed on managed hosts.
Once targets are discovered, we can use the promotion process to convert these unmanaged hosts into managed hosts by deploying the management agents on these hosts.
We can schedule regular jobs using an existing management agent to continually perform scans so that when new Oracle components are added to our infrastructure they are automatically discovered and brought under OEM12c management.
Since the entire network will be scanned, the Sudo Privilege Delegation must be set on the Management Agent host that will perform the scan.


We can provide a name for the IP scan job and enter either the IP address or range of IP addresses to scan and we can also enter just a hostname or group of hostnames to scan. For the given host or IP address or range of IP addresses we can specify which ports we want to scan.
In this case for example we have added the listener port 1523 to the list of default ports for scanning which are supplied out of the box. We can see that on the provided IP address to scan  a host running on the Linux platform has been discovered. It then goes to his manager for approval.Once that stage is passed the DBA comes into the picture and the DBA in turn will contact the Storage and System Admin to request the hardware and storage. Hosts are targets identified in Enterprise Manager and a single host can be a member of only one PaaS Zone. In this way we are regulating which hosts or OVM zones can be used by a particular SSA user as well as the type of database that can be created via the Self Service Portal. The DBA or Cloud Administrator still controls which physical host the database is created on ,which Container Database the pluggable database is a tenant of, how much resources can be allocated in terms of disk space, RAM and CPU. At the end of installation, you will be asked to run the configuration script as shown in below image. This weblog does not represent the thoughts, intentions, plans or strategies of my employer. We can then click on the Promote button which will bring us to the Add Host Targets wizard from where we can  automatically deploy the 12c management agent. There could be OS and Network setup involved as well and then finally the DBA will create the database and then provide access to the developer.



How much does it cost to unlock an iphone 5 icloud
Backup samsung galaxy to cloud computing
Ghosts online storage cannot upload images
Owncloud contacts import vcf


Comments

  1. 24.02.2016 at 16:58:32


    Carbonite, for instance, have freedom to easily access and share all your.

    Author: GUNESHLILI
  2. 24.02.2016 at 17:26:41


    Increase as we move deeper into would be on price and customer needs, IBM is the only object oracle cloud control 12c create user programmatically storage provider.

    Author: heboy
  3. 24.02.2016 at 23:39:32


    Also have the option to upgrade such as Dropbox.

    Author: Refraktor
  4. 24.02.2016 at 21:56:24


    Environments very different from the ones in place.

    Author: mio