Skip navigation

By Joel Peréz ACED.gifSkant Gupta

 

This article is brought by en.enmotech.com

Subscribe to our Oracle Cloud Blog: blog.enmotech.com

 

Full Index of Oracle Cloud Articles:

Sir.CloudDBaaSjoelperez

 

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta's LinkedIn: www.linkedin.com/in/skantali/

or Join our LinkedIn group: Oracle Cloud DBaaS

 

Hi readers

 

Here one more article about managing databases in Cloud. Sometimes a frequent question I receive from some readers is: Can I upgrade my Cloud Database in Place ?

Talking this point with experts in this area, the answer is: No.. you can not upgrade your Cloud DB in place.. you have to create a new Cloud database service and move-to & upgrade your DB at the new Cloud Computing node(s). Of course this is an scope out of Autonomous databases which has the capability to self-upgrade in place.

 

When you create your database Cloud service is very explicit that you choose one software version. Up to now it's only available:

  • 11gR2
  • 12cR1
  • 12cR2
  • 18c ( Very soon , starting December 2018 )

 

So.. basically the Cloud service create a compute cloud node with an specific database software version that can not be changed by the user since all this configuration was already pre-created and fixed to use without software changes beyond the patches to apply.

 

Upgrade has been always a big matter for enterprises that does not want to stop the production activity because of an upgrade.. and when they are decided to do it, they want to do it as fastest possible.

Oracle Multitenant architecture offer us a lot of capabilities and modes to upgrade-move-cloning our DBs and PDBs with more versatility than how is done with regular non-CDB.

 

12cR1 was release in 2013,  Oracle Multitenant architecture came with a lot of new functionalities, one of them were the new facilities to upgrade. At the beginning "personally I thought" the upgrade of PDBs database could be done "in hot mode".. something like that.. as the PDB's Clone is done in 12cR2. But the reality is that you have still to stop your database to move-upgrade your PDB even between the higher versions available in this moment.

 

Here  my friend and expert colleague "Mike Dietrich" ( Oracle Corp. Master Product Manager in Database Upgrades and Migrations ) clarify that point in a great article written by him but focused in Cloning. This technique apply exactly same when you are working "On-prem" and "Cloud".

Cloning and moving is not the same but the important thing, you can realize in this article is that at the end you have to carry out an upgrade process when you clone-move your PDB from 12cR1 to 12cR2.

 

So.. the title of this post is: It's possible to upgrade my Cloud DB in Place ?, answer: No.. you have to create a new Cloud database service and move-upgrade your DB with the same methods known up to now, there is not any difference if you are "On-prem" or "Cloud" at the time of moving-upgrade your database to another host/"Cloud Compute Node", basically the software can not be changed of version in traditional Oracle Cloud Database Services.

 

If I have a PDB the upgrade process can be more smooth between 12cR1 to 12cR2 than if I have non-CDB ?

Answer: you can take advantage of the new moving capabilities of PDB between containers but anyway you have to stop your production database because there is an “Upgrade Process” that requires the total control of the database.

 

The article written by Mike Dietrich will help you to understand deeply this point.

 

Cloning a PDB from Oracle 12.1 to Oracle 12.2

clone02.jpg

If you are planning to upgrade to 12.2, these overview advices can be useful for "On-prem" & "Cloud"

 

Overview

 

Oracle's general recommendation for upgrade to a new major version is to do an out-of-place upgrade (moving data and settings to a new ORACLE_HOME and upgrade there, leaving the original intact). In DBCS, the simplest and best way to do this is to keep the original DBCS instance intact and move data and settings to a new instance.

 

 

At the simplest level, the general process would be:

 

    Create the new DBCS instance (which has the software installed)

    Move the database to the new instance

    Upgrade the database

 

Upgrade Methods

 

 

The above steps can be done in several ways. For simplicity sake, all examples given will be for upgrading to 12.2 but the approaches can be used to upgrade to 12.1 as well.

 

 

A. Move 12.1 PDB to the new 12.2 Instance

 

    By far the easiest and fastest method

    Non-CDB 12.1 databases can be converted to Multitenant architecture. We highly recommend this for many reasons, and since the non-CDB architecture is deprecated in 12.2, this is a great time to convert. For information and resources on Multitenant Architeture see the Multitenant topic on Oracle Technology Network.

 

 

