Follow K21 Academy - Oracle Trainings Blog on Feedspot

Continue with Google
Continue with Facebook


This post covers the difference between OCI & OCI Classic, one of the most common question asked in our Cloud DBA or EBS (R12) on Cloud or IaaS/OCI training.

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.  

OCI Classic:
  • Oracle Cloud Infrastructure Classic (OCI-C) is IaaS offering to provide Compute & Network (Shared & IP Networks)
  • OCI Classic is based on Nimbula Director (Xen based Hypervisor)
  • 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
OCI Overview

Stay tuned for my next post on OCI Components like Regions, Availability Domain, Compartments, IAM, Virtual Cloud Network, Edge Services etc

Next Task

The post OCI vs OCI Classic: IaaS from Oracle appeared first on Oracle Trainings.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

This post covers Microservices Architecture (MA) introduced in Oracle GoldenGate 12CR3 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.

If you are new to Oracle GoldenGate 12c then suggest you first go through Oracle GoldenGate 12c Overview & Components, Download & Installation.

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

  1. Classic Architecture
  2. Microservices Architecture

Microservices Architecture:

The Microservices Architecture in Oracle GoldenGate is comprised of five main components:

  • Service Manager
  • Administration Server
  • Receiver Server
  • Distribution Server
  • 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.

Download Oracle GoldenGate Microservices from OTN. Install Oracle GoldenGate Microservices

The Microservices Architecture for Oracle GoldenGate 12c ( installation with an Oracle Database is done as below:

  1. Install the Oracle GoldenGate MA.
  2. Set the necessary environment variables.
  3. 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.

Click Close to complete the installation.

Deploy Oracle GoldenGate: Configuration Assistant (OGGCA)

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.

$ export TNS_ADMIN=/u01/app/oracle/product/12.2.0/dbhome_1/network/admin
$ export OGG_HOME=/u01/app/oracle/ogg_ma
$ cd $OGG_HOME/bin
$ ./oggca.sh

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.


The post [Video] Oracle GoldenGate 12c Microservices Architecture MA: Components, Documentation & Installation appeared first on Oracle Trainings.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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

Where is Database 13 to 17?

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, 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)

References: Next Task

The post Oracle Database 18c Documentation & Must Know Key Points appeared first on Oracle Trainings.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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 min 25 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.

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

