Netsoftmate

Tag: Oracle Database Cloud

  • Step 3 – Oracle DBCS : Create A Database Deployment

    There are several ways in which you can create a Database Deployment in Oracle Database Cloud Service. Some of the methods that you can use to create a Database Deployment are:

    • QuickStart Template
    • Create Service Wizard
    • Using Snapshot
    • Hybrid Disaster Recovery (DR) Deployment


    In this article we will demonstrate how to Create A Database Deployment using Create Service Wizard.




    Prerequisites:



    • Oracle Account
    • Oracle Cloud Subscription
    • SSH Public/Private Key pair


    Steps to Create a Database Deployment



    • Open a web browser and enter the URL you received in the Welcome email to login to Oracle Cloud Account
    • Enter your username and password
    • Click on the Menu as shown in the image below
    • Click on Database (OCI)
    • Click on “Go to Console”
    • Click on “Create Service”
    • Fill in all the details and click Next
      • Service Name: Enter the service name, It only accepts hyphen (-) as special character
      • Description (optional): Enter a description on the service
      • Notification Email: To send the update on Instance creation
      • Service level: Oracle Database Cloud Service
      • Metering Frequency: Monthly or Hourly
      • Software Release: 11gR2, 12cR1 or 12cR2
      • Software Edition: Enterprise, standard, Enterprise Edition – Extreme performance or Enterprise Edition – High performance
      • Database Type: Single Instance, Single Instance with Data Guard, RAC, RAC with Data Guard, Hybrid DR
    • Fill in all the details 
      • DB Name: This will be your container DB name
      • PDB Name: This will be your pluggable DB name
      • Administrator password: This will be your administrator password for users sys, system, dbaas_monitor and so on
      • Backup and Recovery Configuration: Cloud and Local, Cloud only or None
      • Compute Shape: select the configuration you need for your business
      • SSH Public Key: choose the public key you generated in steps
    http://netsoftmate.blogspot.com/2017/12/step-2-oracle-dbcs-generate-ssh-key.html
      • Click on advance settings and choose your desired option


    Steps to upload public key




    • Click Next
    • Review the Summary and click “Create”


    • At this moment the Service creation is in progress. Click on the Service Name
    • Click on the arrow symbol shown below to see the service create and delete history


    • Click refresh to check the status of service
    • The service has been created successfully
    • Up on the completion you will also receive the email that the service is created and is now available for use
    • Click on the arrow symbol and “show more” to see all the details about the service just created
    • Make a note of the IP address as it will used to connect to the compute node




    Conclusion



    In this article we have learned how to Create a Database Deployment on Oracle Database Cloud Service using Create Service Wizard. There are several ways in which you can create a Database Deployment, using the QuickStart template is the fastest and the easiest method to create a Database Deployment.




  • Step 2 – Oracle DBCS : Generate SSH Key Pair On Windows

    Oracle Database Cloud Service or simply DBCS or DBaaS is built on top of Infrastructure that is provided by Oracle Compute Cloud Service. When you create a service instance (Database Deployment for Example), all the Oracle Compute virtual machines (VMs) required to support the Database Services are provisioned and configured for you.

    You can use SSH (Secure Shell) to access the service Instance (Database VM or Database Compute node) provided by Oracle Compute Virtual Machines (VMs). Before you can access the VM, you need an SSH public/private key pair for the VM. You will need the public key when creating a service instance, and you will need the paired private key when you access it using an SSH utility.




    In this article we will demonstrate how to generate or create the public/private Key Pair.



    Prerequisites:



    • Oracle Cloud Subscription
    • Ready to Create an oracle Cloud Service Instance (Database Deployment for Example)
    • PuTTY



    Steps to Generate SSH Key Pair on Windows using PuTTYgen utility




    • Download and Install Putty Installation package for Windows
    https://www.ssh.com/ssh/putty/download


    • Start PuTTYgen program on your Windows Desktop/Laptop

    Start > All Programs > PuTTY (64 bit) > PuTTYgen


    • On PuTTYgen screen do the following:
      • Type of key to generate: Default RSA or SSH-2 RSA
      • Number of bits in a generated key: 2048
      • Click generate button


    • Move the mouse around the blank area below the process bar to generate randomness to the key.


    • The Public Key generated displayed in the Key are. The key comment is the name of the key that you will use to identify it. Enter a Key passphrase and enter it again for Confirm passphrase to password-protect your key.

    Note: Key passphrase is optional, but it is recommended to provide key passphrase as a security measure to protect the private key from unauthorized use.




    • Click “Save private key” and click Yes to continue without a key passphrase.




    • On the PuTTY Key Generate screen, select all of the characters under “Public key for pasting into OpenSSH authorized_keys file” and copy it


    • Open a text editor (example: Notepad++) and paste the characters, copied in previous step. 

    Note: Ensure all characters are copied from first character in the text editor and there is no line breaks.


    • Save the key as a text file and add a .pub extension. while you can give it any extension you want, but .pub is a useful convention to indicate that this is a public key.


    • Make a note of the public and private key name and the location.

    Note: You will need the public key when creating service instances (Database Deployment for Example) and You will need the private key when accessing virtual machine via SSH.




    Conclusion




    In this article we have learned how to generate SSH Key pair on Windows using PuTTYgen utility. You need the SSH key pair when you are ready to create the an Cloud Service Instance (Database Deployment for Example) and to access the service Instance (Database VM or Database Compute node). You will need the public key when creating a service instance, and you will need the paired private key when you access it using an SSH utility.

  • Step 1 – Oracle DBCS : Subscribe To an Oracle Cloud Service

    Before you create service instance (Database Deployment for example) on Oracle Cloud, you must subscribe to Oracle Cloud Services. Once you subscribe to an entitlement to create instance of an Oracle Cloud Service, then you can create multiple service instances based on your Business requirement.
    Subscribing to an Oracle Cloud Service consists of following 3 steps:

    • Order One of the subscription type
    • A free trail subscription to an Oracle Cloud Service
    • A paid subscription
    • Activate the Service
    • Verify the Service is running

    Note: Free Oracle Cloud Promotion Applicable to only:



    • Oracle Database Public Cloud Services
    • Oracle Analytics Public Cloud Services
    • Oracle Big Data Public Cloud Services
    • Oracle IaaS Public Cloud Services
    • Oracle Middleware Public Cloud Services


    Prerequisites:
    • Oracle Account

    In this article we will demonstrate the steps for a free trail subscription to an Oracle Cloud Service.





    • Open a web browser and enter the following URL
    http://shop.oracle.com

    or

    http://cloud.oracle.com

    For India choose http://shop.oracle.com





    • Change the country and Language


    • Login using your Oracle account


    • Click on “View Details”


    • Click on “View details”

    • Click on “Get started for free”

    • Choose your country code, Enter mobile number to receive “verification code” and click “Request Code”. Enter the Verification code received on your mobile and click “Verify”


    • Enter the Account details

    • If you are an individual select “Tax information is not available”


    • Click “Add Payment Method” and uncheck “Convert my account to Pay as You Go” to avoid charging your credit card at the end of free subscription

    • Enter “Billing Information”


    • Enter “Payment Details”


    • Verify card details and uncheck “Convert my account to Pay as You Go” to avoid charging your credit card at the end of free subscription


    • Accept “Terms and Conditions” and Click “Complete”


    • You will see the following Message on your screen




    • At this time you will receive 2 email as show below. It may take upto 24 hours to receive the the second email


    • Email 1, You will receive the following email with the Order Number


    • Email 2, Click on “Activate My Services” to activate your Oracle Cloud Services


    • Enter the “Cloud Account Name” and “Email Address”


    • Enter “First Name” and “Last Name” and Click “Create Account”. Your email ID will be your Username 


    • Click Close


    • You will receive an email with the following details:
      • Free Credits
      • Access Details: Username, Initial Password, Cloud Account name
      • My Service Administration: Use the link provided to sign in to your Oracle Cloud Account and start using Cloud Services.
      • Order Details




    • Open a web browser and enter the URL you received in the Welcome email with access details


    • Enter username and Intial password received in Welcome email with access details


    • Change the password and ensure you set a strong password 


    • Set Preferences


    • Once you login, Oracle Cloud My Services Home Page is displayed


    Conclusion

    In this article we have learned how to subscribe to Oracle Cloud Services (Free trail). Once you subscribe to an entitlement to create instance of an Oracle Cloud Service, then you can create multiple service instances based on your Business requirement.

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