Skip navigation

Hi Readers

 

The changing role of Oracle DBAs has been a very hot topic from the OOW17. Based on Larry Ellison Speech that humans will not be required for keeping running the databases, many people started to worry about it. The reality is very simple.. Autonomous Database Service will not be the regular mechanism of regular databases that could administer in "On-prem" enviroments.. etc.

 

I talk very deep about that subject in this article, check it:

Oracle 18c: “Oracle 18c and its impact on DBAs” – Enmotech Blog

 

Penny Avril, vice president of product management has answer some interesting questions related to topic of DBA Changing Role.

Questions such as:

 

  • Do DBAs have specific concerns with the growing acceptance of cloud in the enterprise?
  • Are their jobs becoming easier or more difficult? How so?
  • What is changing in terms of their responsibilities?
  • What does this mean about the DBA role?
  • What should DBAs do to prepare for the new cloud reality?
  • In what ways does cloud put DBAs in a better position than they were before?

 

Questions like these and more are answered by Penny Avril, read and enjoy it!!

The Changing Role of the DBA: Q&A with Oracle's Penny Avril - Database Trends and Applications

 

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/

Join our LinkedIn group: Oracle Cloud DBaaS

or Subscribe to our Enmotech Blog!

 

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

 

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

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

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

By Joel Peréz ACED.gifSkant Gupta

This article is brought by en.enmotech.com

new0345.jpg

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

 

Before starting, if you want to read about how to build an Oracle Dataguard Configuration in Cloud, you can read here:

#1 Oracle Cloud (DBaaS): Oracle Data Guard in Database Cloud Service ( DBCS )

#2 Oracle Cloud (DBaaS): Switchover, Failover & Reinstate Operations on Oracle Data Guard using DBCS Console

#3 Oracle Cloud (DBaaS): Reinstating a Failed Primary Database using dbaascli utility ( Oracle Data Guard on Cloud )

#4 Oracle Cloud (DBaaS): Using dbaascli Utility for Switchover & Failover Operations on Oracle Data Guard

 

Now, Let's start to read..

 

Oracle Data Guard is an Oracle solution that seems will improve in a endless way. Every Oracle Release we have new features that perhaps we never expected to have.

Oracle 18c is not the exception, we have amazing new features, So.. Let's see..

 

New Broker VALIDATE commands

Personally, at the time to check or correct Oracle Data Guard configurations, one of the most common problems is the network configuration. Sometimes we are building RAC-RAC configurations with many servers.. many IPs.. etc.. and it's natural we can miss a name.. and IP.. etc.. at the end we can have some problems when this configuration is working and we have to start the tedious job to check every single detail.. ( Network Configuration.. Parameters.. etc.. ) to find where it's the problem.. With these 3 following commands we will be able to save a lot of time when we face that kind of difficulties..

 

VALIDATE DATABASE SPFILE

  • Validate parameters settings between the Primary and a Standby database.

VALIDATE NETWORK CONFIGURATION

  • Validate the network setup between all databases in the configuration

VALIDATE STATIC CONNECT IDENTIFIER

  • Verifies the static connect identifier setup in Single Instance databases the do not have Oracle Restart.

 

Multi-Instance Redo Apply

- Multi-Instance Redo Apply allows all standby nodes to participate in recovery

- In-memory DB (IMC) on Active Data Guard allows:

  • Creation of IMC tables and columns for analytics on Active Data Guard
  • Population with different data than production database
  • Offloading even more to your standby!

- IMC now works with Multi-Instance Redo Apply!

- Multi-Instance Redo apply also works with BCT

* Available only on Exadata and Oracle Cloud Offerings

 

18c: RMAN and Data Guard Enhancements

Active Data Guard Sync

 

  • New RECOVER STANDBY DATABASE FROM SERVICE
  • One command to refresh the standby database
  • Refreshes controlfile, datafile, restores newly added datafiles
  • Start RMAN and connect as target to the physical standby database.
  • Roll forward the physical standby database using the RECOVER STANDBY DATABASE command with the FROM SERVICE clause

 