B. Use the backup cloud service

 

    This combines steps 1 & 2 by backing up to the Database Backup Cloud Service, and using that backup to create the 12.2 instance

    Straightforward, supported by existing DBCS cloud tooling

    Requires command-line upgrade (step 3) after restore

 

 

C. Copy the database from existing instance into the new 12.2 instance

 

    After creating the 12.2 DBCS instance, drop the default database and copy the data files, control files, etc., from your 11.2.0.4 instance

    Could use data guard to eliminate downtime for the move in this case

    Also requires command-line upgrade

 

 

D. Use data pump expdp/impdp to migrate to 12.2

 

    Use this to implement new features, change partitioning, get a "clean" data dictionary, etc

    This combines steps 2 and 3 into the data pump expdp/impdp, and could go from non-CDB to PDB if desired

 

 

E. Use full transportable expdp/impdp

 

    Similar to data pump expdp/impdp, but likely a lot faster if you have a large amount of data

    Less flexible than data pump expdp/impdp in terms of implementing features

 

Encrypted Tablespaces in 12.2

 

 

All DBCS 12.2 tablespaces are encrypted. If the database you are upgrading is not encrypted, currently the only way to get your data into 12.2 is with data pump ("D" above). A future version of DBCS tooling will allow other methods to be used as well and will be announced in the DBCS What's New documentation page when available.

 

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta's LinkedIn: www.linkedin.com/in/skantali/

or Join our LinkedIn group: Oracle Cloud DBaaS

 

Full Index of Oracle Cloud Articles:

Sir.CloudDBaaSjoelperez

 

Author Bios:

 

Joel Pérez is an Expert DBA ( Oracle ACE Director, Maximum Availability OCM, OCM Cloud Admin. & OCM12c/11g ) with over 17 years of Real World Experience in Oracle Technology, specialised in design and implement solutions of: High Availability, Disaster Recovery, Upgrades, Replication, Cloud and all area related to Oracle Databases. International consultant with duties, conferences & activities in more than 50 countries and countless clients around the world. Habitual and one of leading writers of Technical Oracle articles for: OTN Spanish, Portuguese, English and more. Regular Speaker in worldwide Oracle events  like: OTN LAD (Latin America), OTN MENA (Middle East & Africa), OTN APAC ( Asian Pacific), DTCC China, Oracle Code.. . Joel has always been known for being a pioneer in Oracle technology since the early days of his career being the first Latin American awarded as “OTN Expert” at year 2003 by Oracle Corp., one of the first “Oracle ACE” globally in the Oracle ACE Program at year 2004. He was honoured as one of the first “OCM Database Cloud Administrator” & Maximum Availability OCM in the world. Currently Joel works as Senior Cloud Database Architect in “Yunhe Enmo (Beijing) Technology Co.,Ltd”., company located in Beijing, China En.enmotech.com

 

Skant Gupta is an Oracle Certified Cloud Professional in Oracle Database 12c, an Oracle Certified Expert in Oracle Real Application Clusters (Oracle RAC) in Oracle Database 11g and 12c, and an Oracle Exadata Certified and an Oracle Certified Professional in Oracle Database 10g, 11g, and 12c. He works at Vodafone Technology in the UK and formerly worked as a senior DBA at Etisalat in Dubai. He has six years of experience with various Oracle technologies, focusing mainly on Cloud, database, and high availability solutions, Oracle WebLogic Suite, Oracle Exadata and Oracle GoldenGate. He has presented at several Oracle user groups worldwide, most recently in the US, the United Arab Emirates, and the India. Skant website link: oracle-help.co

By Skant Gupta (OCP Cloud) & Joel Peréz ACED.gif

 

This article is brought by en.enmotech.com

 

Full Index of Oracle Cloud Articles:

Sir.CloudDBaaSjoelperez

 

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta's LinkedIn: www.linkedin.com/in/skantali/

or Join our LinkedIn group: Oracle Cloud DBaaS

 

Hi Readers

 

Finally I’ve successfully passed 1Z0-338, Oracle Exadata Database Machine and Cloud Service 2017 Implementation Essentials. It was almost more than 2 months that I’ve been preparing for this.

The Exam contains 71 questions related to Exadata and Cloud Services. To earn this certification you need to get 63% marks.

 

