Netsoftmate

Tag: DBCS

  • Oracle Database Cloud Service (DBCS) Workflow

    To start using Oracle Database Cloud Service, follow the guidelines as below:

    • Sign up for a free credit promotion or purchase a subscription
    Fill in your information, and sign up for a free credit promotion or purchase a subscription to Oracle Database Cloud Service.

    • Add and manage users and roles
    Create user accounts and assign them appropriate privileges and assign the necessary Database Cloud Service roles.

    • Create a database deployment
    Use create service wizard (GUI interface) to create a new database deployment.

    • Enable network access
    Allow access to network services associated with your database deployments.

    • Load data into the database
    Use Oracle Database tools to load data into your databases.

    • Monitor database deployments
    Checkout health and performance of individual database deployments.

    • Monitor the service
    Check on the day-to-day operation of your service, monitor performance, and review important notifications.

    • Patch a database deployment
    Apply or Rollback a patch

    • Back up a database deployment
    Perform database backup and restore



    Illustration


    Conclusion

    In this article we have seen Typical Workflow of an Oracle Database Cloud Service. It is very easy to start a subscription, create a database deployment and perform several other tasks listed in the Workflow.

  • Oracle DBCS Storage Volumes and File System Layout

    Oracle uses simple and most efficient Storage Volumes and
    File System Layout in Oracle Database Cloud Service (DBCS) for the ease of use
    and management.


    Let’s take a look at the
    Oracle Database Cloud Services Storage Volume and File System Layout in more
    details.

    When you create a database deployment, Oracle Database Cloud
    Services (DBCS) creates the following Storage Layout and File Systems for you.

    Storage Volumes

    Storage Volume
    Description
    bits
    60
    GB volume completely allocated to /u01 on the
    virtual machine.
    boot
    32 GB volume allocated to the
    following file system mounts on the virtual machine:
    • / (root)
    • /boot
    • swap space
    data
    GB size equal to the value
    provided in the Usable
    Data Storage     field
    during the database deployment creation process, with a minimum of 15 GB.
    This volume is completely allocated to /u02 on the
    virtual machine.
    fra
    GB size depends on the choice of Backup Destination during the database deployment
    creation process:



    • Both Cloud Storage and Local Storage: GB size equal to 1.7 times the
      size of the       data
      volume.
    • Cloud Storage Only or None: GB size equal to 0.1 times the
      size of the       data
      volume, with a
      minimum of 7 GB



    This volume is completely
    allocated to /u03 on the virtual machine.
    redo
    10
    GB volume completely allocated to /u04 on the
    virtual machine.

    Storage Volumes of an Oracle Database Deployment



    File System Layout

    File System mount point
    Description
    swap
    Swap
    space:     4 GB
    allocated from the boot
    Compute Cloud
    storage volume.
    / (root)
    Operating
    system files:
    25.5 GB allocated from the boot
    Compute Cloud
    storage volume.
    /boot
    Operating
    system kernel:
    500 MB allocated from the boot
    Compute Cloud
    storage volume.
    /u01
    Oracle
    product software:
    the entire bits
    Compute Cloud
    storage volume.
    /u02
    Oracle
    Database data storage:
    the entire data
    Compute Cloud
    storage volume.
    /u03
    Database
    backup storage:
    the entire fra
    Compute Cloud
    storage volume.
    /u04
    Database redo logs: the entire redo Compute Cloud storage volume.


    File System Layout of an Oracle Database Deployment




    Conclusion

    In this article we have learned about Oracle Database Cloud Services
    Storage Volumes and File System Layout. When you create a database deployment, Oracle
    Database Cloud Services (DBCS) creates the Storage Layout and File Systems for
    you.

  • Oracle Database Cloud Services (DBCS) Overview

    Oracle Database Cloud Service (DBCS) provides you
    the ability to deploy Oracle databases in the Oracle Cloud. Each database
    deployment contains a single Oracle database in a Virtual machine image. You
    can’t create multiple databases in one database deployment if you want to
    create multiple databases then you create a 12c Container database with
    multiple Pluggable databases. Oracle DBCS or also known as DBaaS is part of
    Platform as a Service (PaaS) offering. The compute, virtual machine, storage,
    network, optionally tools to simplify routine database maintenance and
    management operations are provided by Oracle. You will have full access to the
    features and options available with Oracle Databases.

    When you create a database deployment, Database
    Cloud Service creates compute nodes to host the database, using computing,
    storage and networking resources provided by various Oracle Cloud
    infrastructure services.

    Service
    Level

    Service Level
    Details
    Oracle Database Cloud Service – Virtual Image
    Compute Allocated
    Storage Allocated
    Virtual Machine Image Installed
    Included software to create Oracle Database
    Connect to VM and run DBCA to create Database
    You are responsible for maintenance operations such as Backup , Patching
    and Upgrade
    Oracle Database Cloud Service
    Compute Allocate
    Storage Allocate
    Virtual Machine Image Installed
    Set Keys and Privileges
    Install and Configure Database
    Configure Backup
    Configure Tools
    Configure Access

    Note: Oracle Database 12c Release 2 (12.2) is not
    available for Oracle Database Cloud Service – Virtual Image service level.

    Selecting Service Level During Database Deployment


    Metering
    Frequency

    Frequency
    Description
    Hourly
    Pay only for the
    number of hours used during your billing period.
    You cannot switch a deployment from hourly to monthly metering
    frequency after it is created.
    Monthly
    Pay one price for
    the full month irrespective of the number of hours used.
    You cannot switch a deployment from hourly to monthly metering
    frequency after it is created.

    Selecting Metering Frequency During Database Deployment


    Cloud
    Tooling for Database Cloud Service

    Purpose
    Tool
    Description
    Automated Backup
    bkup_api
    To perform on-demand
    backup and change how automatic backups are configured. Use     raccli     for Real Application Clusters
    deployment.
    Automated Recovery
    dbaascli
    To perform
    restore/recovery. Use     raccli
     for RAC deployment.
    Automated Patching
    dbaascli
    To apply patches. Use
    raccli     for RAC deployment
    Database Monitoring
    DBaaS Monitor
    To monitor Oracle
    Database and Computing Resources

    Oracle
    Database Software Release

    When creating a database deployment on Oracle
    Database Cloud Service (DBCS), you choose one of the following Oracle Database
    software releases:
    • Oracle Database 11g Release 2
    • Oracle Database 12c Release 1
    • Oracle Database 12c Release 2
    Selecting Software Release During Database Deployment


    Oracle
    Database Software Edition

    Edition
    Options Included
    Packs Included
    Standard Edition
    None
    None
    Enterprise Edition
    None
    None
    Enterprise Edition – High Performance
    Advanced Analytics,
    Advanced Compression, Advanced Security, Database Vault, Label Security,
    Multitenant, OLAP, Partitioning, Real Application Testing, Spatial and Graph
    Cloud Management for
    Oracle Database, Database Life Cycle Management, Data Masking and Subsetting,
    Diagnostics, Tuning
    Enterprise Edition – Extreme Performance
    Active Data Guard,
    Advanced Analytics, Advanced Compression, Advanced Security, Database
    In-Memory, Database Vault, Label Security, Multitenant, OLAP, RAC,
    Partitioning, Real Application Testing, Spatial and Graph
    Cloud Management for
    Oracle Database, Database Life Cycle Management, Data Masking and Subsetting,
    Diagnostics, Tuning
      
    Selecting Software Edition During Database Deployment


    Oracle
    Database Type

    Database Type
    Description
    Single Instance
    A single Oracle
    Database instance and database data store hosted on one compute node.
    Database Clustering with RAC
    A two-node clustered
    database using Oracle Real Application Clusters technology; two compute nodes
    each host an Oracle Database instance, and the two instances access the same
    shared database data store.
    Single Instance with Data Guard Standby
    Two single-instance
    databases, one acting as the primary database and one acting as the standby
    database in an Oracle Data Guard configuration.
    Database Clustering with RAC and Data Guard
    Standby
    Two two-node Oracle
    RAC databases, one acting as the primary database and one acting as the
    standby database in an Oracle Data Guard configuration.
    Data Guard Standby for Hybrid DR
    Single-instance
    database acting as the standby database in an Oracle Data Guard
    configuration. The primary database is on your own system.

    Selecting Database Type During Database Deployment


    Automatic
    Backup Configuration

    When you create a new database deployment on DBCS,
    you can choose whether you want to configure automatic backup for your
    database.

    Backup Option
    Description
    Both Cloud Storage and Local Storage
    30 days worth of
    backups are kept, with the 7 days most recent backups available directly on
    the compute node’s local storage.
    Cloud Storage Only
    30 days worth of
    backups are kept, with all backups on cloud storage.
    None
    No automatic backups
    are configured

    Selecting Backup Destination during Database deployment

    Conclusion

    In this article we have learned about Oracle
    Database Cloud Services (DBCS). Oracle Database Cloud Service (DBCS) provides
    you the ability to deploy Oracle databases in the Oracle Cloud. When you create
    a database deployment, Database Cloud Service creates compute nodes to host the
    database, using computing, storage and networking resources provided by various
    Oracle Cloud infrastructure services.

  • Oracle Cloud Quick Overview

    Oracle Cloud Overview

    • Oracle Cloud is one of the few cloud providers that can offer a complete set of cloud services to meet all your enterprise computing needs.
    • Oracle Cloud provides deployment options ranging from the public cloud to your data center.
    • Oracle Cloud offers best-in-class services across:
    • Software as a Service (SaaS),
    • Platform as a Service (PaaS),
    • Infrastructure as a Service (IaaS)


    Infrastructure As a Service (IaaS):


     Using Oracle IaaS services you can set up the virtual machines, storage, and networking capabilities you need to run any kind of workload. The entire infrastructure is managed, hosted, and supported by Oracle. You are responsible for patching and maintenance of the operating system and any other application software that you may run.


    Platform As a Service (PaaS)


     Using Oracle PaaS services you can quickly provision ready-to-use environments for your enterprise IT and development teams, so they can build and deploy applications, based on proven Oracle databases and application servers. Oracle Database as a service (DBaaS) is part of PaaS offering. You are not responsible for managing and administering the infrastructure and Operating System.


    Software As a Service (SaaS)


     Oracle SaaS allows users to subscribe and use application software in the cloud. Oracle offers cloud-based solutions for Human Capital Management (HCM), Cloud Managed Services, Enterprise Resource Planning (ERP), Supply Chain Management (SCM), HR, CX and many other applications, all managed, hosted, and supported by Oracle. You are not responsible for managing and administering the infrastructure and Operating System.


    Oracle Cloud Platform

    Oracle Cloud Platform
    Courtesy: Oracle

    Oracle IaaS and PaaS

    Oracle IaaS and PaaS
    Courtesy: Oracle

     

    Conclusion


     In this article we have learned what is Oracle Cloud and what are the different Oracle Cloud offerings currently available. Oracle Cloud offers best-in-class services across Software as a Service (SaaS), Platform as a Service (PaaS) and Infrastructure as a Service (IaaS)