RECOVER STANDBY DATABASE FROM SERVICE primary_db;

 

Creating GTTs on Active Data Guard

- Creating GTTs today will fail when executed on Active Data Guard

- In Oracle Database 18c CREATE GLOBAL TEMPORARY TABLE on an Active Data Guard standby will:

  • Create the GTT on the Primary
  • Wait for the GTT to be replicated and applied to the Active Data Guard standby
  • Return control to the user

 

Transient tables useful for reporting applications

 

Global temporary tables

Persistent, shared (global) table definition

Temporary, private (session-based) data content

  • Data physically exists for a transaction or session
  • Session-private statistics

Private temporary tables (18c)Temporary, private (session-based) table definition

  • Private table name and shape

Temporary, private (session-based) data content

  • Session or transaction duration

 

Executing DML on Active Data Guard

- DML Re-direction automatically performed from Active Data Guard standby to the Primary without compromising ACID

  • Standby ADG session waits for updates to show up on ADG via redo apply
  • DML data re-directed by an ADG session is only visible to that session before commit
  • DML data re-directed is visible to all sessions after ADG session commits
  • Enabled by setting parameter _enable_proxy_adg_redirect=TRUE and appropriate connectivity parameters
  • Respects ACID properties of a database for ADG session
  • Targeted for “Read Mostly Occasional Updates” applications

 

Keep Buffer Cache at Role Change

How often we did not dream for having a switchover without losing some transactions because of that..

Well, part of that dream "come true"..

- The database buffer cache state will be maintained on an ADG standby during a role change

ima2034.jpg

- Automatic, nothing to set up.

  • Services need to be configured correctly

 

Control login attempts

- The ADG_ACCOUNT_INFO_TRACKING parameter extends the control of user account security information and reaction.

  • ‘LOCAL’ (default value) continues to enforce the existing behavior
    • Maintains local copy of users account information in the Standby's in-memory view.
      • Login failures are only tracked locally on a per database basis and login denied when the failure maximum is reached.

 

- ‘GLOBAL’ triggers the new secure behavior

    • Maintains a single global copy of users account info across all Data Guard databases
      • Login failures across all databases in the Data Guard configuration count towards the maximum count and logins anywhere will be denied when the count is reached.

 

Data Guard and No Force Logging

How often you have been in the situation to repair/reinstate an Standby Database because a load was done in "No Logging mode".

It was really a hard situation for many companies to know that some specific loads could be done very efficient and fast in "No Logging mode" but sometimes there was not another option if we wanted to preserve the health state of our standby databases. Now, we have a new feature to make more versatile some specific loads in "No Logging mode"

 

 

  • Extended to provide better support in an Active Data Guard environment without significantly increasing the amount of redo generated.
  • Two new modes are added as alternatives to the existing nologging mode
    • Standby Nologging for Load Performance
      • Ensures that standbys will receive the nonlogged data changes with the minimum impact to the speed of loading at the primary
        • The standby can transiently have nonlogged blocks. These nonlogged blocks will be automatically resolved by managed standby recovery.
    • Standby Nologging for Data availability
      • Ensures all standbys have the data when the primary load commits but at the cost of throttling the speed of loading data at the primary
      • The standbys will never have any nonlogged blocks.

 

In Oracle Release 12.1 & 12.2 there a lot of new features that perhaps you have not experimented up to now. Here we have a list of all them so that you can differentiate to what release belongs the new features you will use.

 

RMAN

Oracle 18c: RMAN New Features.. What’s NEWS..

 

Review - Data Guard 12.1 New Features Summary

Data Guard

  • SYSDG Role for Data Guard specific operations
  • Multitenant Database Standbys
  • Default Real Time Apply
  • Transparent Online Data file movement
  • Single SQL*Plus Switchover command
  • No Primary instance shutdown for switchover
  • FastSync (SYNC NOAFFIRM)
  • Enhanced Extended Datatype Support for upgrades
  • Logical Standby support for additional data types
    • XMLType data for all storage models, Oracle Spatial, Oracle Multimedia, Oracle Text, Objects and Collections (including VARRAYs and nested collections), Database File System (DBFS), XDB, Oracle SecureFiles (deduplication), and User-defined types.
  • DBMS_SCHEDULER support for Rolling Upgrades
  • Broker VALIDATE DATABASE capability
  • Enhanced Broker configuring with RedoRoutes
  • Broker Resumable switchover
  • New Broker Observer properties and capabilities
  • Broker support of Cascading Redo destinations