This was the result of the journey: Oracle Exadata Database Machine and Cloud Service 2017 Certified Implementation Specialist

certi02.jpg

The scope of knowledge that represents this certification is the following: An Oracle Exadata Database Machine and Cloud Service 2017 Certified Implementation Specialist has demonstrated the knowledge required to administer and configure the Exadata system. They can architect Exadata backup and recovery as well as high availability.  They can load data, monitor the system, and provide software maintenance of the Exadata Database Machine. Individuals who earn this certification are able to describe the Exadata Architecture and it’s benefits, configure security policies, set up service requests, and configure Oracle Exadata Database machine in the cloud.

 

In this post you will find:

  • Path to achieve it
  • Study Materials
  • Exam Detail & Score

 

How to Achieve this Certification?

 

Before appearing to this exam you must have vast knowledge on Exadata X-4, X-5 & X-6 and Oracle Cloud.

For following the path to develop expertise in Oracle Database Cloud, read here:

#7 Oracle Cloud (DBaaS): How to become OCP & OCM Cloud!!

 

Although it is not necessary to have knowledge on Oracle RAC but as per my point of view you must hands-on Oracle ASM & RAC before attending.

 

List of exam topics

 

  • Oracle Database Software
  • Oracle Exadata Architecture
  • Administration and Configuration
  • Backup and Recovery
  • High Availability
  • Monitoring
  • Software Maintenance
  • Bulk Loading and Migration
  • Resource Management
  • Support
  • Exadata in the Cloud

 

For more detail, you can follow the below link.

https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:1Z0-338

 

How to prepare for exam?

There are 3 ways to study for this exam related to cloud part.

 

  1. Oracle Exadata Cloud Channel : http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=904&get_params=cloudId:384,channelId:24555
  2. Official Information & Documentation: https://docs.oracle.com/en/cloud/paas/exadata-cloud/csexa/index.html
  3. Oracle Learning Subscription

 

To study Exadata for this exam, We recommend take the below course from Oracle University:

 

Exadata Database Machine: 12c Administration Workshop Ed 2

https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=609&get_params=dc:D92887,clang:EN

 

For practicing on Exadata Cloud services, you need to buy services from Oracle Corporation because there is NO free trail available for Oracle Exadata Cloud.

 

For pricing information, please follow the below link

https://cloud.oracle.com/en_US/database/exadata/pricing

 

How to register the exam?

 

If you want to enroll exam, please click on below link.

Exam Number: 1Z0-338

Exam Title: Oracle Exadata Database Machine and Cloud Service 2017 Implementation Essentials

 

https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=654&get_params=p_id:482

 

Below are the Exam Details related to score.

 

Special Thanks

Joel Perez is an Oracle OCM and ACED who gave an opportunity to write him and motivating me to learn new things.  I’m very thankful to him as this was the kick off for my studies.

 

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta's LinkedIn: www.linkedin.com/in/skantali/

or Join our LinkedIn group: Oracle Cloud DBaaS

 

Full Index of Oracle Cloud Articles:

Sir.CloudDBaaSjoelperez

 

Author Bios:

 

Joel Pérez is an Expert DBA ( Oracle ACE Director, Maximum Availability OCM, OCM Cloud Admin. & OCM12c/11g ) with over 17 years of Real World Experience in Oracle Technology, specialised in design and implement solutions of: High Availability, Disaster Recovery, Upgrades, Replication, Cloud and all area related to Oracle Databases. International consultant with duties, conferences & activities in more than 50 countries and countless clients around the world. Habitual and one of leading writers of Technical Oracle articles for: OTN Spanish, Portuguese, English and more. Regular Speaker in worldwide Oracle events  like: OTN LAD (Latin America), OTN MENA (Middle East & Africa), OTN APAC ( Asian Pacific), DTCC China, Oracle Code.. . Joel has always been known for being a pioneer in Oracle technology since the early days of his career being the first Latin American awarded as “OTN Expert” at year 2003 by Oracle Corp., one of the first “Oracle ACE” globally in the Oracle ACE Program at year 2004. He was honoured as one of the first “OCM Database Cloud Administrator” & Maximum Availability OCM in the world. Currently Joel works as Senior Cloud Database Architect in “Yunhe Enmo (Beijing) Technology Co.,Ltd”., company located in Beijing, China En.enmotech.com

 

