Posted on

Oracle Database Cloud Service Workflow

As with any project oracle database cloud service implementation, management is a project in itself that comes with its own set of tasks, steps, processes, procedures. All these in an organized fashion leads to oracle database cloud service workflow
Here is how an oracle database cloud service workflow typically looks like. These are the steps that you will have to follow in your upcoming oracle cloud implementation project. We have provided step by step instructions so that the checklist can come handy
1) Oracle Cloud Sign-up – If you are new to oracle cloud and want to learn cloud sign-up for free trial
1.1) Oracle Free Trial Sign-up Things to Know
Navigate to Oracle Cloud website. Click on try for Free icon in top right corner
Click on button that says Create a Free Account
This account has value upto 3500 free hours (or) $300 free countries in selected country list. Both these offers are valid upto 30 days
Do I need my credit card for free account creation with oracle cloud?
Yes. Also, note that credit card will be charged on verification hold basis. This will be very little amount that will be removed automatically
As per oracle cloud website, the actual charge incurring does happen only when we elect to upgrade our account to appropriate payment method. Kindly note that these methods are different for Oracle Cloud at customer an offering from Oracle corporation wherein Oracle cloud is implemented and managed at your data center. Lets talk about that in detail in separate post
If you dont want to make use of it, delete the account within the free trial period
1.2) Purchase Oracle Cloud Subscription
Once you are satisfied with free trial, exploring the cloud features, planning your project choose appropriate subscription
There is a cost estimation interface that comes as part of Oracle cloud. This can be made use of to simulate your monthly pricing
There are two types of payment plans that you can purchase to make use of any of the PaaS (Platform as a service) and IaaS (Infrastructure as a Service). Oracle database falls under PaaS category
Pay As you Go Payment Plan
As the name suggests pay only for what you make use of. No pre-payment required
There is no contract term
Monthly Flex payment Plan
This comes with monthly commitment to cloud services. You purchase your monthly credit to be used with your cloud services
Minimum contract term is 1 year and maximum is 4 years
If the monthly credit gets exceeded they can be extended. Additional credits will be billed accordingly
This plan is cheapest as there is a long term commitment. As per Oracle website this comes with cheapest cloud cost.
We recommend making use of cost estimator to determine which plan fits your budget
2) User Management
Once the account is created the next step is to add users, roles and manage them appropriately. Users need to be created and will have to be granted oracle database cloud service roles
3) Database Deployment
Once the users are created with appropriate privileges, database needs to be deployed. There are many different types of database deployment including Quickstart template the easiest method, create instance wizard wherein options can be customized, Cloud backup of another database which is live prod database most commonly used in live migrations, using snapshots, Hybrid disaster recovery wherein primary resides on-site and standby databases are deployed in cloud
4) Network Access
Once database is deployed now this database should be made part of network. Oracle database cloud service is deployed in compute node which is typically VM. This will be given network access via SSH protocol in default port 22. Secure shell offers secured access to instances. There are additional network configurations that can eb done on as needed basis
5) Data Load using Tools
Normal method of Oracle data load including SQL*Loader, Data Pump, Transportable tablespaces, Using PDB are some options to load data. This method is default except for that the data needs to be transferred via internet. Have a check on speed during data transfer
Oracle Public Cloud Data Transfer services to Move Large Datasets
In this method large data is physically sent closer to Oracle Public Cloud
This minimizes and avoids issue with data load speed via internet for large dataset
What happens when I make use of Oracle Public Cloud Data Transfer services to Move Large Datasets?
Oracle sends ZS4-4 storage appliance to your datacenter
2) This appliance comes with encryption keys that you need to retain before shipping back. This is needed for in-transit data security
3) This appliance needs to be mounted as NFS share in your datacenter. You install and configure this appliance, copy data using NFS mode
4) Oracle chsips this appliance to Oracle Public Cloud Data Center
5) Now, this encryption needs to be sent to Oracle using secure communication channel
6) Oracle copies the data from appliance onto storage cloud service. Logs are provided to you once data transfer is complete
7) Verify and validate these logs
8) Once you validate oracle destroys the appliance
8) Now, start loading data onto cloud database as normal database
All these steps can be done by yourself. If you want consultation service from Oracle they do offer that as well
6) Monitor Database Deployment
Monitoring database is different than monitoring cloud service. Lets first see the database health check and performance monitoring. Once databases are up and running, monitoring and managing the databases including performance health check is done utilizing the tools that come with your database version
Most recent version popular is Oracle 12c. USe Enterprise Manager Database Express 12c for this DB
For 11g database use Enterprise Manager 11g Database Control
For Latest Oracle database 18c, make use of Enterprise Manager Database Express 18c
SQL Developer Web for monitoring databases
This is a monitoring tool that is itnegral to Oracle Database Cloud Service. SQL Developer web is used in deployments hosting single-instance databases
This tool supports monitoring and management of Oracle databases as well as cloud computing resources
7) Monitoring Cloud Service
In addition to databases Oracle Cloud Services needs t be monitored and maintained on day-to-day basis
8) Patch Oracle Databases in Cloud
As with normal databases oracle cloud database deployments need to be patched. These patches can be rolled back on as needed basis
Patching Oracle database cloud service involves following steps :
Viewing available patches – This is available in oracle database cloud service console, using dbpatchm subcommand of dbaascli command
dbaas dbpatchm –run -list_patches
Make use of dbpatchmdg utility
Once you log in as opc use onto compute node run dbpatchmdh -list_patches
Check for pre-requisites before applying a patch – Make use of Oracle Database Cloud Service Console for this purpose, using dbpatchm subcommand of dbaascli command, dbpatchmdg utility in case of single-instance dataguard deployments, raccli for RAc deployments
Apply Patches – Make use of Oracle Database Cloud Service Console for this purpose, using dbpatchm subcommand of dbaascli command, dbpatchmdg utility in case of single-instance dataguard deployments, raccli for RAc deployments
Roll back a patch (or) failed patch
9) Backup Database Deployment
For continuous operation of database, business sustainability databases in cloud should be backed up as normal databases. They can be restored and recovered on as needed basis
RMAN tool is utilized for this purpose