Active Data Guard

  • Real Time Cascading Redo destinations
  • WAN Distance Zero Data Loss with Far Sync
  • Global Temporary Table DML on a standby
  • Sequences (global and session) on a standby
  • DBMS_ROLLING automated rolling upgrades
  • Support for Oracle Application Continuity
  • Support for Oracle Global Data Services

 

Review - Data Guard 12.2 New Features Summary

Data Guard

  • Use DBCA and EMCLI to create Standbys
  • Use RMAN and Enterprise Manager to create Far Sync Instances in addition to Standbys
  • Rest Interface to the Data Guard Broker
  • Chef tools to create and manage Data Guard standbys
  • Scripting with the Broker DGMGRL  command line interface
  • Easily creating Subset Standby databases in Multitenant
  • Migrate and Failover PDBs with the Broker
  • Automatic Password File management
  • Easy repair of No Logging operations
  • Data File Block Comparison between Primary and Standby
  • Multiple FSFO Targets  and Observers
  • FSFO in Maximum Protection mode
  • Zero Data Loss Failovers in any mode with Storage Failures
  • Enhanced control of Alternate destinations
  • Convert to TDE easily with little or no downtime

Active Data Guard

  • Using all your Standby Instances to apply redo
  • Data Guard Broker Support and involvement in DBMS_ROLLING controlled rolling upgrades
  • Use the In Memory Column Store on your Standby
  • Use AWR and SQL Tuning Advisor to diagnose and tune Redo Apply and Query issues on your Active Data Guard Standby
  • Move users transparently during role change with Session Draining on the Primary and Preserving existing connections at the Active Data Guard Standby
  • More protection with Auto Block repair enhancements

 

this is the end of this article, we hope it can be useful.. Stay tune for more Oracle Database Cloud articles.

 

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

Follow us in Enmotech LinkedIn Page: https://www.linkedin.com/company/1856106/

 

Hi Readers

 

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

Click here to read, Thank you very much:

#14 Oracle 18c: Oracle 18c.. 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

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

 

In this article we will show you how to access oracle cloud instance in GUI mode.

 

Create the new Cloud Database Service

a) Login to your Oracle cloud services account, go to the "Oracle Database Cloud Service" page and create a new service.

  • For Service Name, select PREMISE.
  • From the Service Level list, select Oracle Database Cloud Service.
  • From the Metering Frequency list, select whatever frequency is appropriate for your environment.
  • From the Software Release list, select Oracle Database 11g Release2.
  • From the Software Edition list, select Enterprise Edition.
  • From the Database Type list, select Single Instance.

 

Then click Next to continue.

1.JPG

Figure1. Creating a new service (Cloud-Mig12c)

 

b) In the Service Details screen, do the following:

  • For DB Name (SID), enter ORCL.
  • Set an administrative password of your choice and confirm the password (this will be your sys password).
  • For Usable Database Storage (GB), enter 25.
  • From the Compute Shape list, select OC3 -1 OCPU, 7.5GB RAM (this is the bare minimum required).
  • For SSH Public Key, enter rsa-key-20170111.pub.

 

Then click Next to continue.

2.JPG

Figure 2. Specifying the service details

 

c) Finally, review the configuration and click Create to create your cloud database.

3.JPG

Figure 3. Creating the cloud database instance

 

c) After a few minutes, the cloud database instance has been created successfully.

4.JPG

Figure 4. The cloud database has been created

 

d) Click the service name (PREMISE) to open the main page of the database.

5.JPG

Figure 5. Main page of the cloud database

 

Connect the Cloud Database

1. Open the instance of the PuTTY executable and connect to the machine using SSH public key.