Skant Gupta is an Oracle Certified Cloud Professional in Oracle Database 12c, an Oracle Certified Expert in Oracle Real Application Clusters (Oracle RAC) in Oracle Database 11g and 12c, and an Oracle Exadata Certified and an Oracle Certified Professional in Oracle Database 10g, 11g, and 12c. He works at Vodafone Technology in the UK and formerly worked as a senior DBA at Etisalat in Dubai. He has six years of experience with various Oracle technologies, focusing mainly on Cloud, database, and high availability solutions, Oracle WebLogic Suite, Oracle Exadata and Oracle GoldenGate. He has presented at several Oracle user groups worldwide, most recently in the US, the United Arab Emirates, and the India. Skant website link: oracle-help.co

By Joel Peréz ACED.gifSkant Gupta

 

This article is brought by en.enmotech.com

 

Full Index of Oracle Cloud Articles:

Sir.CloudDBaaSjoelperez

 

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta's LinkedIn: www.linkedin.com/in/skantali/

or Join our LinkedIn group: Oracle Cloud DBaaS

 

Loading Data into Autonomous Data Warehouse Cloud Database

 

Data Loading Options

  • Data loading via SQL*Net
    • Suitable for small volumes of data
      • SQL*Loader from local filesystem
      • ETL scripts that use DML to insert/update data
  • Data loading from Oracle Object Storage
    • Preferred technique for large volumes of data
      • Additionally enables data-sharing with other cloud services
  • Stage data in Oracle Object Storage, then load into the database using new PL/SQL APIs

 

Loading Data from Object Stores

  • Source data from files on object stores for data loading
    • Oracle Object Store or AWS S3
    • Any supported Oracle-loader file format
    • Roadmap: any Hadoop file format

lou011.jpg

 

New Cloud API to Access Object Stores, DBMS_CLOUD

  • New PL/SQL package for accessing files in object stores
  • No need to manually define external tables for loading files
    • Makes it easier to specify the format of the source data

lou022.jpg

 

Loading Data from the Oracle Object Store

  • Define your credentials for the object store
    • Oracle Cloud Infrastructure Object Store username and Swift password required
  • Credential stored in the database schema once and used for accessing the object store for all loads

lou033.jpg

 

Loading Data from the Oracle Object Store

  • Load data directly into the target table without any intermediate steps
  • Data format in the source file easily specified as JSON

lou044.jpg

 

Troubleshooting Loads

  • Load operations logged for troubleshooting and historical load tracking
    • New table user/dba_load_operations
  • Log and bad files accessible as tables

lou055.jpg

 

As an additional resource you can listen here an interesting Podcast about this topic

Oracle Cloud Podcast Series: Oracle Autonomous Data Warehouse Cloud

http://streaming.oracle.com/ebn/podcasts/media/30324001_Autonomous-Data-Warehouse_Sep_2017.mp3

Oracle Cloud Podcast Series Featuring Oracle's VP of Product Management Discussing the new Oracle Autonomous Data Warehouse Cloud.

 

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta's LinkedIn: www.linkedin.com/in/skantali/

or Join our LinkedIn group: Oracle Cloud DBaaS

 

Full Index of Oracle Cloud Articles:

Sir.CloudDBaaSjoelperez

 

Author Bios:

 

Joel Pérez is an Expert DBA ( Oracle ACE Director, Maximum Availability OCM, OCM Cloud Admin. & OCM12c/11g ) with over 17 years of Real World Experience in Oracle Technology, specialised in design and implement solutions of: High Availability, Disaster Recovery, Upgrades, Replication, Cloud and all area related to Oracle Databases. International consultant with duties, conferences & activities in more than 50 countries and countless clients around the world. Habitual and one of leading writers of Technical Oracle articles for: OTN Spanish, Portuguese, English and more. Regular Speaker in worldwide Oracle events  like: OTN LAD (Latin America), OTN MENA (Middle East & Africa), OTN APAC ( Asian Pacific), DTCC China, Oracle Code.. . Joel has always been known for being a pioneer in Oracle technology since the early days of his career being the first Latin American awarded as “OTN Expert” at year 2003 by Oracle Corp., one of the first “Oracle ACE” globally in the Oracle ACE Program at year 2004. He was honoured as one of the first “OCM Database Cloud Administrator” & Maximum Availability OCM in the world. Currently Joel works as Senior Cloud Database Architect in “Yunhe Enmo (Beijing) Technology Co.,Ltd”., company located in Beijing, China En.enmotech.com

 