(Note: Oracle RAC on Amazon AWS is not certified and should you learn Amazon AWS or Oracle Cloud, check at http://k21academy.com/cloud20 )

As shown above, depending on the software edition you select, you get the Database Type.

  • For Dataguard select EP, HP or EP
  • For Active DataGuard or RAC on Cloud select EP (Extreme Performance)

Note: We cover Disaster Recovery (DR) for Oracle E-Business Suite (R12) in detail in Module 11 at http://k21academy.com/ebscloud03 and Step by Step Activity Guide 8 at http://k21academy.com/ebscloud05

Apart from the live interactive session, You get:

  • FREE 3 Years Unlimited Retake & On Job Support
  • FREE Life Time Access to Videos, Activity Guide, Any future Updates
  • Dedicated Machine to Practice EBS (R12) On-Premise to Cloud Migration (Lift & Shift) — Yes it works and check screenshots below
  • Direct interaction with Me, Team of Cloud Experts & 100+ attendees from previous batches


The post Oracle Database & EBS (R12) in Cloud: RAC for High Availability (HA) & DataGuard for Disaster Recovery (DR) appeared first on Oracle Trainings.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

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.

For Q/A of DBA to Cloud DBA Day 1 Training from Module I, refer to http://k21academy.com/cloud22

If you are just starting out in Cloud then I highly recommend you to go through these first

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

  1. Service Model (SaaS, PaaS, IaaS  check more at http://k21academy.com/cloudlive01 )
  2. Deployment Model (Public, Private, Hybrid, Managed to check more at http://k21academy.com/cloudlive02 )
  3. Also on How Leak/Theft happened (If Any)

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 )

You can also get it from https://cloud.oracle.com/data-regions (Green represents what’s available as of Feb 2018 and Orange represents, what’s coming)

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

  1. Provision a Virtual Machine with selected CPU, Disk, RAM
  2. Install Database Software
  3. Start Virtual Machine & Databases Services
  4. 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

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

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

Note: Apart from JCS, you also get JCS SaaS Extension more at  https://cloud.oracle.com/java

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

Note: There is also ERP on Cloud that is a SaaS solution based on Oracle Fusion applications, more at https://cloud.oracle.com/erp-cloud

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  

Note: These are just a few of Q/A in Day2 of DBA to Cloud DBA Training (for Step by Step guides we cover in training visit at http://k21academy.com/cloud05 ).

Stay tuned for next session next week where we’ll cover Oracle Database Cloud Service (DBCS & DBaaS), and How to Create Database on Oracle Cloud.

Did You Start Your Oracle Cloud Journey? 
Get a FREE Copy in your Inbox with Steps to Register for Oracle Cloud and get 300 USD FEE Credit to Practice

The post [Q/A] Oracle Cloud Offerings: DBCS, JCS, IDCS, APM: Performance & Security appeared first on Oracle Trainings.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

This post covers key points from Facebook Live Show I did on recently, related to Oracle E-Business Suite R12 Deployment on Cloud (For Apps DBAs & Architects).

Oracle Cloud Reference Architecture

What you see in diagram above is Oracle’s Reference Cloud Architecture

  • Top is user interaction and interface to On-Premise or Oracle Cloud
  • Right is on On-premise Infrastructure, Database, Middleware or Applications.
  • Left is Three Cloud Service Models covering SaaS, PaaS, IaaS

If you are a Cloud beginner, and have not attended my first Cloud Live show covering SaaS, PaaS and IaaS then check at http://k21academy.com/cloudlive01

Oracle EBS (R12) Deployment Options

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 EBS Database 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 RAC  Check Here .

Security in Cloud ? 

Another good question on Live (If you have any question then you can ask on Live Show at http://k21acadmey.com/cloudlive04 ) was about Security.

You get security at each level being from Data at Rest using Encryption (TDE for Databases), Network Layer (SSL) or you can even configure VPN and Firewalls, Security Rules, IP List etc..

Note: Check Activity Guide 5 in Hands-On Lab You Must perform to go from Beginner to Expert Cloud Apps DBA at http://k21academy.com/ebscloud05


The post Oracle EBS (R12) on Cloud: Architects Perspective: What and Why? appeared first on Oracle Trainings.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

I recently did a Facebook Live on our Facebook Page and one question that came twice and keep coming again in our Private Facebook Group for Cloud is

“I am an Oracle DBA/Apps DBA and “Confused between Oracle Cloud & Amazon AWS” which platform to learn or where should I focus?”

In order to get right answer for you, first you need to understand what offerings these two Cloud Vendors (Oracle & Amazon) have and Three Service Models for Cloud (SaaS, PaaS, IaaS).

Cloud Service Models

If you look at above two diagrams (from our Oracle Cloud Certification Training for DBA’s, there are three service Models in Cloud:

1. SaaS:

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.

2. PaaS: 

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) ?

I covered this as point 2 in Oracle Cloud Certification for DBA’s here: http://k21academy.com/1z016013

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

3. IaaS:

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 like DBaaSCLI 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?

Join discussion in our Private Facebook Group for Cloud (Note: Your Reply can change someone’s Future)

The post Amazon AWS or Oracle Cloud (Confused ?): Right Choice for DBA’s appeared first on Oracle Trainings.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

This post covers Hands-On Guides that you must perform to clear Cloud Certification Exam for DBA’s [1Z0-160] (There are three Levels of Cloud Certification for DBA’s).

1. Lab Activity I: Register for Oracle Cloud

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 AccountCloud 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)

Get Access To Lab Guides I & II

Note: We cover these two above two Labs in our Oracle DBCS Cloud Certification Training Program for DBA’s (Join the waitlist for first to know when we re-open this certification training for some limited seats early bird discount)

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  

Get Access To Lab Guides III & IV

Note: We cover these above two Labs in our Oracle DBCS Cloud Certification Training Program for DBA’s (Join the waitlist for first to know when we re-open this certification training for some limited seats early bird discount for limited students)

5. Lab Activity V: Manage DBCS Dashboard & Console

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)


Get Access To Lab Guides V to VIII

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

Note: We cover these above all these guides in our Step by Step Labs in our Oracle DBCS Cloud Certification Training Program for DBA’s (Join the waitlist for first to know when we re-open this certification training for some limited seats early bird discount for limited students)


9. Lab Activity IX: Backup & Recovery in Cloud

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)


10. Lab Activity X: Cloud Security & Network Access

 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 SSHDBaaS Monitor, and  EMExpress.


11. Lab Activity XI: Manage Storage, Sessions, Wait Events (DBaaS Monitor)

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

12. Lab Activity XII: Lift & Shift (Migration) To Cloud Migration

Migration (Lift & Shift) is process of migrating an On-Premise 11g/12c Database to 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.

Using DataPump Export/Import
Migrating Oracle 11g  To 12c Pluggable Database 


Moving Data To Oracle DB Cloud Using Pluggable DB

Note: In our Oracle Cloud Certification for DBA’s 1z0-160 Training We provide machine with database to migrate to Cloud, our trainees mentioned makes us best Training Providers in Oracle Cloud
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

  1. Live Instructor-led Online Sessions
  2. FREE un-limited retake for next 3 Years
  3. Training Material with Hands-on Lab Exercises (All above Guide)
  4. Exam 1Z0-160 Practice Questions (50+) , come with your questions too
  5. Recording of Live Interactive Session for Lifetime Access
  6. Dedicated Machines to Practice Lift & Shift (Migration)
  7. Support using Ticketing System & WhatsApp
  8. Help in CV Preparation
  9. 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 contact@k21academy.com or if you wish to speak then mail your phone number and country code and a convenient time to speak.


Next Step: Download FREE our Step by Step Guide to Register for Oracle Cloud and start learning Database deployment in Oracle Cloud

Click here to subscribe

The post Oracle Cloud Certification (1Z0-160): Step by Step Activity Guides To Clear Exam appeared first on Oracle Trainings.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

This post covers Module II for Cloud Service Certification 1Z0-160 for DBAs covering Database Cloud Service (DBCS) Deployments.

If you have not yet seen the first module on this Oracle Cloud Certification 1Z0-160 covering Cloud Concepts & Offerings i.e.

  • Service Models (SaaS, PaaS, IaaS)
  • Service Levels in DBCS (DBaaS, Schema Service, Exadata Cloud Service)
  • DBCS Architecture

Click Here to check Module I, if not seen already


Deploying Database ob Cloud

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
  • Exadata Cloud Service: Exadata Database in Cloud

Note: Above Image is from Module I of our Oracle Cloud Certification Training Program 1Z0-160

. 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 DBaaSCLIbkup_cli, orec for Recovery, Automated Patching, and DBaaS Monitor)