6.jpg

Figure 6. Connecting to machine using PuTTY

 

Login to Putty with OPC user

 

1. Login with OPC user and sudo to root

Using username "opc".

Authenticating with public key "rsa-key-20170425"

Passphrase for key "rsa-key-20170425":

[opc@PREMISE ~]$ sudo su

[root@PREMISE opc]#

 

2. Installing RPM with YUM

  • yum groupinstall "X Windows System"
  • yum groupinstall "X Window System" -y
  • yum groupinstall "Desktop" -y
  • yum groupinstall "Desktop Platform" -y
  • yum groupinstall "General Purpose Desktop" -y
  • yum groupinstall "Graphical Administrator Tools" -y
  • yum groupinstall "Graphical Adminstration Tools" -y
  • yum groupinstall "Graphical Administration Tools" -y
  • yum install tigervnc-server
  • yum install tigervnc-server -y
  • yum install gnome-panel -y
  • yum install firefox–y

 

2. Installing RPM with YUM

[root@PREMISE opc]# yum groupinstall "X Windows System"

[root@PREMISE opc]# yum groupinstall "X Window System" -y

[root@PREMISE opc]# yum groupinstall "Desktop" -y

[root@PREMISE opc]# yum groupinstall "Desktop Platform" -y

[root@PREMISE opc]# yum groupinstall "General Purpose Desktop" -y

[root@PREMISE opc]# yum groupinstall "Graphical Administrator Tools" -y

[root@PREMISE opc]# yum groupinstall "Graphical Adminstration Tools" -y

[root@PREMISE opc]# yum groupinstall "Graphical Administration Tools" -y

[root@PREMISE opc]# yum install tigervnc-server

[root@PREMISE opc]# yum install tigervnc-server -y

[root@PREMISE opc]# yum install gnome-panel -y

[root@PREMISE opc]# yum install firefox -y

[root@PREMISE opc]#

 

3. Creating the password for VNCServer.

[root@PREMISE opc]# vncserver :1 -depth 16 -alwaysshared -geometry 1600x720 -s off

You will require a password to access your desktops.

Password:

Verify:

xauth:  file /root/.Xauthority does not exist

New 'PREMISE:1 (root)' desktop is PREMISE:1

Creating default startup script /root/.vnc/xstartup

Starting applications specified in /root/.vnc/xstartup

Log file is /root/.vnc/PREMISE:1.log

[root@PREMISE opc]#

 

Creating Tunnels with PuTTY

1. Open the PuTTY executable and click on Tunnels.

For Source port,enter6905.

For Destination,enter141.144.32.52:5901.

 

Then Click on Add.

7.JPG

Figure 7. Connecting to PuTTY

 

2. Click on Open

8.JPG

Figure 8. Add tunnels

 

Connecting with VncServer

Create New Connection in VNCServer.

9.jpg

Figure 9. New connection in Vncserver

 

2. Create New Connection in VNCServer.

For VNC Serverenterlocalhost:6905.

For Encryption, select Prefer off.

10.jpg

Figure 10. entering details

 

3. Connect in VNCServer.

11.jpg

Figure 11. Connect to vnc server

 

4. Enter the Password and then click on OK.

12.jpg

Figure 12.password window

 

5. Now we are able to GUI Mode.

13.JPG

Figure 13. GUI Mode of VNC

 

Conclusion

So now you know that it is very easy to access GUI Mode in Cloud Instance.

Well.. Until here, this article. We hope it can be useful for making grow your knowledge about Oracle Database 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

 

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

 

This method can be used only if the on-premises platform is little endian, and the database character sets of your on-premises database and Oracle Database Cloud Service database are compatible.

 

To migrate an Oracle Database 12c PDB to a PDB in an Oracle Database 12c database on an Oracle Database Cloud Service deployment using the RMAN cross-platform transportable PDB method, you perform these tasks:

 

1.- On the on-premises database host, invoke SQL*Plus and close the on-premises PDB.

2.- On the on-premises database host, execute the ALTER PLUGGABLE DATABASE UNPLUG command to generate an XML file containing the list of datafiles that will be plugged in on the cloud database.