Skant Gupta is an Oracle Certified Cloud Professional in Oracle Database 12c, an Oracle Certified Expert in Oracle Real Application Clusters (Oracle RAC) in Oracle Database 11g and 12c, and an Oracle Exadata Certified and an Oracle Certified Professional in Oracle Database 10g, 11g, and 12c. He works at Vodafone Technology in the UK and formerly worked as a senior DBA at Etisalat in Dubai. He has six years of experience with various Oracle technologies, focusing mainly on Cloud, database, and high availability solutions, Oracle WebLogic Suite, Oracle Exadata and Oracle GoldenGate. He has presented at several Oracle user groups worldwide, most recently in the US, the United Arab Emirates, and the India. Skant website link: oracle-help.co

By Joel Peréz ACED.gifSkant Gupta

 

This article is brought by en.enmotech.com

Subscribe to our Oracle Cloud Blog: blog.enmotech.com

 

Full Index of Oracle Cloud Articles:

Sir.CloudDBaaSjoelperez

 

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta's LinkedIn: www.linkedin.com/in/skantali/

or Join our LinkedIn group: Oracle Cloud DBaaS

19c02.jpg

This is a very hot and interesting subject. Who better to say the "Famous Last Words" about this topic, my friend and expert colleague "Mike Dietrich" ( Oracle Corp. Master Product Manager in Database Upgrades and Migrations )

 

This was the literal conclusion of Mike:

"Please don’t stay on Oracle 11.2.0.4 until the end of Free Extended Support happens. 13 months sound comfortable now. But time flies. You should move forward now. Especially those who have still Oracle 11.2.0.3 databases (or even older releases) in use should move now. Oracle 12.2.0.1 should be your choice."

Mike Dietrich

 

So.. do not get enough with the conclusion, read the complete article here:

https://mikedietrichde.com/2017/11/20/wait-oracle-19/

 

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta's LinkedIn: www.linkedin.com/in/skantali/

or Join our LinkedIn group: Oracle Cloud DBaaS

 

Full Index of Oracle Cloud Articles:

Sir.CloudDBaaSjoelperez

 

Author Bios:

 

Joel Pérez is an Expert DBA ( Oracle ACE Director, Maximum Availability OCM, OCM Cloud Admin. & OCM12c/11g ) with over 17 years of Real World Experience in Oracle Technology, specialised in design and implement solutions of: High Availability, Disaster Recovery, Upgrades, Replication, Cloud and all area related to Oracle Databases. International consultant with duties, conferences & activities in more than 50 countries and countless clients around the world. Habitual and one of leading writers of Technical Oracle articles for: OTN Spanish, Portuguese, English and more. Regular Speaker in worldwide Oracle events  like: OTN LAD (Latin America), OTN MENA (Middle East & Africa), OTN APAC ( Asian Pacific), DTCC China, Oracle Code.. . Joel has always been known for being a pioneer in Oracle technology since the early days of his career being the first Latin American awarded as “OTN Expert” at year 2003 by Oracle Corp., one of the first “Oracle ACE” globally in the Oracle ACE Program at year 2004. He was honoured as one of the first “OCM Database Cloud Administrator” & Maximum Availability OCM in the world. Currently Joel works as Senior Cloud Database Architect in “Yunhe Enmo (Beijing) Technology Co.,Ltd”., company located in Beijing, China En.enmotech.com

 

Skant Gupta is an Oracle Certified Cloud Professional in Oracle Database 12c, an Oracle Certified Expert in Oracle Real Application Clusters (Oracle RAC) in Oracle Database 11g and 12c, and an Oracle Exadata Certified and an Oracle Certified Professional in Oracle Database 10g, 11g, and 12c. He works at Vodafone Technology in the UK and formerly worked as a senior DBA at Etisalat in Dubai. He has six years of experience with various Oracle technologies, focusing mainly on Cloud, database, and high availability solutions, Oracle WebLogic Suite, Oracle Exadata and Oracle GoldenGate. He has presented at several Oracle user groups worldwide, most recently in the US, the United Arab Emirates, and the India. Skant website link: oracle-help.co