: 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?

OCI or Compute is IaaS (CPU & Memory) offering from Oracle formerly Oracle Bare Metal Cloud Service (BMCS).

What’s Oracle Cloud Infrastructure (OCI) Classic or Compute Classic?

Oracle’s original IaaS (other at that time was Bare Metal Cloud Service i.e. Compute – CPU & Memory) is now called as Oracle Cloud Infrastructure Classic (or OCI Classic).

(Join Waitlist Here, for Founding Members Discount and First one to know when we open Cloud Certification Training Program)

Compute Shape & Storage

9. Compute includes CPU & Memory, and when you deploy database on OCI Classic  there is a) General Purpose and b) High Memory

  • General Purpose Compute database in OCI Classic includes OC3 (1 OCPU & 7.5 GB RAM), OC4 (2 OCPU & 15 GB RAM), OC5 (4 OCPU & 30 GB RAM), OC6 (8 OCPU & 60 GB RAM), OC7 (16 OCPU & 120 GB RAM)
  • High Compute database in OCI Classic includes OC1M (1 OCPU & 15 GB RAM), OC2M (2 OCPU & 30 GB RAM), OC3M (4 OCPU & 60 GB RAM), OC4M (8 OCPU & 120 GB RAM), OC5M (16 OCPU & 240 GB RAM)
  • A database in OCI includes VM.Standard1.1 (1 OCPU, 7 GB RAM), VM.Standard1.2 (2 OCPU, 14 GB RAM), VM.Standard1.4 (4 OCPU, 28 GB RAM), VM.Standard1.8 (8 OCPU, 56 GB RAM), VM.Standard1.16 (16 OCPU, 112 GB RAM), VM.Standard1.32 (32 OCPU, 256 GB RAM)