3.- On the on-premises database host, invoke RMAN and connect to the root. Execute the BACKUP FOR TRANSPORT PLUGGABLE DATABASE command.

4.- Creating the Database Cloud Service database

5.- Use a secure copy utility to transfer the XML file and the backup set to the Database Cloud Service compute node.

6.- On the Database Cloud Service compute node, invoke RMAN and connect to the root. Execute the RESTORE ALL FOREIGN DATAFILES command.

7.- the Database Cloud Service compute node, invoke SQL*Plus and connect to the root. Execute the CREATE PLUGGABLE DATABASE command.

8.- the Database Cloud Service compute node, execute the ALTER PLUGGABLE DATABASE OPEN command.

 

On-premises database to Cloud Using RMAN Cross-Platform Transportable PDB: Example

This example is to migrate an On-premises database to Cloud Using RMAN Cross-Platform Transportable PDB

In this example, the on-premises database is on a Linux host.

 

1.- On the on-premises database host, invoke SQL*Plus and close the on-premises PDB.

 

a) On the on-premises database host, invoke SQL*Plus and log in to the on-premises database as the SYS user.

[oracle@cloud ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Sun Jun 4 11:47:11 2017

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

 

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

 

SQL>

 

b) Close the on-premises PREM_PDB PDB.

SQL> ALTER PLUGGABLE DATABASE pdb_prem CLOSE;

Pluggable database altered.

SQL>

 

2. On the on-premises database host, execute the ALTER PLUGGABLE DATABASE UNPLUG command to generate an XML file containing the list of datafiles that will be plugged in on the cloud database.

 

a) Create a directory for creating the xml and backup file.

[oracle@cloud ~]$ mkdir –p /u01/app/dpump/

[oracle@cloud ~]$

 

b) Unplug the PDB. The following command generates the XML file.

SQL> ALTER PLUGGABLE DATABASE pdb_prem UNPLUG INTO '/u01/app/dpump/PDB_PREM.xml';

Pluggable database altered.

 

SQL>

 

3.- On the on-premises database host, invoke RMAN and connect to the root. Execute the BACKUP FOR TRANSPORT PLUGGABLE DATABASE command.

 

a) On the on-premises database host, invoke RMAN and log in to the on-premises database as the SYS user.

[oracle@cloud admin]$ rman target /

 

Recovery Manager: Release 12.1.0.2.0 - Production on Thu Jun 8 22:33:05 2017

 

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

 

connected to target database: CDBPREM (DBID=1893698667)

 

RMAN>

 

b) Take the backup

RMAN> BACKUP FOR TRANSPORT AS COMPRESSED BACKUPSET PLUGGABLE  DATABASE  'PDB_PREM'  FORMAT  '/u01/app/dpump/PDB_PREM.dfb';

Starting backup at 08-JUN-17

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=82 device type=DISK

channel ORA_DISK_1: starting compressed full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00011 name=/u01/app/oracle/oradata/CDBPREM/PDB_PREM/example01.dbf

input datafile file number=00009 name=/u01/app/oracle/oradata/CDBPREM/PDB_PREM/sysaux01.dbf

input datafile file number=00008 name=/u01/app/oracle/oradata/CDBPREM/PDB_PREM/system01.dbf

input datafile file number=00010 name=/u01/app/oracle/oradata/CDBPREM/PDB_PREM/SAMPLE_SCHEMA_users01.dbf

input datafile file number=00012 name=/u01/app/oracle/oradata/CDBPREM/fsindex01.dbf

input datafile file number=00013 name=/u01/app/oracle/oradata/CDBPREM/fsdata01.dbf

channel ORA_DISK_1: starting piece 1 at 08-JUN-17

channel ORA_DISK_1: finished piece 1 at 08-JUN-17

piece handle=/u01/app/dpump/PDB_PREM.dfb tag=TAG20170608T223310 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:01:35

Finished backup at 08-JUN-17

 

RMAN>

 

4.- Creating the new Cloud Database Service