By Joel Peréz ACED.gifSkant Gupta

 

This article is brought by en.enmotech.com

Subscribe to our Oracle Cloud Blog: blog.enmotech.com

 

Full Index of Oracle Cloud Articles:

Sir.CloudDBaaSjoelperez

 

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta's LinkedIn: www.linkedin.com/in/skantali/

or Join our LinkedIn group: Oracle Cloud DBaaS

 

us011.jpg

 

Oracle Autonomous Data Warehouse Cloud is a kind a new service that will solve many typical difficulties in the past, the main conception of this kind of special service is the Fully Tuned

  • "Load and Go"
  • Define tables, load data, run queries
    • No tuning
    • No special database expertise required
  • Good performance out of the box

 

If you want to know how this service will perform all this.. keep reading the rest of this article..

 

So.. at the last OOW17 the word "Autonomous" was the most sounded in the enviroment, people very interested in these new kind of services more close to those futuristics things that are happening on the 20th Century. Personally, when I heard all related to "Load and go..", no tuning.. no expertise.. amazing performance without doing anything.. the first question that came to my mind was.. "How they will do that.. ?", well, let's read a bit about it..

 

Firstable, Let's define the main characteristics of "Autonomous Data Warehouse Cloud"

  • Easy
    • Fully-managed, pre-configured and optimized for DW workloads
    • Simply load data and run
      • No need to define indexes, create partitions, etc.
  • Fast
    • Based on Exadata technology
  • Elastic
    • Instant scaling of compute or storage with no downtime

 

Fast -> "Based on Exadata technology", this is one of the key point that is behind of all this super-power service.. "running on Exadata", it's pretty well known the extreme processing power that has Exadata, so.. things can run extreme fast even when they are not optimized, of course this will not be the case of "Autonomous Data Warehouse Cloud" but as we are talking about a kind Artificial Intelligence behind of all this, at the beginning of the workload, the resolution of things they will not be still optimized, basically because something must learn about the typical use of this database and that something is the "Machine Learning".

So, the Machine Learning must and will LEARN from the typical and common activities related to that database to generate POSSIBLY internal ( objects, components, structures, etc.. ) this is a big and deep point of conversation.. according to what people was guessing, the autonomous database service could create or not some objects to make the processing faster..

I had a big conversation about that point with Mr. Andrew Holdsworth (“Oracle Real World Performance Vice President” ) and he told me something simple with a great value.. He mentioned.. “I’m not sure if in autonomous database will be created objects like “indexes”.. etc.. possibly “yes..” possibly “not”, this service is still getting shape.. and it will get a real shape with the real use of customers, up to now we are not thinking to create indexes because when you create an index, something can get better and at the same time something can get worst.. so.. create indexes or some other structures open the door of a huge variation of results and that’s not what we want.. “

He mentioned as well “While you are more standard.. more predictable you are..” so.. if we do not create indexes, we can have more standard results and a higher scalability to keep them over the time. I will cover all this in some articles later..

 

Now, We will come back to talk about Machine Learning. When a database start to run in "Autonomous Data Warehouse Cloud", the Machine Learning does not have too much information about how the data will be accessed.. so.. once the workloads.. queries.. and everything start to go.. the Machine Learning will start to collect information and take internal actions to make these access ways more optimal, in "Autonomous Data Warehouse Cloud" while you use more your database will be more optimized..

 

Since, we mentioned "Machine Learning", let's dedicate some lines to understand in a general way, what is "Machine Learning"

 

Machine Learning in the Cloud

On top of these proven high availability and scalability technologies, Oracle Autonomous Database Cloud integrates a set of next-generation monitoring, management, and analytics capabilities that leverage machine learning and artificial intelligence techniques to automate performance tuning, prevent application outages, and harden security across the entire application and infrastructure portfolio.

The first such service scheduled to be available will be Oracle Autonomous Data Warehouse Cloud, followed by an autonomous OLTP and mixed workload cloud and an autonomous NoSQL cloud after that. Oracle Autonomous Data Warehouse Cloud leverages years of investment in self-tuning technologies like Oracle Exadata storage indexes and flash cache, powerful query optimization, automatic memory management, and automatic storage management to provide a completely self-tuning database.