Note: Expect few questions related to Compute Share in Certification Exam 1Z0-160

10. During Database deployment, you choose an amount of usable data storage you want for your Oracle Database

Note: As of Jan 2018, you can create database of size 1200 GB with backup to Cloud & local storage or 2048 GB with Backup to Cloud Storage or No Backups


11. Scale-Up is the process of increasing Compute (CPU & Memory) or Storage after database deployment.

12. In OCI Classic, you can scale disk up to 4.7 TB with backup to Cloud & local storage or 10TB with Backup to Cloud Storage or No Backups

13. In OCI, you can scale disk up to 19 TB with backup to Cloud & local storage or 48TB with Backup to Cloud Storage or No Backups

Note: In Oracle Cloud Certification Exam, you’ll get few questions related to Scale-Up. (Join Waitlist Here, for the First one to know when we open program and Early Bird Discount, only for 72 Hours)


14. At the time of Database Deployment in DBCS, you can configure No Backups or Automatic Backup. If selected Backups then backup destination can be a) Local Storage or B) Both to Cloud & Local Storage

Note: 30 Days worth backups are kept and 7 days on local storage b) Cloud Storage = 30 Days

Note: You’ll get few questions around backup in Cloud Certification 1Z0-160 so more on Backup & Recovery in upcoming posts

Next Task

Stay Tuned for my next post on Managing Databases in Cloud for Oracle Cloud Certification 1Z0-160

The post Creating Database Deployment (DBCS | DBaaS): Oracle Cloud Certification [1Z0-160] appeared first on Oracle Trainings.

Read Full Article
Visit website
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

This post covers FREE video from our OUD Training covering overview of ODS, why four solutions (OUD, OID, OVD, ODSEE), overview, components and use of OUD

ODS/OUD Overview & Components - YouTube

1. Oracle Directory Services (ODS) is collection of Directory Services from Oracle including

  • Oracle Unified Directory (OUD)
  • Oracle Internet Directory (OID)
  • Oracle Virtual Directory (OVD)
  • Oracle Directory Services Enterprise Edition (ODSEE)

2. OUD is used to store Users/Password and Group Information and is used as LDAP. Unlike OID, OUD doesn’t need any Oracle Database to store data.

3. OUD uses Berkeley Java Database to store data in file system.

4. What are OUD Components?

  • Directory Server: LDAP & LDAPS and Stores data in BDB JE
  • Proxy Server: Acts as proxy between clients & Server containing Data
  • Replication Gateway Server: Configure this to replicate data between OUD with ODSEE

Click here to subscribe




Did you find this video on OUD useful?

What more topics you want to see as part of  Tech Tip on Oracle Unified Directory (OUD)?

The post [Video] Oracle Unified Directory (OUD) : Overview & Components appeared first on Oracle Trainings.

Read Full Article
Visit website

Read for later

Articles marked as Favorite are saved for later viewing.
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free year
Free Preview