a) Login to your Oracle cloud services account, go to the "Oracle Database Cloud Service" page and create a new service.

  • For Service Name, select Cloud-Mig12c.
  • From the Service Level list, select Oracle Database Cloud Service.
  • From the Metering Frequency list, select whatever frequency is appropriate for your environment.
  • From the Software Release list, select Oracle Database 12c Release1.
  • From the Software Edition list, select Enterprise Edition.
  • From the Database Type list, select Single Instance.

 

Then click Next to continue.

fig 01.JPG

Figure1. Creating a new service (Cloud-Mig12c)

 

b) In the Service Details screen, do the following:

  • For DB Name (SID), enter PRODDB.
  • Set an administrative password of your choice and confirm the password (this will be your sys password).
  • For Usable Database Storage (GB), enter 25.
  • From the Compute Shape list, select OC3 -1 OCPU, 7.5GB RAM (this is the bare minimum required).
  • For SSH Public Key, enter rsa-key-20170111.pub.

 

Then click Next to continue.

fig 02.JPG

Figure 2. Specifying the service details

 

c) Finally, review the configuration and click Create to create your cloud database.

fig 03.JPG

Figure 3. Creating the cloud database instance

 

After a few minutes, the cloud database instance has been created successfully.

fig 04.JPG

Figure 4. The cloud database has been created

 

d) Click the service name (Cloud-Mig12c) to open the main page of the database.

fig 05.JPG

Figure 5. Main page of the cloud database

 

e) Before trying to connect to the primary database instance on the cloud machine, you have to enable the dblistener access rule. Do the following:

a. Open the database service and select Access Rules from the menu.

fig 06.JPG

Figure 6. Selecting the Access Rules item

 

b. For the ora_p2_dblistener rule, select Enable from the Actions menu.

fig 07.JPG

Figure 7. Enabling the ora_p2_dblistener rule

 

Connect the Cloud Database

1. Open the instance of the PuTTY executable and connect to the machine using SSH public key.

fig 08.JPG

Figure 8. Connecting to machine using PuTTY

 

5.- Use a secure copy utility to transfer the XML file and the backup set to the Database Cloud Service compute node.

 

a) On the Database Cloud Service compute node, create a directory for the backup set and dump file.

[oracle@Cloud-Mig12c ~]$ mkdir –p /u01/app/on_premise/

[oracle@Cloud-Mig12c ~]$

 

b) Before using the scp command to copy files, make sure the SSH private key that provides access to the Database Cloud Service compute node is available on your on-premises host.

 

c) On the on-premises database host, use the SCP utility to transfer the backup set and the dump file to the Database Cloud Service compute node.

[oracle@cloud ~]$ scp -i rsa-key-20170111.ssh /u01/app/dpump/PDB_PREM.xml oracle@129.144.149.23:/u01/app/on_premise

Enter passphrase for key 'rsa-key-20170111.ssh':

PDB_PREM.xml                                                                                                                          100% 7681     7.5KB/s   00:00

[oracle@cloud ~]$ scp -i rsa-key-20170111.ssh /u01/app/dpump/PDB_PREM.dfb oracle@129.144.149.23:/u01/app/on_premise

Enter passphrase for key 'rsa-key-20170111.ssh':

PDB_PREM.dfb                                                                                                                          100%  190MB  55.8KB/s   58:06

[oracle@cloud ~]$

 

6.- On the Database Cloud Service compute node, invoke RMAN and connect to the root. Execute the RESTORE ALL FOREIGN DATAFILES command.

 

a) Invoke RMAN and log in to the PDB as a user that has been granted the SYSDBA or SYSBACKUP privilege.

[oracle@Cloud-Mig12c ~]$ rman target /

 

Recovery Manager: Release 12.1.0.2.0 - Production on Thu Jun 8 18:08:20 2017

 

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

 

connected to target database: PRODDB (DBID=685826250)

 

RMAN>

 

b) Execute the RESTORE command.

RMAN> RESTORE ALL FOREIGN DATAFILES TO NEW FROM BACKUPSET  '/u01/app/on_premise/PDB_PREM.dfb';