No traditional performance tuning by administrators and developers is required. With Oracle Autonomous Data Warehouse Cloud, Mendelsohn said, "You just define tables, load data, and run queries; the database is completely self-tuning." The service is so efficient that at Oracle Openworld CTO Ellison discussed offering a guarantee that customers could move their analytic databases from Amazon's cloud and run them at half the cost on Oracle Autonomous Database Cloud.

 

The foundations of Machine Learning are not new theories.. Machine learning works based on analysis techniques developed and published even starting the past century, many things around us works with Machine Learning (ML), if you want to read about it, go here:

https://blogs.oracle.com/machine-learning-explained

 

If you want to go knowing a bit more about Machine Learning, you can watch here:

First Look Advanced Analytics and Machine Learning in the Oracle Database Environment

https://www.youtube.com/watch?v=kK2krDjO-fQ

 

Machine Learning with Oracle

https://www.youtube.com/watch?v=91X73YYSA30

 

Let’s explore some of the web interfaces we will find working with “Autonomous Database”

 

Fully-managed

Oracle automates end-to-end management of the data warehouse

  • Provisioning new databases
  • Growing/shrinking storage and/or compute
  • Patching and upgrades
  • Backup and recovery

au011.jpg

Full lifecycle managed using the service console

  • Alternatively, can be managed via command-line interface or REST API

 

Fully Tuned

  • "Load and Go"
  • Define tables, load data, run queries
    • No tuning
    • No special database expertise required
  • Good performance out of the box

au022.jpg

Query using any business analytics tool or cloud service

  • Built-in SQL worksheet and notebook also included

 

Fully-elastic

Size the DW to the exact compute and storage required

  • Not constrained by fixed building blocks, no predefined shapes

Scale the DW on demand

  • Independently scale compute or storage
  • Resizing occurs instantly, fully online

Shut off idle compute to save money

  • Restart instantly

 

Full Support of DW Ecosystem

  • Autonomous Data Warehouse Cloud supports :
    • Existing tools, running on-premises or in the cloud
      • Third-party BI tools
      • Third-party data-integration tools
      • Oracle BI and data-integration tools: BIEE, ODI, etc
    • Oracle cloud services: Analytics Cloud Service, Golden Gate Cloud Service, Integration Cloud Service, and others
    • Connectivity via SQL*Net, JDBC, ODBC

 

At this following image we can see the integration and interaction of "Autonomous Datawarehouse Cloud" with:

  • Developer Tools
  • Data Integration Services
  • Business Intelligent Services and more

au033.jpg

 

Getting Started with Autonomous Data Warehouse Cloud

Provisioning a database

 

Provisioning requires only 5 simple questions:

  • Database name?
  • Data center?
  • Number of CPUs?
  • Storage capacity?
  • Admin user password?

New service created in <30 seconds (regardless of size)

  • and Ready to connect

 

The interface is very alike to when you are creating a regular Cloud Database with the options already known. The last 3 fields are corresponding to the objects from where we can start to load information for our Data Warehouse

au044.jpg

 

Demo

Provisioning a database

 

Being at the section of “Autonomous Data Warehouse Cloud”, We proceed to create a “Service”

au055.jpg

 

We fill the fields of what We talked before

au066.jpg

 

In this opportunity we have filled just the mandatory ones and press "Next"

au077.jpg

 

We realised the summary of the options chosen and we press “Create”

au088.jpg

 

Now We can see our "salesdb" Service already created.

au099.jpg

 

Now that the Service is already created, Let’s read an article about how to load data in Autonomous Database for Data Warehouse

Oracle 18c: How to load data in Oracle Autonomous Data Warehouse Cloud..

 

As an additional resource you can listen here an interesting Podcast about this topic

Oracle Cloud Podcast Series: Oracle Autonomous Data Warehouse Cloud

http://streaming.oracle.com/ebn/podcasts/media/30324001_Autonomous-Data-Warehouse_Sep_2017.mp3

Oracle Cloud Podcast Series Featuring Oracle's VP of Product Management Discussing the new Oracle Autonomous Data Warehouse Cloud.

 

If you want to be updated with all our articles send us the Invitation or Follow us:

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Skant Gupta's LinkedIn: www.linkedin.com/in/skantali/

or Join our LinkedIn group: Oracle Cloud DBaaS

 

Full Index of Oracle Cloud Articles:

Sir.CloudDBaaSjoelperez

 

