As you probably know, Cloud has three Service Models: IaaS, PaaS, and SaaS (If you are new to Cloud and would like to know more about these Service Models then I highly recommend you to watch my previous live at http://k21academy.com/cloudlive01 ).
Note: Oracle has offerings in all three Service Models and both OCI and OCI-C are from IaaS offerings, where OCI stands for Oracle Cloud Infrastructure and OCI-C stand for Classic Version of IaaS Offering.
Oracle Cloud Infrastructure Classic (OCI-C) is IaaS offering to provide Compute & Network (Shared & IP Networks)
OCI Classic provides only Virtual Machines (whereas OCI can also provide Bare Metal)
OCI-Classic (formerly OPC announced at Oracle Open World (OOW) 2014, was renamed to OCI Classic at OOW 2017
OCI Classic can be deployed as a) Elastic Compute b) Dedicated Compute c) Sparc Model 300
As of March 2018, OCI-C is available in NAC, EMEA, APAC
Oracle Cloud Infrastructure (OCI) like OCI-C is also IaaS offering that provides Compute, Network but as Virtual Cloud Network, Availability Domain and additionally Edge Services like Email, DNS, Load Balancer etc (more on Edge Services little later)
OCI announced in OOW 2017 is re-branding of Bare Metal Cloud Service (BMCS)
OCI Classic provides both Bare Metal & Virtual Machines (whereas OCI-C provides only Virtual Machine)
Hypervisor in VM option of OCI is based on KVM (whereas on OCI-C this is Xen based Hypervisor)
When to Use What
Cloud@Cusotmer (More on this in my future posts) is subscription based service where both Hardware & Cloud Software is on Customer Premises, this option as of March 2018 is only available on OCI-Classic
OCI Classic is available on more Datacenters compared to OCI-Classic
High-Performance Compute (HPC), Artificial Intelligence (AI) and Machine Learning (ML) is available only on OCI (as of Mar 2018)
OCI-C doesn’t provide Bare Metal Option
EBS (R12) & Database both are supported on both OCI & OCI Classic so you can use either
Stay tuned for my next post on OCI Components like Regions, Availability Domain, Compartments, IAM, Virtual Cloud Network, Edge Services etc
This post covers Microservices Architecture (MA)introduced in Oracle GoldenGate12CR3 and five components that are part of this Architecture i.e. Administration, Distribution, Receiver, Service and Performance Metrics Server.Oracle GoldenGate Microservices Architecture (MA) enables you to configure, monitor, and manage Oracle GoldenGate services using REST API with JSON and also using web-based user interface.
I recently did a webinar on Oracle GoldenGate 12c for Replication & Cloud Migration including the new Architecture i.e. Microservices where GoldenGate Expert Ashish and I discussed this new MicroServices Architecture, you can watch the complete webinar HERE (Need Name and Email to watch Replay).
Microservices Architecture (MA) in Oracle Goldengate 12cR3 - YouTube
Classic VS Microservices (MA)
In Oracle GoldenGate 12.3, we have two architectures available for deploying GoldenGate
The Microservices Architecture in Oracle GoldenGate is comprised of five main components:
Performance Metrics Server
1. Service Manager: Enables to administer, monitor and manage other services available in Microservices Architecture.
2. Administration Server: An Administration Server supervises, administers, manages, and monitors processes operating within an Oracle GoldenGate deployment for both active and inactive processes. It is the central and main entity for managing the various components of a GoldenGate deployment. Administration Server can create and manage local Extract and Replicat processes even without access to the server where Oracle GoldenGate is installed.
3. Receiver Server: It provides the central services to handle all incoming trail files and communicates with the Distribution Server over the network.
4. Distribution Server: A Distribution Server is an application which functions as a networked data distribution agent in support of conveying and processing data and commands in a distributed networked deployment. The Distribution Server distributes one or more trails to one or more destinations and also performs some filtering operations if configured to do so. The Distribution Server is used to set up a relay Path between the source and target deployments.
5. Performance Metrics Server: It collects and stores performance data related to a GoldenGate deployment. Enables us to monitor performance metrics using a web application and use the data to tune deployments for maximizing performance.
Admin Client: The Admin Client is a command line utility (similar to the classic GGSCI utility). It uses the REST API published by the Microservices Architecture(MA) Servers to accomplish control and configuration tasks in an Oracle GoldenGate deployment.
The Microservices Architecture for Oracle GoldenGate 12c (188.8.131.52) installation with an Oracle Database is done as below:
Install the Oracle GoldenGate MA.
Set the necessary environment variables.
Deploy an Oracle GoldenGate instance using the Configuration Assistant.
The Microservices Architecture is installed using the Oracle Universal Installer (OUI). OUI is a graphic installation program that prompts you for the input required to install the Oracle GoldenGate binaries and working files, and set the database environment in which Oracle GoldenGate will operate. Alternatively, use a command line silent installation using OUI.
The installer registers the Oracle GoldenGate home directory with the central inventory that is associated with the selected database. The inventory stores information about all Oracle software products installed on a host if the product was installed using OUI.
Click on next to move to next screen and provide the necessary location to install Goldengate.Once all information is provided Goldengate installation will be completed.
Launch the Configuration Assistant via the oggca.sh script located in the $OGG_HOME/bin directory. Through the Configuration Assistant, we can create the Service Manager as well as configure the deployment.
A single Service Manager can support a number of deployments.
A window will pop up for creating a service manager and register it as a service.
Log in to Service Manager
To start using Oracle GoldenGateMA, we have to connect to Service Manager:
1. Open a web browser and connect to the Service Manager that we created with the Configuration Assistant. The URL is similar to http://localhost:9001, where 9001 is the port where we have deployed our Service Manager instance.
2. Enter the username and password we created during deployment and click Sign In.
Connect to Oracle GoldenGate Service Manager
Upon login, you will find the deployments done for each server as a service.
Use Administration Server to configure and create the Extract and Replicat processes. Also, create the parameter files using Administration Server.
With the help of Distribution, Server define the PUMP process and also define the trail files between sources and targets. Distribution server defines the trail files.
If you are an Oracle DBA and follow Oracle Database Blog (If you don’t then you must) then you probably know by now that Oracle released 18c Database on 16th Feb 2018 for On-Premise Exadata Server (For rest others like on-premise commodity servers and 18c Database on Cloud to follow in Q1 & Q2).
This post covers everything that you must know about Oracle Database 18c and key points from few good blogs related to 18c (References at the end of this post. If you have written about 18c Database and can’t see your blog in list then refer it in comment section).
Where Is Database 18c Available?
Oracle Database can be deployed at following places
1. On-Premise Commodity Servers with O.S. like Linux, Solaris, HP-Unix, Windows, IBM-AIX etc. 2. On-Premise Engineered Systems: Exadata, Oracle Database Appliance (ODA), Super Cluster and Mini Cluster 3. Oracle Public Cloud: DBaaS on DBCS, Exadata Cloud Service, Exadata Express Cloud Service 4. Oracle Cloud at Customer
If you refer to My Oracle Support (MOS) Note ID 742060.1 Release Schedule of Current Database Releases then as of Feb 2018, 18c Database is available only on On-Premise Exadata
Next for ODA, DBaaS/DBCS and Exadata Cloud Service, it will be released in Q1 of 2018
Note: As per Oracle Database Blog , 18c is available on Oracle Public Cloud too but I couldn’t find this on our Cloud Account nor this information on any other place.
Documentation for Database 18c?
Oracle Database is next iteration of 12c R2 covering Multi-Tenancy, In-Memory Database and Sharding
If you are like me who wants to read documentation and learn concepts then you’ll enjoy
If you are wondering where is Database version 13, 14, 15, 16 or 17 after 12c R2, then worth looking at My Oracle Support Note 2285040.1 Release Update Introduction and FAQ and Mike Dietrich’s Blog
Here is excerpt from 2285040.1 Beginning in 2018, a new numbering schema for the database software is implemented. Instead of a legacy nomenclature such as 184.108.40.206, a three (3) field format consisting of: Year.Update.Revision is used, such as 18.1.0. This allows clear indication of:
The feature release designation of the database software (the first field)
The quarterly Update (the second field)
The quarterly Revision (the third field)
Future of Oracle DBA with Cloud & Autonomous Database
Another good blog that you as an Oracle DBA must follow is Tim Hall and if you are among DBAs/Apps DBAs worried about future of DBA/Apps DBA or worried about Autonomous so let me re-iterate what Tim rightly said Oracle Database 18c is not Autonomous and here , there is nothing to worry about as DBA/Apps DBAs future (but Yes it will evolve and you as DBA will do more interesting stuff and learn new stuff)
Note: Autonomous Database as a cloud service will be based on Oracle Database 18c, is different then Oracle Database 18c is an Autonomous Database (I hope this clarifies some confusion)
DataGuard & RAC are two most important topic for Oracle DBAs & Apps DBA’s managing EBS R12, and both these are still applicable in Cloud (in fact more important now)
In this post, We are going to look at High Availability (HA) and Disaster Recovery (DR) on Cloud and I’ll be focusing on Standby Databases also known as DataGuard. The same is covered in the 60 mins Live Show I did on Facebook.
Note: First let’s look at basic concepts related to RAC or Extended RAC & for DR Standby/DataGuard: Three Types. If you know this all then scroll down at the end, for points specific to HA & DR in Oracle Cloud.
High Availability (RAC)
High Availability (HA) stands for Active-Active where clients can connect to more than one node. It helps in Scalability (can serve more clients and better response time) and avoid a single point of Failover.
RAC stands for Real Application Cluster that provides HA for Database Tier (as shown in the bottom layer of the picture below). For Application Tier, you configure multiple app/web servers (as shown in top layer of picture below)
If you don’t have the time to look at the entire 60 mins video, but still want to know about HA: Active-Active, you can start from 17 min25 sec.
In RAC you will have multiple machines each running database instance(memory & database processes) but all instances talking to a single database on a cluster file system (data files where data is stored).
In RAC, Session Replication between nodes occurs so that the data in Instance 1 can be accessed by data in the memory of Instance 2 and so on using private interconnect. Check all networking requirements HERE.
RAC provides HA within datacenter but doesn’t provide failure against entire datacenter. Extended/Stretched RAC is an option for extending RAC across the datacenter. Get more information on stretched cluster HERE.
Disaster Recovery (DataGuard)
RAC license could be costly and doesn’t cover failure against entire datacenter and you still want a Disaster Recovery (DR) solution and that’s where Standby Database (aka Dataguard) comes into the picture.
Standby Database (DataGuard) is a process of setting up two databases which might be geographically distant where one database acts as Primary (open in Read/Write and serving clients) while another as Standby (accepting changes from primary and possibly applying them to stay in sync).
The Primary Database sends a Redo Logs to Standby, that is then applied to standby database (based on type Standby Database). In the Live 60 minutes show, I discussed three different types of Standby Database (Dataguard Configuration) i.e. Physical, Logical and Snapshot.
Note: Failover from Primary Database to Standby Database, can be Manual or Automatic (using Observer process in Fast Start Failover).
DataGuard Vs Active DataGuard
Unlike in DataGuard, you can open the Standby Database in Active DataGuard in Read Only mode for reporting purpose.
HA & DR in Cloud
If you are deploying RAC or DataGuard on Oracle Public Cloud then you must select correct Software Edition & Database Type while creating Database on Oracle Cloud.
This post is part of Q/A series of Module II Oracle Cloud Offerings from Day 2 (on 3rd Feb 2018) DBA to Cloud DBA Live Training asked by trainees. These questions will help you to understand Cloud Services and also if you have any question related to Oracle Cloud or Cloud DBA then you can ask in the comments section.
Q1: First question comes from above slide, Is there any legal document signed between the cloud provider and the customer related to security? Who is responsible for Data Leaks/Data Theft in Cloud, Cloud Vendor like Oracle / AWS or Client? A1: Yes, Legal document signed between client & cloud vendor like Oracle or Amazon, when you register for Cloud Account as well as when you opt for a specific cloud service. This contract/agreement is signed online at the time of Service Registration. Related to Responsibility for Data Theft/Leak, it depends on
All top cloud vendors like Oracle, Microsoft, Amazon, Google, IBM etc take security very seriously and provide options to encrypt data at rest, transit (over network) including Firewalls & Virtual Private Networks (VPNs)
Q2: Is there a doc or link to see which data centre to choose for each country? A2: This is covered in our Activity Guide (For list of Activity Guides we cover in DBA to Cloud DBA training, check http://k21academy.com/cloud05 )
Q3: Can we create more than one FREE Trial account on Oracle Cloud? A3: No, for the same Identity (Email & Phone Number), however, you can create another FREE Trial Account on Oracle Cloud using a different email and phone number.
Next question is from Module I recording on our Membership Portal. For our training, we provide videos in form of lessons, and related lessons are combined in a Module. We encourage attendees to watch these before coming to live interactive session to make the live session more interactive.
This also helps those who want to revisit a particular topic again or wish to learn their own pace or don’t have time to attend the live interactive session.
Q4: I just joined this DBA to Cloud DBA Training Course http://k21academy.com/cloud03. I watched the recorded video of Module I, What is chargeback in one of the videos you mentioned? A4: Chargeback is a mechanism by which you as IT department managing Cloud (or offering Cloud as Service) can charge different departments within your organizations using Cloud Services.
Q5: What is Orchestration? Can you please elaborate? A5: Orchestration in the context of Cloud, lets you schedule & track workflows that execute scripts on a host or invoke web service endpoint from a single location.
Example would be when a Cloud DBA creates a database on Cloud, process will ask set of questions and based on that
Provision a Virtual Machine with selected CPU, Disk, RAM
Install Database Software
Start Virtual Machine & Databases Services
Notifies Users about database creation
For IaaS i.e. Oracle Cloud Infrastructure (OCI) or OCI Classic, there is Orchestration V1 and more simplified V2 and you can see Comparison between V1 & V2 here
In Oracle Cloud Offerings Module of Training, we cover Oracle SaaS, PaaS and IaaS Offerings and few questions were around Performance Management, Application Management & Orchestration
Q6: Do we need to choose orchestration if we want it or it is included in PaaS? A6: Some basic orchestration and one specific to database, i.e. compute for DBCS/DBaaS is already part of PaaS but if you want more advanced Orchestration and for tasks that are not part of DBCS then you can go for Orchestration Cloud Service, more at https://cloud.oracle.com/en_US/orchestration
Q7: Who is responsible to look at Performance Issues in Cloud, Cloud Vendor or Customer? A7: Like security (discussed in Q1), performance depended on Service Model you are using. If this is DBCS/DBaaS or any application on PaaS, the customer is responsible for performance on PaaS or IaaS as Customer manages How much CPU & Memory (including JVM for WebLogic or SGA/PGA for Database) or what type to Disk to provision when provisioning Cloud.
So in PaaS or IaaS, it is the responsibility of a Customer where for SaaS, Cloud Vendor is responsible for performance.
Q8: Management Service like Application Performance Management (APM) or Log Analytics, Does it have a separate license? A8: Yes these are additional services apart from DBCS and you pay for using these additional Management services.
Q9: Can APM, Log Analytics & Infrastructure Management, monitor on-premise servers including performance? A9: Yes this is possible and if you already have OEM 12c/13c on-premise then you connect that with Cloud Service. If you don’t have OEM 12c/13c on-premise then you deploy a lightweight Java Agent and manage/monitor using APM, Log Analytics & Infrastructure Management Cloud Service.
Oracle has rich set of PaaS offerings and on Day 2 we covered Module II i.e. Oracle Cloud Offerings includingJava Cloud Service (JCS) that includes WebLogic Server, Coherence & Oracle Traffic Director (OTD i.e. Software Load Balancer & Web Tier)
Q10: Can you give some example what to host on JCS? A10: JCS will be used for any application running on WebLogic like any J2EE Application. This is mainly for a client who has standalone Java Application or any application that runs on Weblogic and if you wish to move these to Cloud then similar to DBCS/DBaaS to run Database on Cloud, you have JCS to run WebLogic on Cloud.
Q11: Where does E-Business Suite (EBS) R12 or Peoplesoft come, SaaS or PaaS or IaaS? A11: EBS can be deployed on A) IaaS Only or B) IaaS with PaaS (DBCS for Database Tier). More on Deploying EBS (R12) on Cloud on Cloud an Architect’s perspective then check Live at http://k21academy.com/cloudlive04
Q12: How different is IDCS with OAM/OID? A12: IDCS stands for Identity Cloud Service whereas OAM/OID is on-premise SSO/LDAP solution. In IDCS, you manage users, groups, roles, applications and manage Identity on Cloud. More on IDCS is at https://cloud.oracle.com/en_US/identity/features
Q13: If EBS (R12) on-premise is integrated with OAM/OID on-premise. If this EBS in-migrated to Cloud, How do we do the SSO? A13: You can use EBS Cloud Admin Tool http://k21academy.com/ebscloud11 to integrate. We cover EBS and OAM/OID integration in our EBS on Cloud Training for Apps DBA’s at http://k21academy.com/ebscloud05
Oracle is also working on integration with IDCS (not yet certified as of Feb 2018) using CloudGate. Check IDCS OAuth support in white paper here
EBS stands for Oracle E-Business Suite (including Financials, HRMS, SCM, HCM etc) and till recently used to be deployed On-Premise. Same Oracle EBS (R12) can now be deployed on Cloud. Here are three ways in which EBS can be deployed:
On-Premises (Traditional Infrastructure)
Public Cloud(IaaS or IaaS with Paas)
Cloud@Customer(Cloud Machines at customer Site)
If you don’t have the time to look at the 46 mins video but still want to know about the EBS Deployment , then start from 10 minutes.
Why Should EBS Customer Move to Cloud ?
There were some good questions asked in Live Session and one of them was Why should Customer Move to Cloud or Main Benefits specific to EBS:
First and foremost is Time to provision New Environment, it may take 4-6 weeks for On-Premise just for Hardware & O.S., where as on Cloud, you can get it under an hour.
There is only Operating Expense (OpEx) in Cloud and No Capital Expense (CapEx) so after Implementation/ Go-Live , you can recycle additional EBS Environments and Pay Only for what you use.
Pay what you use, Test/Dev environments are not 100% used so why pay for hardware when not in use. On Cloud, you can shutdown environment and don’t pay for Compute, especially during night time or weekends.
For EBS Disaster Recovery side, you keep only database host up and don’t pay for Application Tier(Keep it down and pay only when you failover to DR).
With Cloud tools like EBS Cloud Admin (More at http://k21academy.com/ebscloud11) , you can easily Clone, Add addtitional Nodes, Configure DR/Dataguard, take backups or integrate with other Oracle products like SOA or IDM very easily.
Oracle EBS (R12) on Cloud Options
Oracle EBS has Two Tiers:
1) EBS Application/Middle Tier– The middle tier can be deployed on:
Oracle Compute(IaaS) also known as Oracle Cloud Infrastructure Classic
Linux, Sparc Model 300, OS supported on Oracle Bare metal Cloud now (Oracle Cloud Infrastructure)
2) EBS Database Tier– The Database Tier can be deployed on:
Oracle Compute(IaaS) i.e. OCI or OCI Classic
Database as a Service(PaaS)
Exadata Cloud Service(PaaS)
RAC with DBaaS/ExaCloudService(PaaS)
For EBSDatabase Tier using Database Cloud Service (DBCS), check my 12 Point Checklist to go from Beginner to Expert Cloud DBA, read it here), For review of Day 1, Oracle DBA Training including questions covered in the Session like OMCS, OEM 13c, Scale-Up or RACCheck Here .
Stands for Software as a Service, where almost everything is handled by Cloud Vendor like Oracle, SalesForce or Google (for Gmail) etc. All client need is to buy license and start using Service. Example of SaaS from Oracle includes Fusion Applications, ERP Cloud.
(Note: ERP Cloud is different than E-Business (R12) or Peoplesoft on Cloud – These comes under IaaS & PaaS Category).
Note: There is not much role for DBA’s in Oracle SaaS except export/import of data or creating connections to other Cloud Account or On-Premise Account or Load Users.
Stands for Platform as a Service, where platform like Database or Application Server or Web Server are provided by Cloud Vendor on Cloud with all the tools necessary manage these. Clients (and You as Cloud Admin) still needs to patch or do backup & recovery or Upgrade or Clone specific platforms like Database or Application Server in PaaS .
You however get necessary tool from Cloud Vendor (like DBaaSCLI to patch & Restore, bkup_cli for Backup) so that you as Cloud Admin can do these tasks by click of button or using REST API.
Oracle Database is part of Database Cloud Service (DBCS) and is under PaaS Offering.
Do you then know what is difference between Database as a Service (DBaaS) and Database Cloud Service (DBCS) ?
Note: There is lot of work for DBA’s in Oracle PaaS, for full list of tasks performed by DBA’s in Cloud check at http://k21academy.com/cloud12
(Point 6 is my favourite and if you know this with Hands-On Experience, I think you can earn lot of Money over next few years).
Stands for Infrastructure as a Service, where all you get is like CPU, Memory, Disk and Networking. Clients (and You as Cloud Admin) still needs to install O.S., Install Database and do all the task like On-Premise and without Platform Tools likeDBaaSCLI or bkup_api or DBaaS Monitor or dbcscli etc.
Running and managing database on IaaS is not much different then traditional On-Premise Style (except that you save time in purchasing hardware).
When you run Database on IaaS Service Model, You loose out benefits of running Database in PaaS Service Model (DBCS) like One Click Patch or Automated Backup Configuration, simple Clone using click of a button and lot more.
AWS Aurora RDS vs Oracle Database Cloud Service
AWS stands for Amazon Web Services and Relational Database Service from Amazon is Aurora
There is no doubt that Amazon is leader in IaaS (followed by Microsoft Azure, Oracle is catching up with next Generation Bare Metal Cloud Service now called Oracle Cloud Infrastructure) but if you look at Database Market, Oracle is Leader (No. 1) in Database with 41.6% Market Share (Source: DBEngine).
I am a DBA: Should I go for Amazon AWS or Oracle Cloud
Now to actual question, If you look at all the above points, Oracle being leader in Database and given Oracle’s huge investment in last 2-3 years in Cloud, and your existing experience as Oracle DBA, you can decide right option for you.
Think from the Clients point of view, would they be comfortable running Oracle Database on Oracle Cloud (with all DBCS features & Tools) or Oracle Database on Amazon AWS (IaaS Offering) with very little Cloud Benefits.
If you trust and believe me, Oracle Cloud (Database Cloud Service – DBCS) is much better option for DBAs & Apps DBAs (Once you learn and become Expert in Oracle Cloud for DBA’s then by all means pick AWS IaaS).
You can start learning Oracle Cloud for DBA’s by registering FREE Oracle Cloud Trial (Get 300 USD FREE Credit) – simply click here and I’ll share FREE Guide with you.
What’s your suggestion for DBA’s thinking of Cloud?
What would you do?
The first thing you must do is to get a Trial Account for Oracle Cloud (You get 300 USD FREE Credit that must be used within 30 Days). Even though this is FREE Trial account, you’ll still have to enter Credit/Debit Card Details (Note: Make sure you disable or don’t select Auto Upgrade to Pay as you go after trial period if you don’t want any money to be deducted)
Once you register for Oracle Cloud Trial, you should get an Email Like below from Oracle
Note: There are two type of Oracle Cloud Login, Traditional Cloud Account & Cloud Account with IDCS – More on Oracle Cloud Account Type in future posts.
2. Lab Activity II: Generate SSH Keys
When you create Oracle Database in Cloud as DBCS/DBaaS Offering, you get full access to Linux Virtual Machine on which Database is deployed (Check DBCS Architecture in point 8 of Module I, Oracle DBCS Offerings for 1Z0-160 here )
In order to connect to this Linux VM, you must use SSH Keys (Password less Login) using user opc (Oracle Public Cloud).
Next Activity you must perform is to create SSH Keys (Public & Private) using PuttyGen.
Note: You must keep Private Key Safe and Public Key will be uploaded to Oracle Cloud at time of Database Deployment, In next Lab Private Key will be used at time of connecting to Linux Machine running Database on Oracle Cloud for Oracle Cloud Certification 1Z0-160)
3. Lab Activity III: Create Database Service DBCS (DBaaS)
Once you have created trial Account and generated SSH Keys, We are now ready on exciting bit i.e. Creating you first Oracle Database on Oracle Cloud (DBCS/DBaaS). If you are confused about differences between DBaaS and DBCS or would like to know about various options available for Database creation in Oracle Cloud then check my previous post Module II of 1Z0-160 here
4. Lab Activity IV: Connect to DBCS (DBaaS) Host Using Putty
Once you have the database ready for Cloud, next task you must perform is
Finding Public IP of machine hosting Database
Allow SSH Port 22 from Internet (For security reasons restrict client access from selected machines – We’ll do this in one of the further Lab Activity Guides)
Connect to Database Host from Putty with user opc and private keys created earlier using PutyGen
Note: You can get Public IP on Database Instance Page
Note: To allow SSH port 22, go to Compute Service Console under Network
Three topics in Module III of Oracle Database Cloud Service Certification Exam 1Z0-160, are related to Cloud Dashboard, DBCS Console, Database Instance Page, Compute Console Page. There are few questions in exam related to what you can and can’t do from these Consoles. Make sure you are fully familiar with all these Consoles
6. Lab Activity VI: Manage Users/Roles For Compute & Database
The next three topics in Module III of Oracle DBCS Certification Exam 1Z0-160, are related to Managing Users & Roles. There are two type of Users & Roles
Compute/Cloud Users & Roles (This set of users log in to Oracle Cloud Console or Linux Machine)
Database Users & Roles (This set of users log in to Database created on Cloud)
You must know How to create these different set of Users as there will be few questions on this topic.
7. Lab Activity VII: Patch Database on Cloud
The next topic in Module III of Oracle DBCS Certification Exam 1Z0-160, is related to Patching. You can patch database in cloud using
daascli (Command-line Interface)
DBCS UI to patch Database
Make sure you understand both methods of patching and have done Hands-On Labs related to patching as there are few questions related to Patching in 1Z0-160 Exam
Patch using DBaaSCLI
Patch using DBCS Instance Console
8. Lab Activity VIII: Scale-Up Compute & Storage
Expect some questions related to Scale-Up in Module III of Oracle DBCS Certification Exam 1Z0-160. Note: You can scale-up Storage & Compute (CPU & Memory)
There are lot of questions in Certification Exam 1Z01-60 related to Administration covering Cloud Consoles, Users & Roles for both DBCS & Database, Patching on Cloud, Scale-Up etc so make sure you under these very well
Module IV in Cloud Certification for DBA’s 1Z0-160 is Backup & Recovery of Databases in Cloud. You must know tools like bkup_api or orec option in dbaascli for backup & recovery of Database in Cloud. Expect questions like backup to Local Compute or to Cloud Storage Service including, creating an On-Demand Backup of Database, and Restoring from Backup. If you have not configured Automated backup in Cloud then you can still use traditional RMAN backup as shown in slide from our Oracle Cloud Certification for DBA’s 1z0-160 Training (including Mock Exam Questions)
Module V & VI in Cloud Certification for DBA’s 1Z0-160 is Cloud Security & Configuring Network Access like configuring Network Access, Security Rules, Security Applications, opening Port to access DBaaS Monitor (GUI to Manage Host O.S. & Database Instance) . Expect lot of questions in certification exam 1Z0-160 from this topic including SSH Tunneling etcNote: By default for Security, all connections from Internet are blocked to Cloud Database Machine that you created in Activity Guide II above. You must learn about Opening Ports for SSH, DBaaS Monitor, and EMExpress.
DBaaS Monitor is advanced DBaaS Management to manage DB Storage, Alert Logs, Sessions, Wait Events & Configuring Database Features etc. Make sure you know how to connect to DBaaS Monitor, What Username Password to connect, what you can and can’t do in DBaaS Monitor
Migration (Lift & Shift) is process of migrating an On-Premise 11g/12c Databaseto Oracle Cloud. Depending on source environment, there are multiple options to migrate ranging from DataPump (Export/Import) using Conventional, Transportable, RMAN Transportable, Remote Cloning, Plugging & Un-Plugging Database.
Some of these methods support migrating on-premises 11g to cloud 11g, some support migrating on-premises 12c to cloud 12c, and some methods support migrating and upgrading on-premises 11gR2 to Cloud 12c. Make sure you understand these migration options including which one to use in what scenario.
13. Lab Activity XIII: Using REST API to Manage Storage
Module XIII in Cloud Certification for DBA’s 1Z0-160 is using REST to manage Cloud where REST stands for REpresentational State Transfer and is one of the methods to invoke Web Services. Make sure you understand ORDS (Oracle REST Data Services) and are familiar with REST in DBCS. You should learn how to requesting an Authentication Token, Creating Your First Storage Container in Oracle Cloud, Verifying whether your container has been created or not and lot more related to DBCS
Get All Hands-On Lab (Activity) Guides:
You can get all these Step by Step Activity Guide including Live Interactive Sessions (Theory) when you register for Oracle Cloud Certification for DBA’s 1z0-160 Training ( Seats on this course are limited and we get busy quickly, Join the waitlist for first to know when we re-open this certification training for some limited seats early bird discount)
Here are some of the reasons why our students think we are the best Oracle Cloud Training Institute
Live Instructor-led Online Sessions
FREE un-limited retake for next 3 Years
Training Material with Hands-on Lab Exercises (All above Guide)
Exam 1Z0-160 Practice Questions (50+) , come with your questions too
Recording of Live Interactive Session for Lifetime Access
Dedicated Machines to Practice Lift & Shift (Migration)
Support using Ticketing System & WhatsApp
Help in CV Preparation
100% Money Back Guarantee (If you attend sessions, practice, go through internal exam and don’t clear Oracle 1Z0-160 Certification Exam, We’ll do full REFUND of your Certification FEE).
Have queries? Contact us at email@example.com or if you wish to speak then mail your phone number and country code and a convenient time to speak.
1. Deploying Database on Cloud in Automated Service Level in DBaaS (Database as a Service) involves: You select set of configuration for Oracle Database on Cloud like Compute Shape (CPU & Memory), SSH Keys (for connecting), Database Release (12c or 11g), Database Edition (SE, EE, HP, EP), Database Type (Single Node, RAC, Standby etc), Backup Configuration etc and DBaaS/DBCS will automatically create database (and Linux virtual machine) for you.
What is DBCS & DBaaS ?
2.DBCS stands for Database Cloud Service and generic term for running Database on Oracle Cloud and has three main offerings
Schema as a Service: You get a Schema that you can access using REST Endpoint and backup and restore.
DBaaS: Database as a Service: You get database with complete access including root on Linux
3. When you deploy Database in DBaaS Offering, you get two Service Levels
The Oracle Database Cloud Service – Virtual Image: In this option, you get a dedicated Linux VM with Oracle Database Software Pre-Installed. You must configure Database using DBCA (Database Configuration Assistant) and you get no cloud database tools (like DBaaSCLI or Automated Patching or Backup & Recovery Tools)
The Oracle Database Cloud Service (aka Automated) In this option, you get a dedicated Linux VM and Oracle Database is installed automatically using values provided during Database Deployment. You get cloud database tools ( like DBaaSCLI, bkup_cli, orec for Recovery, Automated Patching, and DBaaS Monitor)
Note: As of Jan 2018, you don’t get an option for Virtual Image but for Cloud Certification 1Z0-160, this is still applicable (Expect 1-2 questions around Service Levels in DBaaS/DBCS)
Options Deploying Database on Cloud
4. For billing, you can pick either Metered (Hourly/Monthly: PAYG) or Unmetered Billing (Monthly with 1/2/3 Years Contract). More on Billing in Oracle Cloud check my previous post here
(Note: Expect few questions around Billing in DBaaS/DBCS)
5. As of Jan 2018, you can create 11gR2, 12c R1 and 12c R2 software release. Note: From Oracle Cloud Certification (1Z0-160) Exam point of view, 12c R2 is not yet certified (In actual 12cR2 is available on Cloud now in Jan 2018)
6. When deploying Oracle Database on Oracle DBCS, you can select one of the four Database Software Editions
Standard Edition (SE)
Enterprise Edition (EP)
Enterprise Edition – High Performance (HP)
Enterprise Edition – Extreme Performance (EP)
Note: More on High Performance (HP) & Extreme Performance (EP) Software Editions in Database Cloud Service in my previous post here
7. Depending on type of Software Edition selected, you can create database of type
Single Instance Instance
Database Cluster with RAC
Single Instance with Dataguard Standby
Database Clustering with RAC and Data Guard Standby
Data Guard Standby for Hybrid DR
Note: Database with RAC & Data Guard Standby for Hybrid DR are not supported on Oracle Cloud Infrastructure (OCI) as of Jan 2018
Note: Expect few questions related to these Deployment Options in Certification Exam 1Z0-160
OCI vs OCI Classic
What’s Oracle Cloud Infrastructure (OCI) or Compute?