Starting restore at 08-JUN-17

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=36 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring all foreign files in backup piece

channel ORA_DISK_1: reading from backup piece /u01/app/on_premise/PDB_PREM.dfb

channel ORA_DISK_1: restoring foreign file 11 to /u02/app/oracle/oradata/PRODDB/datafile/o1_mf_example_dmm4nwql_.dbf

channel ORA_DISK_1: restoring foreign file 9 to /u02/app/oracle/oradata/PRODDB/datafile/o1_mf_sysaux_dmm4nwt1_.dbf

channel ORA_DISK_1: restoring foreign file 8 to /u02/app/oracle/oradata/PRODDB/datafile/o1_mf_system_dmm4nwx9_.dbf

channel ORA_DISK_1: restoring foreign file 10 to /u02/app/oracle/oradata/PRODDB/datafile/o1_mf_users_dmm4nx06_.dbf

channel ORA_DISK_1: restoring foreign file 12 to /u02/app/oracle/oradata/PRODDB/datafile/o1_mf_fsindex_dmm4nx1z_.dbf

channel ORA_DISK_1: restoring foreign file 13 to /u02/app/oracle/oradata/PRODDB/datafile/o1_mf_fsdata_dmm4nx3c_.dbf

channel ORA_DISK_1: foreign piece handle=/u01/app/on_premise/PDB_PREM.dfb

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:01:46

Finished restore at 08-JUN-17

 

c) Exit from RMAN.

 

7.- the Database Cloud Service compute node, invoke SQL*Plus and connect to the root. Execute the CREATE PLUGGABLE DATABASE command.

 

a) On the on-premises database host, invoke SQL*Plus and log in to the on-premises database as the SYS user.

[oracle@cloud ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Sun Jun 4 11:47:11 2017

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

 

SQL>

 

b) Execute the CREATE PLUGGABLE DATABASE command.

SQL> CREATE PLUGGABLE DATABASE PDB_PREM as clone USING '/u01/app/on_premise/PDB_PREM.xml'

source_file_name_convert = (

'/u01/app/oracle/oradata/CDBPREM/PDB_PREM/system01.dbf','/u02/app/oracle/oradata/PRODDB/datafile/o1_mf_system_dmm4nwx9_.dbf',

'/u01/app/oracle/oradata/CDBPREM/PDB_PREM/sysaux01.dbf','/u02/app/oracle/oradata/PRODDB/datafile/o1_mf_sysaux_dmm4nwt1_.dbf',

'/u01/app/oracle/oradata/CDBPREM/PDB_PREM/SAMPLE_SCHEMA_users01.dbf','/u02/app/oracle/oradata/PRODDB/datafile/o1_mf_users_dmm4nx06_.dbf',

'/u01/app/oracle/oradata/CDBPREM/PDB_PREM/example01.dbf','/u02/app/oracle/oradata/PRODDB/datafile/o1_mf_example_dmm4nwql_.dbf',

'/u01/app/oracle/oradata/CDBPREM/fsindex01.dbf','/u02/app/oracle/oradata/PRODDB/datafile/o1_mf_fsindex_dmm4nx1z_.dbf',

'/u01/app/oracle/oradata/CDBPREM/PDB_PREM/PDB_PREM_temp012017-05-21_01-01-24-PM.dbf','/u02/app/oracle/oradata/PRODDB/datafile/pdb4_temp01.dbf',

'/u01/app/oracle/oradata/CDBPREM/fsdata01.dbf','/u02/app/oracle/oradata/PRODDB/datafile/o1_mf_fsdata_dmm4nx3c_.dbf')

file_name_convert=NONE NOCOPY TEMPFILE REUSE;

Pluggable database altered.

 

SQL>

 

8.- The Database Cloud Service compute node, execute the ALTER PLUGGABLE DATABASE OPEN command.

 

a) Set the PDB_PREM to READ WRITE

SQL> ALTER PLUGGABLE DATABASE pdb_prem OPEN;

Pluggable database altered.

SQL>

 

b) Exit from SQL*Plus.

 