Author Bios:

 

Joel Pérez is an Expert DBA ( Oracle ACE Director, Maximum Availability OCM, OCM Cloud Admin. & OCM12c/11g ) with over 17 years of Real World Experience in Oracle Technology, specialised in design and implement solutions of: High Availability, Disaster Recovery, Upgrades, Replication, Cloud and all area related to Oracle Databases. International consultant with duties, conferences & activities in more than 50 countries and countless clients around the world. Habitual and one of leading writers of Technical Oracle articles for: OTN Spanish, Portuguese, English and more. Regular Speaker in worldwide Oracle events  like: OTN LAD (Latin America), OTN MENA (Middle East & Africa), OTN APAC ( Asian Pacific), DTCC China, Oracle Code.. . Joel has always been known for being a pioneer in Oracle technology since the early days of his career being the first Latin American awarded as “OTN Expert” at year 2003 by Oracle Corp., one of the first “Oracle ACE” globally in the Oracle ACE Program at year 2004. He was honoured as one of the first “OCM Database Cloud Administrator” & Maximum Availability OCM in the world. Currently Joel works as Senior Cloud Database Architect in “Yunhe Enmo (Beijing) Technology Co.,Ltd”., company located in Beijing, China En.enmotech.com

 

Skant Gupta is an Oracle Certified Cloud Professional in Oracle Database 12c, an Oracle Certified Expert in Oracle Real Application Clusters (Oracle RAC) in Oracle Database 11g and 12c, and an Oracle Exadata Certified and an Oracle Certified Professional in Oracle Database 10g, 11g, and 12c. He works at Vodafone Technology in the UK and formerly worked as a senior DBA at Etisalat in Dubai. He has six years of experience with various Oracle technologies, focusing mainly on Cloud, database, and high availability solutions, Oracle WebLogic Suite, Oracle Exadata and Oracle GoldenGate. He has presented at several Oracle user groups worldwide, most recently in the US, the United Arab Emirates, and the India. Skant website link: oracle-help.co

By Joel Peréz ACED.gifSkant Gupta

 

Hi Readers

 

Due to the success of this article, it was moved to our company blog

Click here to read, Thank you very much:

Oracle 18c: Data Warehousing New Features.. What’s NEWS.. – Enmotech Blog

 

Happy Reading!

 

Author Bios:

 

Joel Pérez is an Expert DBA ( Oracle ACE Director, Maximum Availability OCM, OCM Cloud Admin. & OCM12c/11g ) with over 17 years of Real World Experience in Oracle Technology, specialised in design and implement solutions of: High Availability, Disaster Recovery, Upgrades, Replication, Cloud and all area related to Oracle Databases. International consultant with duties, conferences & activities in more than 50 countries and countless clients around the world. Habitual and one of leading writers of Technical Oracle articles for: OTN Spanish, Portuguese, English and more. Regular Speaker in worldwide Oracle events  like: OTN LAD (Latin America), OTN MENA (Middle East & Africa), OTN APAC ( Asian Pacific), DTCC China, Oracle Code.. . Joel has always been known for being a pioneer in Oracle technology since the early days of his career being the first Latin American awarded as “OTN Expert” at year 2003 by Oracle Corp., one of the first “Oracle ACE” globally in the Oracle ACE Program at year 2004. He was honoured as one of the first “OCM Database Cloud Administrator” & Maximum Availability OCM in the world. Currently Joel works as Senior Cloud Database Architect in “Yunhe Enmo (Beijing) Technology Co.,Ltd”., company located in Beijing, China En.enmotech.com

 

Skant Gupta is an Oracle Certified Cloud Professional in Oracle Database 12c, an Oracle Certified Expert in Oracle Real Application Clusters (Oracle RAC) in Oracle Database 11g and 12c, and an Oracle Exadata Certified and an Oracle Certified Professional in Oracle Database 10g, 11g, and 12c. He works at Vodafone Technology in the UK and formerly worked as a senior DBA at Etisalat in Dubai. He has six years of experience with various Oracle technologies, focusing mainly on Cloud, database, and high availability solutions, Oracle WebLogic Suite, Oracle Exadata and Oracle GoldenGate. He has presented at several Oracle user groups worldwide, most recently in the US, the United Arab Emirates, and the India. Skant website link: oracle-help.co