Well.. Until here, this article. We hope it can be useful for making grow your knowledge about Oracle Database 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:

#11 Oracle 18c: “Oracle 18c and its impact on DBAs” – 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

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

 

In this article we will show you an Oracle Exadata Cloud Service Account with the ability to provision the Creating an Exadata Database Cloud Service Instance.

 

Creating an Exadata Database Service Instance

When you create an Oracle Database Exadata Cloud Service instance, you provision the Exadata Database Machine that hosts your Exadata Cloud Service database deployments. To create an Exadata Cloud Service instance, use the Create New Oracle Database Exadata Cloud Service Instance wizard as described in the following procedure.

 

To create an Exadata Cloud Service instance:

1. Open the My Services dashboard.

2. Click Create Instance and then select Exadata from the list of options.

The Create New Oracle Database Exadata Cloud Service Instance wizard starts and the Instance Details page is displayed.

3. On the Instance Details page, configure details for your Exadata Cloud Service instance. Then, click Next.

         a. In the Instance Details section, specify the following attributes associated with your Exadata Cloud Service instance.

      • Name — enter a name for your service instance. This name:
        • Must not exceed 25 characters.
        • Must start with a letter.
        • Must contain only lower case letters and numbers.
        • Must not contain spaces or any other special characters.
        • Must be unique within the identity domain.
      • Rack Size — select the rack configuration for your service instance:
        • Quarter Rack — configures an environment consisting of 2 compute nodes and 3 Exadata Storage Servers.
        • Quarter Rack X6 — configures an environment consisting of 2 compute nodes and 3 Exadata Storage Servers.
        • Half Rack — configures an environment consisting of 4 compute nodes and 6 Exadata Storage Servers.
        • Half Rack X6 — configures an environment consisting of 4 compute nodes and 6 Exadata Storage Servers.
        • Full Rack — configures an environment consisting of 8 compute nodes and 12 Exadata Storage Servers.
        • Full Rack X6 — configures an environment consisting of 8 compute nodes and 12 Exadata Storage Servers.

        b. In the Administrator Details section, provide information about the administrator of your Exadata Database Machine environment.

      • Email — enter an email address for the Exadata system administrator.
      • User Name — enter a user name for the Exadata system administrator. Alternatively, check the Use email as user name option to copy the Email entry into the User Name field.
      • First Name — enter the first name of the Exadata system administrator.
      • Last Name — enter the last name of the Exadata system administrator.

4. On the Confirmation page, review the configuration settings. If you are satisfied, click Create Service Instance.

 

Creating an Exadata Database Service Instance: Example

1. Open the My Services dashboard.

1.JPG

Fig 1: Services dashboard

 

2. Click Create Instance and then select Oracle Database Cloud – Exadata Service from the list of options.Then, click Next.

2.JPG

Fig 2: select Exadata Service

 

3. Select Oracle Database 12c Release1 from the list of options.Then, click Nextto continue.

3.JPG

Fig 3: select database version

 

4. In the Service Details screen, do the following:

  • For Service Name, enter urban-beans-db1.
  • From Exadata System list, select urbanbeans-exa-Quarter Rack (2 nodes).
  • For DB Name (SID), enter urbandb1.
  • For PDB Name, enter urbpdb1.
  • Set an administrative password of your choice and confirm the password (this will be your sys password).
  • From Backup Destination list, select Cloud Storage only.

 

Then click Next to continue.

4.JPG

Fig 4: Specifying the service details

 

5. Finally, review the configuration and click Create to create your cloud database.

5.JPG

Fig 5: Creating the Exadata cloud database instance

 

6. After a few minutes, the data guard in exadatacloud database instance has been created successfully.

6.JPG

Fig 6: The Exadata cloud database has been created

 

7. Click the service name (URBAN-BEAN-DB1) to open the main page of the database.

7.JPG

Fig 7: Main page of the exadata cloud database

 

Conclusion

So now you know that it is very easy to create an Exadata Database Service Instance.

We hope this article is useful and we invite you to continue reading our next publications focused on Oracle 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.com