Oracle 18c XE – the hidden catch..! By Connor McDonald @connor_mc_d
Hi Readers
To watch click here:
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Oracle 18c New Features for DBA’s by Suresh Gandhi..!!
Hi Readers
To watch click here:
We hope the content could be useful for your Oracle DBA Tasks!
Hi Readers
To watch this interesting video, click here:
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Hi Readers
To read the article click here:
https://oracle-base.com//articles/18c/multitenant-cdb-fleet-management-18c
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Upgrade to Oracle Database 18c: Live and Uncensored..! by Roy Swonger
Hi Readers
to watch the video, click down below:
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Oracle Database is still one of the world’s most popular, trusted database systems providing services for some of the largest companies. All the different versions provide a variety of new features and innovative capabilities in all areas including security, development, management, and performance. All providing the database administrator and developer with additional tools to assist creating innovative application on top of a secure and efficient database infrastructure. Oracle is highly recognized for its development and constant transformation, therefore it’s important to continually study the history of older versions, while embracing the new features and functionality of the newer versions.
Today, we’ll briefly analyse the difference between 2 of the latest versions 11g & 12c see what oracle have planned for the next version 18c and why it’s been classed as the game changer.
The first database to support Web technologies such as Java and HTTP originally began with Oracle 8 & 8i. The ‘i’ standing for “Internet”. Oracle included the “i” to the name to reflect support for the Internet with its built-in Java Virtual Machine (JVM). The updated version, Oracle 9i added more support for XML in 2001. Released in 2003, versions 10g and 11g was introduced with emphasis on the “g” signifying “Grid Computing”, enabling groups of low-cost industry standard servers to be treated as a single unit. This meant Data centers could now share hardware resources, thus reducing the cost of computing infrastructure.
With the latest generation of the world’s most popular database, Oracle Database 12c is by far the most important Oracle release in the last 10 years. With the “c” standing for “Cloud”, 12c provides companies of all sizes with access to the world’s fastest, most scalable and reliable database technology in a cost-effective, hybrid Cloud environment. 12c includes a series of innovations that supports customers to easily convert to the Cloud while preserving their investments in Oracle Database technologies, skills and resources. Its newer, more innovative capabilities encourage better performance, increased scalability, and easier data management. Further translating into significant cost savings, reduced risk, and increased flexibility. Oracle Database 12C implements a multitenant architecture, supporting the creation of pluggable databases (PDBs) in a multitenant container database (CDB). This enables easier unification of multiple databases and clouding of databases into IaaS, PaaS, and DBaaS deployments.
Not all versions differ drastically with Oracle offering dedicated database instances with Oracle Databases 11g, 12.1 and 12.2, with a personal choice of Standard, Enterprise, High Performance, or Extreme Performance packaging. Every version sees enhancements in areas the ones prior may have lacked. 11g features built in testing for changes, the capability of viewing tables back in time, superior compression of all types of data and enhanced disaster recovery functions. Full database caching is not implemented in 11g as caching in memory parallel query could not work well with scans contented for cache memory. This was developed further in 12c as Oracle introduces a new concept known as Automatic Big Table caching, improving significant performance benefits for workloads that was previously limited. 11g supports the feature of Oracle in memory tables used to improve full table scans, needed for access to fast data, however doesn’t support the In-Memory Aggregation (IMA) concept which Oracle 12c supports. IMA is designed to provide improved query performance while utilizing fewer CPU resources. In-Memory Aggregation provides fast query performance with fully dynamic aggregation of data without the need for indexes, summary tables or materialized views.
12c also introduces a simpler system to migrate table partition and sub partition using 2 methods, one with online keywords and secondly an offline method. A few enhancements in form of invisible indexes and virtual columns were introduced in 11g but invisible columns weren’t introduced until the release of 12g. This enables the user to define invisible columns in the table. Once defined it is explicitly referred to SQL statement or condition in SQL statement.
to continue reading the article, click the link down below:
https://www.dsp.co.uk/innovation-oracle-database-versions-difference-11g12c-18c/
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Oracle New Features 18c – Polymorphic Tables Functions,Self-Desc In-DB Analytical Algorithms by Keith Laker..!!
Hi Readers
To watch this video, click here:
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Oracle GoldenGate 18c is finally available..!! by Mike Dietrich..!!
Hi Readers
To read click here:
https://mikedietrichde.com/2018/11/02/oracle-goldengate-18c-is-finally-available/
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Oracle Database Express Edition (XE) Release 18.4.0.0.0 (18c) Released..!!
Hi Readers
Oracle Database Express Edition (XE) Release 18.4.0.0.0 (18c) was released on October 19, 2018. To download, follow this link:
Steps to install..!
https://oracle-base.com/articles/18c/oracle-db-18c-xe-rpm-installation-on-oracle-linux-6-and-7
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
My laptop can’t fly…. but Oracle 18cXE does!! By Connor McDonald @connor_mc_d
By Connor McDonald @connor_mc_d
Hi Readers
To watch click here:
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Post 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
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Oracle18c News.. I’ve got some good news… and some bad news..!! By Connor McDonald @connor_mc_d
By Connor McDonald @connor_mc_d
Hi Readers
To watch click here:
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Post 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
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
18c Database creation on Windows..!! By Connor McDonald @connor_mc_d
By Connor McDonald @connor_mc_d
Hi Readers
To watch click here:
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Post 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
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Online EVERYTHING in 12c Release 2 and 18c..!! By Connor McDonald @connor_mc_d
By Connor McDonald @connor_mc_d
Hi Readers
To watch click here:
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Post 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
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Create your Oracle 18c database with a few clicks!..!!
Hi Readers
To watch click here:
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Post 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
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
The cool new “Unzip to target” mechanism for 18c software installation..!!
To watch click here:
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Post 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
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Oracle 18c : MEMOPTIMIZE_POOL_SIZE in SGA..!!
By HariPrasath Rajaram
Hi Readers
To read click here:
Oracle Database 18c: Introduction to Memoptimized RowStore (Memory of a Free Festival)
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Post 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
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Oracle 18c XE will blow your mind..!!
To watch click here:
My laptop can’t fly.. but Oracle 18c XE does!!
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Post 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
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Upgrade Oracle 12.2.0.1 to Oracle Database 18c on-premises..!!
To read click here:
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Post 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
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Oracle 18c Non-CDB Databases In The Oracle Database Cloud Service (ODBCS)..!!
Hi Readers
To read this article click here:
Oracle 18c Non-CDB Databases in the Oracle Database Cloud Service (ODBCS)
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Post 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
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Oracle 18c Security utl_file_dir and schema no authentication..!!
Hi Readers
To read click here:
http://www.petefinnigan.com/weblog/archives/00001435.htm
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Post 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
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
New in 18c: In-Memory Optimized Number Format Speeds Up Arithmetic Operations..!!
Hi Readers
To read thick article Click Here:
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Post 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
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Purging of PDB_PLUG_IN_VIOLATIONS in Oracle 18c..!!
Hi Readers
For Reading Click here:
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Post 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
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Enterprise Manager DB Express for 18c database ( Release 18.0.0.0.0 )..!!
Hi Readers
SSH into your DB System node, and open a tunnel for the port we will use on the Enterprise Manager DB Express 18c.
ssh -i <SSH_PRIVATE_KEY> -C -L 5505:localhost:5505 opc@<PUBLIC_IP>
Login as Oracle user.
$sudo su – oracle
Set the environment variables for your Database system.
$ . oraenv
ORACLE_SID = [oracle] ? <DATABASE_NAME>
The Oracle base has been set to /u01/app/oracle
Connect to your Container database as SYSDBA.
$ sqlplus / as sysdba
SQL*Plus: Release 18.0.0.0.0 Production on Fri Mar 23 16:59:49 2018
Version 18.1.0.0.0
Copyright (c) 1982, 2017, Oracle. All rights reserved.
Connected to:
Oracle Database 18c EE High Perf Release 18.0.0.0.0 – Production
Version 18.1.0.0.0
Run the following commands and procedures.
SQL> alter user xdb account unlock;
SQL> exec dbms_xdb_config.SetHttpPort(5505);
PL/SQL procedure successfully completed.
SQL> exec dbms_xdb_config.SetGlobalPortEnabled(TRUE);
PL/SQL procedure successfully completed.
Use your browser on your local computer to open the console at http://localhost:5505/em.
Enjoy!
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Post 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
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Unplug a 12.2.0.1 PDB and plugin into 18c in the Cloud..!!
Hi Readers
For Reading this great article click here:
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Post 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
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
In Oracle 18c DBAs must understand the difference between “Autonomy vs Automation”..!! By Paul Toal
Hi Readers
At OpenWorld 2017 last year (it still seems strange saying last year), Oracle announced“The world’s first Autonomous Database”. The marketing literature states:
“Oracle Autonomous Database Cloud eliminates complexity, human error, and manual management, helping to ensure higher reliability, security, and more operational efficiency at the lowest cost.”
When I first heard about the autonomous database, I didn’t quite get it. I’m no database expert but I thought that we had database management well in hand. I know DBAs with decades of experience who can manage databases with their eyes shut, usually using lots of scripts and automation.
So, what’s different about the new Oracle Autonomous Database? The penny dropped for me when I realised the differencet between automation and autonomy. A common misunderstanding is that Oracle has just automated the database. That is not the case.
Automation refers to a set of sequential steps that are executed in order, usually using a script. Think of an unattended installer. You give it the settings and it executes a number of predefined steps to install your piece of software with the settings you define. Another example might be a DBA who has written a script to automate the patching of a server. The script will run through a series of steps, such as, connect to the server, upload the patch, execute the patch, verify the patch, then, restart the server. Both of these are examples of automation, not autonomy.
When Oracle talks about the Autonomous Database, they aren’t saying that they have just written a number of scripts to automate several steps, they are talking about autonomy, i.e. self-management.
What this means is that, as the administrator, you will define the parameters within which the database must operate and the database will take care of that for you. For example, you will define the service level you need, or the information retention policy you must enforce. Then, the database will do the rest, under the covers to meet that requirement. No more setting up RAC or DataGuard to configure HA and DR.
From a security perspective, the Autonomous Database also reduces the risks associated with manually managed databases. Yes, we have some very clever and experienced DBAs with mature scripts, but, in today’s world of increasing cyberattacks and more data breaches than ever before, against larger and more sensitive data, we need to remove as much of the manual processes associated with security as possible. There will, of course, always be a need for some manual intervention, but the security posture in any organisation, and the response to any threat needs to be more rapid than waiting for an overworked DBA or SOC Analyst to get around to dealing with it.
For example, the Autonomous Database will patch itself regularly with the latest patches and always enable encryption, so you don’t inadvertently leave data stored in the clear.
At the moment, industry is losing the cat and mouse game against the cyber criminals. Looking beyond databases, I can see lots of other places where autonomy, underpinned by capabilities such as machine learning, will play a crucial role in the cyber war in the near future. There is a long way to go, but it’s an exciting time at Oracle, seeing the emergence of technologies such as the Autonomous Database, as well as our newly designed Identity SOC, really looking at how they address this changing threat landscape using the latest and greatest innovations.
2018 is going to be an exciting year.
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Post 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
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Click here to read the article
Oracle 18c: Introduction to In-Memory External Tables in 18c..!!
Hi Readers
Enjoy Reading: Click here to read the article
Additional Material: Oracle Database In-Memory with Oracle Database 18c Technical Overview
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Post 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
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
18c Private Temporary Tables – Why ..?
Hi Readers
Enjoy watching:
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Post 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
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Display the sql_id for a query in Oracle 18c..!!
Hi Readers
Click the link down below to read:
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Post 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
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
SET LINESIZE window in Oracle 18c..!!
Hi Readers
SET LINESIZE is a very common command in SQL*Plus, let’s see how to do it in Oracle 18c
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Post 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
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Oracle 18c: Your Autonomous Future: A Panel Discussion..!!
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Post 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
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
SQL*Plus 18c rocks..!!
Hi Readers
SQL*Plus 18c is rocking.. Discover the new capability to get SQL IDs.. this will blow your mind.. To watch the video click it.
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Post 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
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Do you know how to cancel a single SQL command in Oracle 18c ?
Hi Readers
As of Oracle 18c , you can not only abort a database session, but also just a single SQL command. This article shows how it works. Click to read:
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Post 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
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
作者介绍:何剑敏 大疆创新 互联网事业部 运维部数据库技术团队负责人,曾供职于中国联通,卓望数码,IBM 和 ORACLE ACS 华南团队。多年从事一线的数据库运维工作,有丰富项目经验、维护经验和调优经验,目前带领团队专注于 Oracle,MSSQL,PostgreSQL,MySQL,Redis 和 MongoDB 的云上云下的整体运维。
Oracle 18c 是在 2018-02-16 发布出来的,还是秉承着 Oracle 的 Cloud first 理念,18c 现在 Cloud 和 Engineered Systems 上推出。
下面,从我自己的角度快速 Review 一下值得关注的 18c 新特性(当然可能还有其他很多值得关注的新特性)。
(一)Availability
1. Oracle Data Guard Multi-Instance Redo Apply Supports Use of Block Change Tracking Files for RMAN Backups
现在,Multiple-Instance Redo Apply(也叫 MIRA ),也可以支持 BCT(Block Change Tracking)的备份方式了。这对于超大的数据库,且是主从都是 RAC,且备份发生在从库上,这是非常有效的一种增量备份方式。
2. Automatic Correction of Non-logged Blocks at a Data Guard Standby Database
新增两种 standby logging 模式(主要是为了加快主库 loading 数据):
一种是 Standby Nologging for Data Availability,即 loading 操作的 commit 会被 delay,直到所有的 standby 都 apply data 为止。
SQL> ALTER DATABASE SET STANDBY NOLOGGING FOR DATA AVAILABILITY;
一种是 Standby Nologging for Load Performance,这种模式和上一种类似,但是会在 load 数据的时候,遇到网络瓶颈时,先不发送数据,这就保证了 loading 性能,但是丢失了数据,但是丢失的数据,会从 primary 中再次获取。
SQL> ALTER DATABASE SET STANDBY NOLOGGING FOR LOAD PERFORMANCE;
3. Shadow Lost Write Protection
创建一个 shadow tablespaces(注:是 big file tablespace)来提供保护。注:此时你就可以不需要 ADG 来提供额外的 lost write 的保护了。
搞 MySQL 的同学,你们是不是发现了什么?这是不是很像 double write? 嘿嘿……
4. Backups from non-CDBs are usable after migration to CDB
原来的 non-CDB,可以以这种方式,作为一个 PDB 迁移到当前已经存在的 CDB 中。
5. Support for PDBs as Shards and Catalogs
天,终于支持 shard 是 pdb 了。但是!但是!但是!也只是支持单个 pdb 在单个 cdb 中。哈哈哈哈哈,等于没支持。
6. User-Defined Sharding Method
这个在12.2中的 beta 版中存在的特性在,在正式发布是被取消了。现在,再次 release 出来了。
7. Consistency Levels for Multi-Shard Queries
提供 MULTISHARD_QUERY_DATA_CONSISTENCY 初始化参数,执行的之前可以先设置该初始化参数,避免跨分片查询时的 SCN synchronization。
8. Manual termination of run-away queries
现在,你可以手动的杀掉一个语句,而不断开这个 session:ALTER SYSTEM CANCEL SQL。
ALTER SYSTEM CANCEL SQL ‘SID, SERIAL, @INST_ID, SQL_ID’;
(二)Big Data and Data Warehousing
9. Approximate Top-N Query Processing
注:18c 中,增加了 APPROX_COUNT 和 APPROX_SUM 来配合 APPROX_RANK 的使用。
10. LOB support with IMC, Big Data SQL
LOB 对象也支持 in memory 了。
(三)Database Overall
11. Copying a PDB in an Oracle Data Guard Environment
新增了2个参数,方便在 ADG 环境中创建 PDB。
一个是 STANDBY_PDB_SOURCE_FILE_DIRECTORY,自动寻找 ADG 的数据文件路径(注,在 18c 之前,如果将一个 pdb 插入到一个 standby 环境的中 cdb,需要手动将文件拷贝到 pdb 的 OMF 路径下)
另一个是 STANDBY_PDB_SOURCE_FILE_DBLINK,方便 remote clone 时自动查找 ADG 文件路径(注:在 18c 之前,如果是本地 clone,就不用复制数据文件,但是远程 clone,就需要手动复制)。
12. PDB Lockdown Profile Enhancements
现在可以在 application root 和 CDB root 中创建 PDB lockdown profile。
你现在还可以根据一个 pdb lockdown profile,创建另外一个 pdb lockdown profile。
18c 包含三个默认的 lockdown profile:PRIVATE_DBAAS,SAAS,PUBLIC_DBAAS
13. Refreshable PDB Switchover
PDB refresh 一直号称是穷人的 ADG,这个特性,在18c中也越来越好用了。支持了 switchover。switchover 分成计划内核计划外的两种场景。
计划内的,可以切回去,主要用于平衡 CDB 的负载。
计划外的,主要用于 PDB master 失效之后,不用整个 CDB 做切换。
14. PDB Snapshot Carousel
pdb 的 snapshot 备份转盘,默认保留8份,每24小时备份一次。
ALTER PLUGGABLE DATABASE SNAPSHOT MODE EVERY 24 HOURS;
15. New Default Location of Oracle Database Password File
注意,新的密码文件路径已经在 ORACLE_BASE,而不是 ORACLE_HOME。
16. Read-Only Oracle Home
可以在 dbca 或者 roohctl -enable 来进程 read only oracle home 的安装,
运行 orabasehome 命令可以检查当前的 Oracle Home 是否只读,如果这个命令输出的结果和 $ORACLE_HOME 一样,则表示 Oracle Home 是可读写的。如果输出是 ORACLE_BASE/homes/HOME_NAME,则表示 Oracle Home 是只读。
17. Online Merging of Partitions and Subpartitions
支持在线合并分区。注:需要使用 ONLINE 关键字。
18. Concurrent SQL Execution with SQL Performance Analyzer
SPA 可以并行运行了(默认情况还是串行),帮你更快的完成 SPA 测试。
(四)Performance
19. Automatic In-Memory
自动 In Memory 会根据 Heat Map,在内存使用紧张的情况下,将不常访问的 IM 列驱逐出内存。
20. Database In-Memory Support for External Tables
外部表支持 IM 特性。
21. Memoptimized Rowstore
在 SGA 中有一块 memoptimize pool 区域,大小受 MEMOPTIMIZE_POOL_SIZE 参数设置,当开启 fast lookup 的时候,就能利用该内存区域,进行快速的查找。
开启 fast lookup,需要在建表语句中加上关键字:
当基于主键查询时,就能使用到 fast lookup。
Memoptimized Rowstore 将极大的提高物联网中基于主键的高频查询。
(五)RAC and Grid
22. ASM Database Cloning
可以基于 ASM 做 pdb 的克隆。基于 ASM 的 flex diskgroup 来实现。
23. Converting Normal or High Redundancy Disk Groups to Flex Disk Groups without Restricted Mount
呵呵,鼓励往 flex diskgroup 上转型。
(六)Security
24. Integration of Active Directory Services with Oracle Database
和微软的 AD 结合。在18c之前,需要使用 Oracle Enterprise User Security (EUS) 进行交互,现在,可以使用 centrally managed users (CMU) 直接将 AD 的 users 和 groups 和 Oracle 的 users 和 role 进行 mappiing。
(七)其他
25. 新增初始化参数:
ADG_ACCOUNT_INFO_TRACKING
FORWARD_LISTENER
INMEMORY_AUTOMATIC_LEVEL
INMEMORY_OPTIMIZED_ARITHMETIC
MEMOPTIMIZE_POOL_SIZE
MULTISHARD_QUERY_DATA_CONSISTENCY
OPTIMIZER_IGNORE_HINTS
OPTIMIZER_IGNORE_PARALLEL_HINTS
PARALLEL_MIN_DEGREE
PRIVATE_TEMP_TABLE_PREFIX
STANDBY_PDB_SOURCE_FILE_DBLINK
STANDBY_PDB_SOURCE_FILE_DIRECTORY
TDE_CONFIGURATION
UNIFIED_AUDIT_SYSTEMLOG
WALLET_ROOT
值得说一下的是 OPTIMIZER_IGNORE_PARALLEL_HINTS,在纯 OLTP 的系统中,你终于可以禁用开发人员不受控制的并发了(往往不写并发度)。:)
26. dbms_session.sleep
可以
exec dbms_session.sleep(3);
终于不用再单独 grant dbms_lock 的权限了。
看到上面的这些新特性,你怎么想?“DBA 将死”、“Oracle 将实现自动驾驶”?这些新特性是不是还需要 DBA? :)
相关阅读:
极速体验:Oracle 18c 下载和Scalable Sequence新特性
参考资料:
1. Oracle Database Database New Features Guide, 18c
https://docs.oracle.com/en/database/oracle/oracle-database/18/newft/index.html
2. ORACLE 18C: ORACLE 18C.. NEW FEATURES.. WHAT’S NEWS..
https://blog.enmotech.com/2017/12/17/14-oracle-18c-oracle-18c-new-features-whats-news/
3. Franck Pachot (@FranckPachot)
https://twitter.com/FranckPachot/
祝大家开工大吉!加入我们,开始新一年的学习吧!
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Post 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
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Oracle 18c: Oracle 18c.. New Features.. What’s NEWS..
Oracle 18c 新功能一览
By Joel Peréz & Skant Gupta
This article is brought by en.enmotech.com
Well.. Oracle 18c.. one release more.. ? Uhmm perhaps not.. Oracle 18c has a that kind of air of.. “Starting now.. it’s when Oracle Cloud Database will mark a real strong beginning..”
I have been playing with Oracle Databases in Cloud from some years ago when all this was barely starting.. when it was more the concept of “Cloud Computing” as a whole.. I’m talking about when the Cloud Computing model was originally designed to be implanted “On-prem”, basically with an arrange of some servers.. software.. resources ( CPU.. Memory.. etc ) and all that could be managed by Enterprise Manager to built your own Cloud infrastructure but “On-prem”, that was around year 2013.. the service of Public Cloud was not still available in that time.. In that time we started to know concepts of “Pay-as-you-go..”.. “Chargeback..” and things like that.. the real concept of that first commercial proposal was really a model of “Cloud Computing”
In that time the concept of Oracle Database Cloud was extreme far from what it’s nowadays.. of course.. the product.. the concept was getting mature.. getting shape..
A couple of years later the first Public Cloud services appeared in the market.. year 2015.. Uhmm.. this was really a more close image of what we were having in mind about Oracle Database Cloud.. of course.. it was product that was changing all time.. and getting mature.. at the beginning even you could not choose the database character set.. the wizard interface had more steps.. and so on.. it was like a child opening his/her eyes to the world.. and we could enjoy how all that was growing..
Little by little more Oracle Database Cloud Services were starting to be available as per we have now:
All these lastly mentioned does not include the future new Oracle Database Cloud Services that will be available starting with Oracle 18c.
So.. continuing with the subject.. Oracle Database Cloud services were still changing/evolving.. even its web interface, pricing model, etc until the last months.. so.. it can be said the product was still modeling itself.. but internally we can consider it already a strong product.
So, according to my point of view, all that was a process to see how the product had interaction with real people.. with real customers.. with real companies.. All that was the preparation way to present finally the king product.. “Autonomous Database Suit of Services on Oracle18c..”, which is a great mix of all learned with Oracle Cloud Database Services and all years making better and better the auto-performance tuning techniques.. ( AWR, ADDM, Advisors.. etc )
So, I consider Oracle 18c and all its new feature a real “before and after” related to Cloud Databases..
Oracle 18c as every release.. has many new features.. that can be suitable for some kind of companies and others not too much.. as always.. perhaps a small company for sure will not be interested in autonomous database running in a powerful Exadata and so on.. Perhaps new “Startup” companies could be very interested in the regular “Oracle Database Cloud Service” to have a cheap and fast IT infrastructure.. not thinking as before how costly could be to establish an own data center.. etc..
So, the point it’s.. Oracle 18c as every release has new features for everyone..
The objective of this article is to name/to introduce them briefly before we can get the real production release starting December 2018.
Then, Let’s talk briefly technically of What’s news in Oracle Database 18c..
The figure you will see now is the Lifetime Support Commitments and Plans for current and future Oracle Releases.
*Oracle Database 19c is expected to the long term support release.
Always check MOS Note 742060.1 for the latest schedule.
As you can see between all that information, we will have extended support of 12.2 until 2025 and Oracle 18c will start on December2017. There are a lot of people in fear for the future for DBAs related to Autonomous Database & Oracle 18c, if you want to read my point of view about that subject go here:
#10 Oracle 18c: “Oracle 18c and its impact on DBAs”
Now, Let’s highlight briefly some of what we have today and what we will have in Oracle Database 18c
Performance
Today:
Oracle Database 18c:
Low Latency Memory Transactions
Non Volatile Memory Support
In-Memory Column Store Improvements
Memory Optimized Access for OLTP Workloads
Example: Read Joel’s Balance
Ultra-Fast key-based lookup:
New low latency client protocol with direct access to data engine
Performance benefits:
Memory Optimized Access for IoT Workloads
Example: Write Temperature Reading
New streaming ingest:
Performance:
2x faster throughput than conventional
Multitenant
Today:
Container managed database virtualization
Manage Many as one
Software as Service
Oracle Database 18c:
Example of
RMAN
https://blog.enmotech.com/2017/12/17/16-oracle-18c-rman-new-features-whats-news/
Oracle Data Guard
Oracle 18c: New Features for Oracle Data Guard.. What’s NEWS..
RAC
Availability
Today:
Comprehensive HA and disaster recovery functionality
Oracle Golden Gate for heterogeneous replication
Scale out and fault isolation with Oracle Database Sharding
Oracle Database 18c:
Zero Impact Grid Infrastructure Patching
Sharded RAC
Sharding improvements
Sharded RAC
Higher performance for shard-aware RAC applications
Affinitizes shards to RAC instances
Requests that don’t specify sharding key still work transparently
Gives Sharded Database performance with minimal application changes
Security
Today:
Security In-Depth
Key Vault
Audit Vault Database Firewall
Security Assessment Tool
Oracle Database 18c:
Integration with Active Directory
Per PDB Key storage
Password-less schema creation
Data Warehousing and Big Data
Today:
The most advanced analytics engine available today
Easily analyze data held in Hadoop with Big Data SQL
Big Data Appliance
Oracle Database 18c:
In-Memory for external tables
Automatic propagation of nologged data to standby
More Machine Learning algorithms
Polymorphic Table Functions
Alter Table Merge Partition Online
Approximate Query Improvements
Development
Today:
Application Express 5.1
SQL Developer & SQLCl
Comprehensive Language support
JSON
Oracle Database 18c:
Improved JSON Support
Property Graph Improvements
Rolling patches for OJVM
Private Temporary Tables
Private Temporary Tables
Transient tables useful for reporting applications
Global temporary tables
Persistent, shared (global) table definition
Temporary, private (session-based) data content
Private temporary tables (18c)
Temporary, private (session-based) table definition
Temporary, private (session-based) data content
Database Instance Management REST API
List the pdbs in the exadata database container: https://myserver.mydomain.com/ords/databases/exadata/pdbs
Official Docker Support
Oracle Database is fully supported on Docker for
** Oracle RAC is not supported on Docker “CURRENTLY” but in Oracle 18c Oracle RAC support is coming
MOS Note: Oracle Support for Database Running on Docker (Doc ID 2216342.1)
Oracle 12.2.0.1 & 12.1.0.2 images are available on Oracle Container Registry
Docker build files also available at
New Installation Approaches
Zip file, TAR File, Docker Image, Virtual Box, VM (Ravello, BMC, Vbox)
Oracle Installation via RPM
Oracle Database 18c XE
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
Follow us in Enmotech LinkedIn Page: https://www.linkedin.com/company/1856106/
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
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
When will Oracle Database 18c be available “On-prem”?
When will Oracle Database 18c be available “On-prem”?.. for knowing the answer.. Click the image or the link down below.
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Post 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
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
By Joel Peréz & Skant Gupta
“DBAs will be fired.. ? It’s the end of DBAs because of the Autonomous Databases..?
Obviously not.. believe it or not.. now the DBAs will have more important role in enterprises.
Later of completing the reading of this article you could read more about new features related to Oracle18c:
Oracle 18c: Oracle 18c.. New Features.. What’s NEWS..
https://blog.enmotech.com/2017/12/17/14-oracle-18c-oracle-18c-new-features-whats-news/
Oracle 18c: New Features for Oracle Data Guard.. What’s NEWS..
https://blog.enmotech.com/2017/12/17/15-oracle-18c-new-features-for-oracle-data-guard-whats-news/
Oracle 18c: RMAN New Features.. What’s NEWS..
https://blog.enmotech.com/2017/12/17/16-oracle-18c-rman-new-features-whats-news/
Oracle 18c: RAC New Features.. What’s NEWS..
https://blog.enmotech.com/2017/12/17/17-oracle-18c-rac-new-features-whats-news/
Oracle 18c: Data Warehousing New Features.. What’s NEWS.
https://blog.enmotech.com/2017/12/17/18-oracle-18c-data-warehousing-new-features-whats-news/
Now, Let’s continue with the article..
I have +17 years as Oracle DBA and I could tell you how this profession have been evolving, having a tendency of:
Oracle Database 18c the next generation of the industry-leading database.
Oracle introduces the world’s first autonomous database cloud. Oracle Autonomous Database Cloud eliminates complexity, human error, and manual management, helping to ensure higher reliability, security, and more operational efficiency at the lowest cost.
At the previous paragraph I have highlighted the sentences “database cloud” & “Oracle Autonomous Database Cloud“, it means.. when we are talking about Cloud Databases, Oracle Autonomous Database Cloud is just another different kind of Cloud database service, so, in this article we will call it simply as “Cloud Databases”.
Autonomous Databases/Cloud Databases.. is a subject that could be analyzed from different points of views. Most of articles and publications focus in how ideal would be a futuristic database etc..
but Let’s think for a minute about Autonomous Databases..
Who will decide under what kind of service the databases will be.. ?
Who will implant the policies for those autonomous databases ?
Who will have the knowledge to decide or estimate the cost of these services based on the regular activities of those databases ?
Who will decide the complex design of IT Infrastructure when we have more and more options.. ?
The answer is obvious.. a DBA.. not any simple DBA.. a DBA that has evolved with all this new generation of databases on Cloud.
Oracle Autonomous Database as I mentioned before is a kind of different type of a Cloud Database Service. So.. in order to move that database from “On-prem” or create it from zero, a DBA must be needed..
Oracle Autonomous Database is a kind of database with a lot of mundane tasks already automated such as:
The more important section of this article is the following
I will use the exact smart words of my colleague Tim Hall ( Oracle ACE Director ) “18c on-prem will have very little impact on DBAs. It is the Autonomous Database suite of services that have the impact”
Most of DBAs currently are in fear believing “Autonomous Databases suite of Services” will let them without job.. but the reality is not even near to that.. actually there are several kind of services to lodge a database on Cloud:
“Autonomous Databases suite of Services” will represent just other possible services you could contract
Now, we will see some important points about Autonomous Databases that perhaps most of people does not know..
Oracle self driving database ( Autonomous Database ) will be available starting Oracle18c but there is still a huge period of support for 12cR1/R2. 12cR1 until 4 years more in comparison to this date, we are talking about until 2021 more or less..
12cR2 until April 2025 in extended support. As we know.. Customers normally are not moving so fast to a next release until they need it or until the support period is near to expire. So, Oracle 18c is a release that will be used for customers that really need it or by customers they want to be extreme up to date.
Up to now Oracle self driving database is designed to be run on Exadata, as per we know Exadata is an Engineering system very powerful but not cheap.. so.. most of customers for sure they will not be in Exadata.. it means.. Exadata has a high cost to be the regular hardware for most of regular medium companies around the world
So.. DBA’s no fear.. Oracle self driving database is not Oracle18c.. Oracle self driving database will not be the regular mechanism of your regular databases..
Then, important items to remember later of finishing to read this article:
So.. with those lines you have got the more important section of this article.
The conclusion is that “Oracle 18c” will have little impact for regular “On-prem” databases and databases services related to “self driving”
Now, Let’s extend this conversation..
But Let’s wait a minute.. Let’s analyze every one of those.. how it can be done today with the regular “Oracle Database Cloud Service (DBCS)” and how we think Oracle will do it.. We talk about “How Oracle will do it.. because the debut of Autonomous Datawarehouse Database Cloud will be in December 2017.
Applying of Patches: nowadays, if you want to apply a Patch using DBCS is just to go to the console, see on the screen if there is any available patch for that database and make some clicks to apply it.. So simple..
So.. I think is not “so difficult” for Oracle Corp, replace our clicks for an automated process..
There are some patches that require the database must be stopped because they change binaries.. etc.. well.. most probable Oracle had already a mechanism in order to apply patches having the database running and they have decided to release it now.. if we imagine how work the database inside running sequentially sentences.. etc.. every sentence.. operations.. etc all this can be coordinated so that patches affect in some way “post” sentences.. etc.. in a general way what I’m trying to say is.. the fact of applying patches by itself is not the big thing taking into account the level of development of the Oracle product during years.. So.. the applying patch by itself is just a step forward related to levels of automation.
Upgrades: Up to now when you are working with DBCS the only way to upgrade a database already working in the cloud is creating another service which will have another compute node and we apply a regular procedure to upgrade that database. However, we have to remember that Oracle has been working very hard in establish very advance mechanism to manage PDB. Nowadays we can clone PDB in hot, we can move PDBs from one container to another container in hot.. basically is very alike to the mechanism implanted to move a datafile online.. so.. this technology is extreme mature by the Oracle Software in these times.. So.. Upgrade a database must be surely a procedure a alike to what is done with PDB, the CDB in its root definition has the binaries of the corresponding version and we move just the data. I’m “sure”.. that’s the mechanism the Oracle software will use to upgrade databases in hot. So.. if we realise all I have commented.. all this is just a technology that we are using with the current release.. difference in autonomous databases is that they are applying this procedure with complete databases under this kind of new service.
Note : later of writing this article my colleague Tim Hall ( Oracle ACE Director ) had helped me to clarify that element, these are the exact words of Tim
“Oracle have explained how the upgrades and patches will work. These systems are based on 18c running on Exadata. Since 18c allows rolling upgrades and patches for everything, including OJVM, they are able to do online patches for these services“
Thanks Tim!!
Tunes itself: is even more easy to explain.. when you tune queries using adaptive technics.. etc.. all this can happen with the databases running.. rebuild indexes online.. etc.. must of tune operations nowadays can be done online.. it’s not so difficult to have an AI ( Artificial Intelligence ) engine collecting data and taking some decisions based on internal tests.. statistics.. etc.. so.. this new level of automation/autonomous is just what we have but being done automatically.
Let’s talk with what frequency we do these tasks:
Applying of Patches: time to time.. It’s not so frequent.. so.. there are not too much changes to appreciate in the time we employ in this task
Upgrades: even less.. it’s very seldom when we apply upgrades to the databases.. so.. there are not too much changes to appreciate in the time we employ in this task
Tunes itself: tuning.. yes.. many companies.. consultants.. etc.. employ a lot of time in constant tuning to databases for many reasons.. it’s very common that some objects.. some queries.. some code.. etc are added, removed.. changed in the database and of course this generate variations in the performance. This point could impact relatively highly the cost of many enterprises, because tuning a database constantly imply constant high costs. Of course.. we have to see how good the engine can be doing this. We have to remember that currently we have available “Tuning advisors” and they are not perfect.. sometimes we apply some recommendations and the performance of some executions.. etc.. become worst.. so.. the factor of “Tuning itself”.. really.. thinking very honest.. we have to see how that will work. If the results are very good and convenient.. definitely this factor will reduce a lot of cost to enterprises and of course will affect in some way DBAs specialized or in charge of tuning.
In December 2017 will be release the autonomous database service for Data warehouse, later on 2018 for OLTP and so on..
The tuning itself for Data Warehouse databases is easier than for OLTP Database according to my point of view. The typical and common operations.. ( Load.. queries.. etc ) are more common between them than for an OLTP database.
When you analize the conditions that will have autonomous databases for DW, you start to discover how it will work internally..
These are just some of them..
Automated Database Configuration for Autonomous DB for DW
• init.ora parameters
– Parameters optimized for DW workloads
– Memory, parallelism, sessions configured based on number of CPUs – Users can modify a limited set of parameters, e.g. NLS setttings
• Tablespace management
– Pre-defined data and temporary tablespaces – Users cannot create/modify tablespaces
• Compression
– All tables compressed using Hybrid Columnar Compression – Users cannot change compression method or disable compression
• Optimizer stats gathering
– Stats gathered automatically during direct load operations – Users can gather stats manually if they want
• Optimizer hints
– Hints ignored by default – Users can enable hints explicitly
• Result cache configuration
– Result cache enabled by default for all queries
and more.. I’ll talk more in detail about all this in an article dedicated to Autonomous DBs for DW.
Let’s come back a bit to the topic we were talking about automation and how enterprises can deal with that..
So.. one important thing to think.. You guess Enterprises with extreme important databases will allow to run all these tuning.. etc.. by itself without someone that can be monitoring what the database is doing.. ?
We are going to be honest.. Enterprises with critical databases will not allow to give the 100% of confidence to an engine software to tune itself on demand without control or supervision of a human. Of course, there are some databases.. under some levels of importance.. circumstances that fit that model.. to be tuned 100% without supervision but that not the regular cases.
That self tuning will have sections.. factor.. policies.. etc.. and DBAs will choose what elements could be tune by itself.. and which of them will keep under control of DBAs. At the end.. always DBAs will be needed.. Now DBAs will have more facilities to do their jobs more easy.. but that fact of thinking to replace totally the humans is something difficult to happen in spite of the engine can take correct decisions.
Let’s describe a simple example.. Oracle Data Guard has the option to FAILOVER automatically under some circumstances, but for some possible humans errors could happen a database can failover when the humans did not want it.. so.. most of enterprises they fear to use FSF ( Fast Start Failover ), It’s a mechanism that works perfect technically but to give the total control to the software to apply something critical to the data is something most of enterprises are not allow to implant.
In a general way I think autonomous databases will reduce tons of working hours for DBAs but will not represent in a practical and real way the elimination of Human presence.
So, autonomous databases promises the following:
Less time on Administration
– Less time on infrastructure
– Less time on patching, upgrades
– Less time on ensuring availability
– Less time on tuning
More time on Innovation
– More time on database design
– More time on data analytics
– More time on data polices
– and very important.. More time on securing data
So.. with databases on Cloud, DBAs must strength their skills in Security
Now Let’s jump to another point of analysis..
Future of DBAs related to Oracle Database Cloud
17 years ago.. it was so simple to design a database architecture. You had to decide to lodge your database in a:
Now, when DBAs will decide where to lodge databases must think in many options.. such as:
They have to decide if the architecture will be implanted:
and more and more..
Before was so simple to design a database architecture.. now not.. Now we have a lot of options.. each one with pros and cons. Basically is a sea of options..
So.. the question is.. Who will be in charge of designing all this.. ?
The General Managers ? obviously not.. this will be designed by Database Architects.. ( DBAs )
Now DBAs will be asked more to understand the business rather than just the mechanics of keeping the database healthy and running
Before the cost of Servers.. services.. etc.. was not the main thing with what DBAs had to deal.. they were focused just in keeping the database running and implanting them. Now is different.. , now creating a database in Cloud, for example.. implies a decision of what kind of service to use and in what mode.. “Metered.. Non-Metered..” etc.. those factors impact directly the economy of the enterprise and the mode of operating these databases, so.. now the DBAs are more related into the business.
Some years ago from the first minute Oracle Corp. announced the release of “Oracle Cloud”, another level of expertise for DBAs was born, turning this business more complex..
DBAs will not be fired.. now the roles of DBAs are even more important.. the role of DBAs is simply shifting to be more of a role of architect..
Who must worry because of all these changes.. ?
Those kind of operational DBAs who are or were in charge just of doing simple tasks.. such as:
– Checking Backups..
– Checking storage..
– Making some reports..
– Installing Patchs..
– Installing softwares..
– Creating constantly new environments for developers..
All those easy and simple tasks.. have been removing with the addition of automation in Oracle Releases..
For instance, now at the time of creating an Oracle Database Cloud Service, there are many elements created automatically including:
– The creation of compute node ( Host )
– Installation of Software
– and more..
Here you can see how simple can be create a disaster recovery configuration on Cloud using Data Guard:
#1 Oracle Cloud (DBaaS): Oracle Data Guard in Database Cloud Service ( DBCS )
So.. with just this simple example.. you can realise that at the time of working with Oracle Database Cloud Service you do not have to install softwares anymore..
If you want to create a RAC configuration in a using Oracle Database Cloud Service is just some simple clicks and you could have complex RAC-DG configurations.
The era of regular and boring tasks is getting away.. so.. if you are a DBA in charge of those kind of simple tasks.. yes.. worry about your future..
Contrary of this, if you are a DBA in charge of implanting MAA architectures.. Cloud Databases, Exadata.. etc.. happy for you.. the importance of your role now will be bigger..
So.. now we come back to the central point of this article..
you can imagine what will be the vision of a person that is starting as DBA with all these numerous options in the market.. A person that is barely learning SQL.. and “Create table..” etc.. when the market is talking about autonomous databases.. It’s a comparison like between a kid bike and one 1000cc Motorbike.. something like that..
My though about all this is:
#1.- DBAs with kind of regular maintenance tasks.. could be removing from their role or job if they do not evolve to be focused in all this new generation related to Cloud
#2.- DBAs that have got the privilege to work with Oracle Databases during the golden era of “On-prem” databases, now they are in the right time to grow in parallel with something that is defining the “before” and “after” of IT. Now the DBAs will have the opportunity to move into a more strategic role in their organisations and based on that the income “salary.. commissions.. etc” will be higher.. now you will be involved in important decisions for the company
#3.- Sorry for new DBAs entering in this database world.. the journey you have to run is even harder than before to get the top level in this area because day by day are generated more and more options
Conclusion
1.- If you are a DBA kind #1 according to the previous description, perhaps you have several options.. evolve to #2, or if you decide to stay in the same role, your payment could be less over time or your role could be slowly disappear.
2.- If you are a DBA kind #2, keep on the track.. and your role will be more and more important in this field, by consequence your payment will have high probabilities to be increased. One more thing.. most of DBAs will not reach to be Cloud architects because this require time of study.. researching.. testing.. etc.. so.. feel proud if you reach it and take advantage of that inside your current or future organizations
3.- If you are a DBA kind #3, do not give up.. do not see the journey too long as It really is, just keep learning and you will get the level to be a good competitor in the market.
Now, perhaps you have the question.. How I can start to get ready to administer databases on Cloud ?
I could tell you, go to https://www.oracle.com/cloud/index.html and start there..
The page is the starting point of that monster called “Oracle Cloud.. ( PaaS, IaaS, SaaS..) etc etc”, you could be lost easily.
If you are DBA and you are interested in managing databases on Cloud, my main recommendation is to follow the path to become OCP Cloud.
The OCP Cloud has the base and initial path of knowledge that every DBA must domain to work with databases on Cloud.
This article finish here. If you have liked, go down below and share it in your prefer social medias: LinkedIn, Facebook.. etc. Thanks!!
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
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
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Oracle Database 18c Now Available on Oracle Database Appliance..!!
Hi Readers
We are happy to announce the availability of Oracle Database 18c on Oracle Database Appliance. This Database Appliance release marks a new and exciting time, giving you the opportunity to start testing and using the new Oracle Database 18c functionality and improvements with your applications.
For Reading all the details about click the image or the link down below
For Reading Click here: https://blogs.oracle.com/oda/oracle-database-18c-oda
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Post 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
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Oracle 18c: 26 Remarkable new features of Oracle Database 18c..!!
By Joel Pérez ( Oracle ACE Director )
Oracle 18c was released in 2018-02-16, and now available on Cloud and Engineered Systems,Adhering to Oracle’s Cloud first philosophy
Now let’s take a look at the 18c new features which are important in our opinion.
(A) Availability
1. Oracle Data Guard Multi-Instance Redo Apply Supports Use of Block Change Tracking Files for RMAN Backups
Multiple-Instance Redo Apply (also known as MIRA) now supports BCT (Block Change Tracking) backups. This is an effective incremental backup method large database, and both master and slave are RAC, and the backup happens on the slave this kind of DB environment.
2. Automatic Correction of Non-logged Blocks at a Data Guard Standby Database
added two new standby logging modes (mainly to speed up the primary database loading data):
One is Standby Nologging for Data Availability, where the commit of a loading operation is delayed until all standby have applied data.
SQL> ALTER DATABASE SET STANDBY NOLOGGING FOR DATA AVAILABILITY;
One is Standby Nologging for Load Performance. This mode is similar to the previous one, but it will not send data when it encounters the network bottleneck during loading data. This guarantees the loading performance but may lose the data which can be obtained again from primary.
SQL> ALTER DATABASE SET STANDBY NOLOGGING FOR LOAD PERFORMANCE;
3. Shadow Lost Write Protection
Create a shadow tablespaces to provide data protection. With this feature you may not need ADG to provide additional lost write protection.
Do you notice that this feature like double write of the MySQL?
4. Backups from non-CDBs are usable after migration to CDB
The original non-CDB can be migrated as a PDB to the existing CDB with this new function.
5. Support for PDBs as Shards and Catalogs
finally, oracle shard could be a pdb.
However, it only supports a single pdb in a single cdb. What’s the point?
6. User-Defined Sharding Method
This feature once appeared in the beta version of 12.2 but canceled in the official release. Now it got released again.
7. Consistency Levels for Multi-Shard Queries
Provides the MULTISHARD_QUERY_DATA_CONSISTENCY initialization parameter, to avoid SCN synchronization during slicing across slices you can be set it before the execution
8. Manual termination of run-away queries
Now you can manually kill a statement without breaking the session:
ALTER SYSTEM CANCEL SQL.
ALTER SYSTEM CANCEL SQL ‘SID, SERIAL, @INST_ID, SQL_ID’;
(B) Big Data and Data Warehousing
9. Approximate Top-N Query Processing
Note: In 18c, APPROX_COUNT and APPROX_SUM were added to make full use of theAPPROX_RANK.
10. LOB support with IMC, Big Data SQL
the memory database start support LOB objects.
(C) Database Overall
11. Copying a PDB in an Oracle Data Guard Environment
Two new parameters have been added to facilitate the creation of PDBs in an ADG environment.
12. PDB Lockdown Profile Enhancements
PDB lockdown profiles can now be created in application root and CDB root.You can now create another pdb lockdown profile based on a pdb lockdown profile.18c contains three default lockdown profiles: PRIVATE_DBAAS, SAAS, PUBLIC_DBAAS
13. Refreshable PDB Switchover
PDB refresh has always been known as the ADG for the poor, this feature is now getting much better in 18c. Switchover is supported. The switchover is divided into two scenarios outside the planned kernel plan.
Planed switchover: it can be cut back and used mainly to balance the load of the CDB.
Unplanned switchover: mainly for the PDB master failure, do not switch the entire CDB.
14. PDB Snapshot Carousel
The pdb snapshot backup carousel, reserves 8 copies and is backed up every 24 hours by default.
ALTER PLUGGABLE DATABASE SNAPSHOT MODE EVERY 24 HOURS;
15. New Default Location of Oracle Database Password File
Note that the new password file path is already in ORACLE_BASE, not ORACLE_HOME.
16. Read-Only Oracle Home
You can use dbca or roohctl -enable to install read only oracle home.Run the orabasehomecommand to check if the current Oracle Home is read-only. If the output of this command is the same as $ORACLE_HOME, Oracle Home is read-write. If the output is ORACLE_BASE/homes/HOME_NAME, Oracle Home is read-only.
17. Online Merging of Partitions and Subpartitions
Supports online consolidation of partitions and the ONLINE keyword is required.
18. Concurrent SQL Execution with SQL Performance Analyzer
The SPA can run in parallel (by default, it is serial), helping you to complete the SPA test faster.
(D) Performance
19. Automatic In-Memory
this feature evicts the infrequently accessed IM columns out of memory in the situation of memory insufficiency, based on the Heat Map.
20. Database In-Memory Support for External Tables
External tables support IM features.
21. Memoptimized Rowstore
There is a memoptimize pool area in the SGA. The size is set by the MEMOPTIMIZE_POOL_SIZE parameter. When fast lookup is turned on, the memory area can be used for quick search.
Open fast lookup, need to add keywords in the table statement:
fast lookup would be used based on the primary key query
Memoptimized Rowstore will greatly improve the high-frequency query based on the primary key in the Internet of Things.
(E) RAC and Grid
22. ASM Database Cloning
You can clone pdb based on ASM. Use the flex diskgroup to achieve.
23. Converting Normal or High Redundancy Disk Groups to Flex Disk Groups without Restricted Mount
We think use the Flex disk groups is great.
(f) Security
24. Integration of Active Directory Services with Oracle Database
Combined with Microsoft’s AD.
Before 18c, interaction with Oracle Enterprise User Security (EUS) was required. Now, you can use the centrally managed users (CMU) to mappiing the AD users and groups directly with the Oracle users and roles.
(G) Others
25. Add initialization parameters:
ADG_ACCOUNT_INFO_TRACKING
FORWARD_LISTENER
INMEMORY_AUTOMATIC_LEVEL
INMEMORY_OPTIMIZED_ARITHMETIC
MEMOPTIMIZE_POOL_SIZE
MULTISHARD_QUERY_DATA_CONSISTENCY
OPTIMIZER_IGNORE_HINTS
OPTIMIZER_IGNORE_PARALLEL_HINTS
PARALLEL_MIN_DEGREE
PRIVATE_TEMP_TABLE_PREFIX
STANDBY_PDB_SOURCE_FILE_DBLINK
STANDBY_PDB_SOURCE_FILE_DIRECTORY
TDE_CONFIGURATION
UNIFIED_AUDIT_SYSTEMLOG
WALLET_ROOT
It’s worth mentioning OPTIMIZER_IGNORE_PARALLEL_HINTS. In a pure OLTP system, you can finally disable developers’ uncontrolled concurrency (often not writing concurrency). 🙂
26. dbms_session.sleep
Exec dbms_session.sleep(3);
Finally, it is no longer necessary to grant grants for dbms_lock separately.
Until here the article. Thanks for Reading!
Additionally you can read another article of us related to this same topic:
Oracle 18c: New Features for Oracle Data Guard.. What’s NEWS..
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Post 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
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Oracle 18c Download and New Feature Scalable Sequence..!!
By Eygle Gai ( Oracle ACE Director )
Oracle 18c has released and is currently available for download in the Oracle Edelivery website: https://edelivery.oracle.com.
Searching “Oracle Database” in the site, You can see the software media of the 18th edition,The current declared media is Exadata only, but it should be possible to install on non-Exadata Linux system platforms. OEL is Oracle’s best recommended support platform:
The current media contains three major files, the clients, software and Grid installation package. The first version of the Linux system is supported (Baidu Cloud shares a copy of software. Search The keyword ’18cNF’ these Files can found in the directory):
We have noticed an interesting feature: Extensible Sequence – Scalable Sequence
By specifying the SCALE clause in a CREATE SEQUENCE or ALTER SEQUENCE statement, you can make the sequence robustly extensible.
How is this feature implemented? What is it to solve?
Let’s review a online lesson of Andrew Holdsworth, who is the Vice President of the Oracle RWP team,In this video, Andrew mentioned the various index competitions encountered during optimization:
https://www.youtube.com/watch?v=wQNPQGUwjbs
Now let’s take a look at the definition of the scalable sequence in 18c:
The scalable sequence is defined by the following syntax:
When the SCALE statement is specified, a 6-digit number is specified as the sequence prefix, followed by the normal sequence number, and these two number are combined into a new sequence:
How do we get the 6-digit prefix? It is generated by instance number and session number:
So, this design is exact the same as Andrew’s previous description, which is exactly the guidance from practice that ultimately promoted the progress of Oracle database products.
Let’s do a little test:
drop sequence enmo_seq;
CREATE SEQUENCE enmo_seq INCREMENT BY 1 MAXVALUE 1000000 SCALE;
SELECT enmo_seq.nextval FROM dual;
Because there is a 6-bit prefix, the sequence must have a minimum length of 7 bits
Even with 7 bits, there will be only 9 available values for a single process connection:
ORA-64603: NEXTVAL cannot be instantiated for ENMO_SEQ. Widen the sequence by 1 digits or alter sequence with SCALE EXTEND.
through this sequential, data can be truly dispersed from different instances, and system has got the lower index competition, higher performance and scalable sequence as well.
Until here the article. Thanks for Reading!
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Post 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
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
18c PDB switchover
Hi Readers
In multitenant, the recovery and availability are at CDB level. But customers asked for a switchover at PDB level so Oracle has done that in 18c, based on refreshable PDBs. If you want to discover how to do it, read a great article about written by By Franck Pachot
For reading click the image or the link down below.
https://blog.dbi-services.com/18c-pdb-switchover/
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Post 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
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Oracle Database 18c – Some important changes
Hi Readers
If you want to read about some important new changes in Oracle Database 18c, read this great article written by Mike Dietrich. For Reading click the image or the link down below.
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Post 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
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Playing with 18c on Oracle Database Cloud Service – How to use and create a database STEP by STEP
Hi Readers
Most probable you have already experienced how to build a Cloud configuration with releases 11gR2, 12cR1, 12cR2.. have you done it with the new graphical interface and building your database in version 18c, if not.. come and read an article about it written by Francisco Muñoz ( Oracle ACE Director ). For reading click the image or the image down below.
Playing with 18c on Oracle Database Cloud Service – How to use and create a database STEP by STEP
We hope the content could useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Post 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
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
18c Merge Partitions Online..!! by Connor McDonald
Hi Readers
Sometimes we have problems merging partitions, if they are being used we get the typical ORA-00054: resource busy.. etc etc.. and we have to apply some other techniques to solve this problem, even causing others.. so.. watch this video done by Connor McDonald and see the how with the new ONLINE clause all this was improved. For watching, click the image or the link down below.
For watching, click the image or the link down below:
We hope the content could useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Post 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
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Oracle Database 18c Documentation Library.. Available..!!
Hi Readers
The new Oracle Database 18c Documentation Library is available.. so.. from now you can enjoy reading about the new features and more.. to access it, click the image or the link down below.
To read click here:
https://docs.oracle.com/en/database/oracle/oracle-database/18/index.html
We hope the content could useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Post 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
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Oracle 18c New Feature: “Read Only Oracle Home”.. !!
Hi Readers
An Oracle Home in just read only mode could useful for many scenarios, sometimes you need just an immutable image of the software that can be accesible as soon as possible. If you want to read more about this topic, read the article written by my colleague Franck Pachot ( Oracle ACE Director )
To read click the image or the link down below:
For Reading Click Here:
https://blog.dbi-services.com/18c-read-only-oracle-home/
We hope the content could useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Post 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
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Oracle Database 18c = Oracle Database 12c Release 2 12.2.0.2 ??
By Maria Colgan
Hi Readers
Oracle Database 18c = Oracle Database 12c Release 2 12.2.0.2 ??
The answer is yes.. the name has simply been changed to reflect the year in which the product is released. Most probable you are so eager to start to read about the new features with the official documentation and more.. so.. read this short and great article of Maria Colgan to get the starting links and more..
Today Oracle officially released Oracle Database 18c on the Oracle Public Cloud and Oracle Engineered Systems. This is the first version of the database to follow the new yearly release model and you can find more details on the release model change in the Oracle Support Document 2285040.1 .
Before you freak out about the fact you haven’t even upgraded 12.2, so how on earth are you ever going to get to 18c – Don’t Panic!
Oracle Database 18c is in fact “Oracle Database 12c Release 2 12.2.0.2”, the name has simply been changed to reflect the year in which the product is released.
So, what can you expect?
As you’d imagine a patchset doesn’t contain any seismic changes in functionality but there are lots of small but extremely useful incremental improvements, most of which focus on the three key marquee features in Oracle Database 12c Release2:
More details on what has changed in each of these areas and other improvements can be found in the Oracle Database blog post published by Dominic Giles this morning or in the video below with Penny Avril.
You can also read all about the new features in the 18c documentation and you can try out Oracle Database 18c on LiveSQL.
So, when will you be able to get your hands on 18c on-premises for non-engineered systems?
It will be some time later this calendar year. You can check the Oracle Support document 742060.1 for more details!
We hope the content could useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Post 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
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Oracle 18c: Data Warehousing New Features.. What’s NEWS..
Oracle 18c: Oracle Data Warehousing新功能一览
By Joel Peréz & Skant Gupta
This article is brought by en.enmotech.com
Data Warehousing will be the focus of the first Autonomous Database Service in Oracle 18c, so, this implies.. many new features will exist for this area.
Many people.. including me.. we are so eager to see how the autonomous conception will work on Data Warehouses since it was announced that a new Autonomous Database for Datawarehouse will be just a thing of load tables.. running queries and that’s it.. that’s what Oracle Corp. said and really we are so eager to see how close could be what we imagine in comparison to reality.
Meanwhile, let’s see some technical Oracle 18c New Features for Data Warehousing and you will start to realize how all this will be working..
Key 18c Features to Enhance Data Warehouses
DATABASE INFRASTRUCTURE
DATA MANAGEMENT
DATA PROCESSING
In-Memory Key Features
In-Memory For External Tables
Fast Analytics on External Data
Approximate Query Processing
Delivers significantly faster analysis for interactive and highly iterative data exploration
Top-N approximate aggregation
Top 5 blogs with approximate hits
Top 50 customers per region with approximate spending
Oracle Advanced Analytics in 18.1
Analytic Views
Analytic Views enhancements in 18.1
MDX Query Language with 18.1 Analytic Views
Polymorphic Tables: Self-Describing, Fully Dynamic SQL
Inline external tables
and more..
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
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
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Oracle 18c: RAC New Features.. What’s NEWS..
Oracle 18c: RAC新功能一览
By Joel Peréz & Skant Gupta
This article is brought by en.enmotech.com
Oracle Real Application Cluster 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.
Oracle EVP of Server Technologies Andy Mendelsohn said:
“We’re not going to do that with our SLAs,” he said. “We’re going to implement online patching using RAC rolling upgrades and use best practices on top of one of the most powerful and reliable platforms for running Oracle Database—Oracle Exadata.”
Oracle Autonomous Database Cloud will offer instant elasticity for databases. For Instance, now a customer can go from 8 cores of database computing to 16 cores to scale-up for end-of-quarter processing, then back down to the less expensive 8 cores. “We can do it instantly because our RAC technology lets you scale across clusters of servers very quickly, so we won’t have to move data around,” he said. “In order to grow its databases, Amazon has to move data to a new, bigger system and this can take hours or days”, he said. “That’s not truly elastic.” Mendelsohn envisioned a scenario using Oracle where, “you could even shut down all your compute CPUs over the weekend so you’re not paying for them, then start them up again on Monday morning,” he said. “That’s elastic.”
“Ask why customers run big transaction or operational systems on Oracle and their top reasons will probably be high availability, reliability, and scalability,” Mendelsohn said. These customers have grown to rely on technologies like Oracle Real Application Clusters (RAC), Oracle Active Data Guard, and Oracle’s Exadata database machine, which, he said, are unique to Oracle, “and are highly fault tolerant and scalable and that allow systems to run at 99.995 percent availability,” he said.
According to the last paragraphs, you could easily realise that Oracle RAC will be one of the key components related to the functioning of Autonomous Databases.
So.. Let’s see some technical points..
Oracle Real Application Cluster is one of the key components of Autonomous Databases for several reasons:
The DSC Management Service
Applied Machine Learning for Database Diagnostics
Zero Impact Patching
Never take down a database instance to patch Grid Infrastructure
Convert a Standalone Cluster to Member Cluster
Member Clusters = Standalone Cluster + Benefits
• A Member Cluster is a Standalone Cluster utilizing shared services on the Domain Services Cluster
• It automatically benefits from the management, TFA & RHP service.
– ASM services are opRonal – and can be utilizing as needed
Convert a Standalone Cluster to Member Cluster
Hang Manager
Resolving cross-layer hangs in the Cluster Domain
Hang Manager “manages” database process(es) that are not progressing
– Manage = detection and resolution
– Considers cross-layer hangs
• I.E: Hangs caused by a blocked ASM resource.
Resolving cross-layer hangs in the Cluster Domain
Up to now Oracle 18c is not still released so that we do not still too much information, however this article will be updated according to.
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
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
Oracle 18c: RMAN New Features.. What’s NEWS..
Oracle 18c: RMAN新功能一览
By Joel Peréz & Skant Gupta
This article is brought by en.enmotech.com
Oracle Recovery Manager, better known as “RMAN”. RMAN is one of those kind of tool that is present in almost the daily activities for regular DBAs.
With RMAN we can perform a lot of different kind of activities for different kind of objectives.
It’s impossible a DBA can not know tools such as: RMAN.. SQL*Plus.. expdp.. impdp.. etc.. those are part of the Oracle Software’s main core.
RMAN Beyond the Backup Utility, we can use it for:
So.. based on that.. no need to introduce the concept of what is RMAN..
Oracle Recovery Manager has a long history, let’s highlight briefly some about it:
Oracle 8, Oracle 8i, Oracle 9i ( 1997-2002 )
Oracle 10g, Oracle 11g ( 2003 – 2012 )
Oracle 12c ( Today )
Oracle Database 18c: Key RMAN Benefits/Enhancements
So.. Let’s star to see some technical new features of Oracle Recovery Manager in Oracle 18c..
18c: Multitenant DB Enhancement
Backup history preservation
RESTORE PLUGGABLE DATABASE <PDBNAME> FROM PREPLUGIN BACKUP;
RECOVER PLUGGABLE DATABASE <PDBNAME> FROM PREPLUGIN BACKUP;
ALTER PLUGGABLE DATABASE <PDBNAME> OPEN;
18c: Duplication Enhancements
Active Cross-CDB PDB Duplication
DUPLICATE PLUGGABLE DATABASE <PDBNAME> to <CDBNAME> FROM ACTIVE DATABASE;
18c: RMAN and Data Guard Enhancements
Active Data Guard Sync
RECOVER STANDBY DATABASE FROM SERVICE primary_db;
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
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
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Oracle 18c: New Features for Oracle Data Guard.. What’s NEWS..
Oracle 18c: Oracle Data Guard新功能一览
By Joel Peréz & Skant Gupta
This article is brought by en.enmotech.com
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 NETWORK CONFIGURATION
VALIDATE STATIC CONNECT IDENTIFIER
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:
– 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
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:
Transient tables useful for reporting applications
Global temporary tables
Persistent, shared (global) table definition
Temporary, private (session-based) data content
Private temporary tables (18c)Temporary, private (session-based) table definition
Temporary, private (session-based) data content
Executing DML on Active Data Guard
– DML Re-direction automatically performed from Active Data Guard standby to the Primary without compromising ACID
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
– Automatic, nothing to set up.
Control login attempts
– The ADG_ACCOUNT_INFO_TRACKING parameter extends the control of user account security information and reaction.
– ‘GLOBAL’ triggers the new secure behavior
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”
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
Active Data Guard
Review – Data Guard 12.2 New Features Summary
Data Guard
Active Data Guard
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
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
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Oracle 18c: Oracle 18c.. New Features.. What’s NEWS..
Oracle 18c 新功能一览
By Joel Peréz & Skant Gupta
This article is brought by en.enmotech.com
Well.. Oracle 18c.. one release more.. ? Uhmm perhaps not.. Oracle 18c has a that kind of air of.. “Starting now.. it’s when Oracle Cloud Database will mark a real strong beginning..”
I have been playing with Oracle Databases in Cloud from some years ago when all this was barely starting.. when it was more the concept of “Cloud Computing” as a whole.. I’m talking about when the Cloud Computing model was originally designed to be implanted “On-prem”, basically with an arrange of some servers.. software.. resources ( CPU.. Memory.. etc ) and all that could be managed by Enterprise Manager to built your own Cloud infrastructure but “On-prem”, that was around year 2013.. the service of Public Cloud was not still available in that time.. In that time we started to know concepts of “Pay-as-you-go..”.. “Chargeback..” and things like that.. the real concept of that first commercial proposal was really a model of “Cloud Computing”
In that time the concept of Oracle Database Cloud was extreme far from what it’s nowadays.. of course.. the product.. the concept was getting mature.. getting shape..
A couple of years later the first Public Cloud services appeared in the market.. year 2015.. Uhmm.. this was really a more close image of what we were having in mind about Oracle Database Cloud.. of course.. it was product that was changing all time.. and getting mature.. at the beginning even you could not choose the database character set.. the wizard interface had more steps.. and so on.. it was like a child opening his/her eyes to the world.. and we could enjoy how all that was growing..
Little by little more Oracle Database Cloud Services were starting to be available as per we have now:
All these lastly mentioned does not include the future new Oracle Database Cloud Services that will be available starting with Oracle 18c.
So.. continuing with the subject.. Oracle Database Cloud services were still changing/evolving.. even its web interface, pricing model, etc until the last months.. so.. it can be said the product was still modeling itself.. but internally we can consider it already a strong product.
So, according to my point of view, all that was a process to see how the product had interaction with real people.. with real customers.. with real companies.. All that was the preparation way to present finally the king product.. “Autonomous Database Suit of Services on Oracle18c..”, which is a great mix of all learned with Oracle Cloud Database Services and all years making better and better the auto-performance tuning techniques.. ( AWR, ADDM, Advisors.. etc )
So, I consider Oracle 18c and all its new feature a real “before and after” related to Cloud Databases..
Oracle 18c as every release.. has many new features.. that can be suitable for some kind of companies and others not too much.. as always.. perhaps a small company for sure will not be interested in autonomous database running in a powerful Exadata and so on.. Perhaps new “Startup” companies could be very interested in the regular “Oracle Database Cloud Service” to have a cheap and fast IT infrastructure.. not thinking as before how costly could be to establish an own data center.. etc..
So, the point it’s.. Oracle 18c as every release has new features for everyone..
The objective of this article is to name/to introduce them briefly before we can get the real production release starting December 2018.
Then, Let’s talk briefly technically of What’s news in Oracle Database 18c..
The figure you will see now is the Lifetime Support Commitments and Plans for current and future Oracle Releases.
*Oracle Database 19c is expected to the long term support release.
Always check MOS Note 742060.1 for the latest schedule.
As you can see between all that information, we will have extended support of 12.2 until 2025 and Oracle 18c will start on December2017. There are a lot of people in fear for the future for DBAs related to Autonomous Database & Oracle 18c, if you want to read my point of view about that subject go here:
#10 Oracle 18c: “Oracle 18c and its impact on DBAs”
Now, Let’s highlight briefly some of what we have today and what we will have in Oracle Database 18c
Performance
Today:
Oracle Database 18c:
Low Latency Memory Transactions
Non Volatile Memory Support
In-Memory Column Store Improvements
Memory Optimized Access for OLTP Workloads
Example: Read Joel’s Balance
Ultra-Fast key-based lookup:
New low latency client protocol with direct access to data engine
Performance benefits:
Memory Optimized Access for IoT Workloads
Example: Write Temperature Reading
New streaming ingest:
Performance:
2x faster throughput than conventional
Multitenant
Today:
Container managed database virtualization
Manage Many as one
Software as Service
Oracle Database 18c:
Example of
RMAN
https://blog.enmotech.com/2017/12/17/16-oracle-18c-rman-new-features-whats-news/
Oracle Data Guard
Oracle 18c: New Features for Oracle Data Guard.. What’s NEWS..
RAC
Availability
Today:
Comprehensive HA and disaster recovery functionality
Oracle Golden Gate for heterogeneous replication
Scale out and fault isolation with Oracle Database Sharding
Oracle Database 18c:
Zero Impact Grid Infrastructure Patching
Sharded RAC
Sharding improvements
Sharded RAC
Higher performance for shard-aware RAC applications
Affinitizes shards to RAC instances
Requests that don’t specify sharding key still work transparently
Gives Sharded Database performance with minimal application changes
Security
Today:
Security In-Depth
Key Vault
Audit Vault Database Firewall
Security Assessment Tool
Oracle Database 18c:
Integration with Active Directory
Per PDB Key storage
Password-less schema creation
Data Warehousing and Big Data
Today:
The most advanced analytics engine available today
Easily analyze data held in Hadoop with Big Data SQL
Big Data Appliance
Oracle Database 18c:
In-Memory for external tables
Automatic propagation of nologged data to standby
More Machine Learning algorithms
Polymorphic Table Functions
Alter Table Merge Partition Online
Approximate Query Improvements
Development
Today:
Application Express 5.1
SQL Developer & SQLCl
Comprehensive Language support
JSON
Oracle Database 18c:
Improved JSON Support
Property Graph Improvements
Rolling patches for OJVM
Private Temporary Tables
Private Temporary Tables
Transient tables useful for reporting applications
Global temporary tables
Persistent, shared (global) table definition
Temporary, private (session-based) data content
Private temporary tables (18c)
Temporary, private (session-based) table definition
Temporary, private (session-based) data content
Database Instance Management REST API
List the pdbs in the exadata database container: https://myserver.mydomain.com/ords/databases/exadata/pdbs
Official Docker Support
Oracle Database is fully supported on Docker for
** Oracle RAC is not supported on Docker “CURRENTLY” but in Oracle 18c Oracle RAC support is coming
MOS Note: Oracle Support for Database Running on Docker (Doc ID 2216342.1)
Oracle 12.2.0.1 & 12.1.0.2 images are available on Oracle Container Registry
Docker build files also available at
New Installation Approaches
Zip file, TAR File, Docker Image, Virtual Box, VM (Ravello, BMC, Vbox)
Oracle Installation via RPM
Oracle Database 18c XE
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
Follow us in Enmotech LinkedIn Page: https://www.linkedin.com/company/1856106/
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
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
By Joel Peréz & Skant Gupta
“DBAs will be fired.. ? It’s the end of DBAs because of the Autonomous Databases..?
Obviously not.. believe it or not.. now the DBAs will have more important role in enterprises.
Later of completing the reading of this article you could read more about new features related to Oracle18c:
Oracle 18c: Oracle 18c.. New Features.. What’s NEWS..
https://blog.enmotech.com/2017/12/17/14-oracle-18c-oracle-18c-new-features-whats-news/
Oracle 18c: New Features for Oracle Data Guard.. What’s NEWS..
https://blog.enmotech.com/2017/12/17/15-oracle-18c-new-features-for-oracle-data-guard-whats-news/
Oracle 18c: RMAN New Features.. What’s NEWS..
https://blog.enmotech.com/2017/12/17/16-oracle-18c-rman-new-features-whats-news/
Oracle 18c: RAC New Features.. What’s NEWS..
https://blog.enmotech.com/2017/12/17/17-oracle-18c-rac-new-features-whats-news/
Oracle 18c: Data Warehousing New Features.. What’s NEWS.
https://blog.enmotech.com/2017/12/17/18-oracle-18c-data-warehousing-new-features-whats-news/
Now, Let’s continue with the article..
I have +17 years as Oracle DBA and I could tell you how this profession have been evolving, having a tendency of:
Oracle Database 18c the next generation of the industry-leading database.
Oracle introduces the world’s first autonomous database cloud. Oracle Autonomous Database Cloud eliminates complexity, human error, and manual management, helping to ensure higher reliability, security, and more operational efficiency at the lowest cost.
At the previous paragraph I have highlighted the sentences “database cloud” & “Oracle Autonomous Database Cloud“, it means.. when we are talking about Cloud Databases, Oracle Autonomous Database Cloud is just another different kind of Cloud database service, so, in this article we will call it simply as “Cloud Databases”.
Autonomous Databases/Cloud Databases.. is a subject that could be analyzed from different points of views. Most of articles and publications focus in how ideal would be a futuristic database etc..
but Let’s think for a minute about Autonomous Databases..
Who will decide under what kind of service the databases will be.. ?
Who will implant the policies for those autonomous databases ?
Who will have the knowledge to decide or estimate the cost of these services based on the regular activities of those databases ?
Who will decide the complex design of IT Infrastructure when we have more and more options.. ?
The answer is obvious.. a DBA.. not any simple DBA.. a DBA that has evolved with all this new generation of databases on Cloud.
Oracle Autonomous Database as I mentioned before is a kind of different type of a Cloud Database Service. So.. in order to move that database from “On-prem” or create it from zero, a DBA must be needed..
Oracle Autonomous Database is a kind of database with a lot of mundane tasks already automated such as:
The more important section of this article is the following
I will use the exact smart words of my colleague Tim Hall ( Oracle ACE Director ) “18c on-prem will have very little impact on DBAs. It is the Autonomous Database suite of services that have the impact”
Most of DBAs currently are in fear believing “Autonomous Databases suite of Services” will let them without job.. but the reality is not even near to that.. actually there are several kind of services to lodge a database on Cloud:
“Autonomous Databases suite of Services” will represent just other possible services you could contract
Now, we will see some important points about Autonomous Databases that perhaps most of people does not know..
Oracle self driving database ( Autonomous Database ) will be available starting Oracle18c but there is still a huge period of support for 12cR1/R2. 12cR1 until 4 years more in comparison to this date, we are talking about until 2021 more or less..
12cR2 until April 2025 in extended support. As we know.. Customers normally are not moving so fast to a next release until they need it or until the support period is near to expire. So, Oracle 18c is a release that will be used for customers that really need it or by customers they want to be extreme up to date.
Up to now Oracle self driving database is designed to be run on Exadata, as per we know Exadata is an Engineering system very powerful but not cheap.. so.. most of customers for sure they will not be in Exadata.. it means.. Exadata has a high cost to be the regular hardware for most of regular medium companies around the world
So.. DBA’s no fear.. Oracle self driving database is not Oracle18c.. Oracle self driving database will not be the regular mechanism of your regular databases..
Then, important items to remember later of finishing to read this article:
So.. with those lines you have got the more important section of this article.
The conclusion is that “Oracle 18c” will have little impact for regular “On-prem” databases and databases services related to “self driving”
Now, Let’s extend this conversation..
But Let’s wait a minute.. Let’s analyze every one of those.. how it can be done today with the regular “Oracle Database Cloud Service (DBCS)” and how we think Oracle will do it.. We talk about “How Oracle will do it.. because the debut of Autonomous Datawarehouse Database Cloud will be in December 2017.
Applying of Patches: nowadays, if you want to apply a Patch using DBCS is just to go to the console, see on the screen if there is any available patch for that database and make some clicks to apply it.. So simple..
So.. I think is not “so difficult” for Oracle Corp, replace our clicks for an automated process..
There are some patches that require the database must be stopped because they change binaries.. etc.. well.. most probable Oracle had already a mechanism in order to apply patches having the database running and they have decided to release it now.. if we imagine how work the database inside running sequentially sentences.. etc.. every sentence.. operations.. etc all this can be coordinated so that patches affect in some way “post” sentences.. etc.. in a general way what I’m trying to say is.. the fact of applying patches by itself is not the big thing taking into account the level of development of the Oracle product during years.. So.. the applying patch by itself is just a step forward related to levels of automation.
Upgrades: Up to now when you are working with DBCS the only way to upgrade a database already working in the cloud is creating another service which will have another compute node and we apply a regular procedure to upgrade that database. However, we have to remember that Oracle has been working very hard in establish very advance mechanism to manage PDB. Nowadays we can clone PDB in hot, we can move PDBs from one container to another container in hot.. basically is very alike to the mechanism implanted to move a datafile online.. so.. this technology is extreme mature by the Oracle Software in these times.. So.. Upgrade a database must be surely a procedure a alike to what is done with PDB, the CDB in its root definition has the binaries of the corresponding version and we move just the data. I’m “sure”.. that’s the mechanism the Oracle software will use to upgrade databases in hot. So.. if we realise all I have commented.. all this is just a technology that we are using with the current release.. difference in autonomous databases is that they are applying this procedure with complete databases under this kind of new service.
Note : later of writing this article my colleague Tim Hall ( Oracle ACE Director ) had helped me to clarify that element, these are the exact words of Tim
“Oracle have explained how the upgrades and patches will work. These systems are based on 18c running on Exadata. Since 18c allows rolling upgrades and patches for everything, including OJVM, they are able to do online patches for these services“
Thanks Tim!!
Tunes itself: is even more easy to explain.. when you tune queries using adaptive technics.. etc.. all this can happen with the databases running.. rebuild indexes online.. etc.. must of tune operations nowadays can be done online.. it’s not so difficult to have an AI ( Artificial Intelligence ) engine collecting data and taking some decisions based on internal tests.. statistics.. etc.. so.. this new level of automation/autonomous is just what we have but being done automatically.
Let’s talk with what frequency we do these tasks:
Applying of Patches: time to time.. It’s not so frequent.. so.. there are not too much changes to appreciate in the time we employ in this task
Upgrades: even less.. it’s very seldom when we apply upgrades to the databases.. so.. there are not too much changes to appreciate in the time we employ in this task
Tunes itself: tuning.. yes.. many companies.. consultants.. etc.. employ a lot of time in constant tuning to databases for many reasons.. it’s very common that some objects.. some queries.. some code.. etc are added, removed.. changed in the database and of course this generate variations in the performance. This point could impact relatively highly the cost of many enterprises, because tuning a database constantly imply constant high costs. Of course.. we have to see how good the engine can be doing this. We have to remember that currently we have available “Tuning advisors” and they are not perfect.. sometimes we apply some recommendations and the performance of some executions.. etc.. become worst.. so.. the factor of “Tuning itself”.. really.. thinking very honest.. we have to see how that will work. If the results are very good and convenient.. definitely this factor will reduce a lot of cost to enterprises and of course will affect in some way DBAs specialized or in charge of tuning.
In December 2017 will be release the autonomous database service for Data warehouse, later on 2018 for OLTP and so on..
The tuning itself for Data Warehouse databases is easier than for OLTP Database according to my point of view. The typical and common operations.. ( Load.. queries.. etc ) are more common between them than for an OLTP database.
When you analize the conditions that will have autonomous databases for DW, you start to discover how it will work internally..
These are just some of them..
Automated Database Configuration for Autonomous DB for DW
• init.ora parameters
– Parameters optimized for DW workloads
– Memory, parallelism, sessions configured based on number of CPUs – Users can modify a limited set of parameters, e.g. NLS setttings
• Tablespace management
– Pre-defined data and temporary tablespaces – Users cannot create/modify tablespaces
• Compression
– All tables compressed using Hybrid Columnar Compression – Users cannot change compression method or disable compression
• Optimizer stats gathering
– Stats gathered automatically during direct load operations – Users can gather stats manually if they want
• Optimizer hints
– Hints ignored by default – Users can enable hints explicitly
• Result cache configuration
– Result cache enabled by default for all queries
and more.. I’ll talk more in detail about all this in an article dedicated to Autonomous DBs for DW.
Let’s come back a bit to the topic we were talking about automation and how enterprises can deal with that..
So.. one important thing to think.. You guess Enterprises with extreme important databases will allow to run all these tuning.. etc.. by itself without someone that can be monitoring what the database is doing.. ?
We are going to be honest.. Enterprises with critical databases will not allow to give the 100% of confidence to an engine software to tune itself on demand without control or supervision of a human. Of course, there are some databases.. under some levels of importance.. circumstances that fit that model.. to be tuned 100% without supervision but that not the regular cases.
That self tuning will have sections.. factor.. policies.. etc.. and DBAs will choose what elements could be tune by itself.. and which of them will keep under control of DBAs. At the end.. always DBAs will be needed.. Now DBAs will have more facilities to do their jobs more easy.. but that fact of thinking to replace totally the humans is something difficult to happen in spite of the engine can take correct decisions.
Let’s describe a simple example.. Oracle Data Guard has the option to FAILOVER automatically under some circumstances, but for some possible humans errors could happen a database can failover when the humans did not want it.. so.. most of enterprises they fear to use FSF ( Fast Start Failover ), It’s a mechanism that works perfect technically but to give the total control to the software to apply something critical to the data is something most of enterprises are not allow to implant.
In a general way I think autonomous databases will reduce tons of working hours for DBAs but will not represent in a practical and real way the elimination of Human presence.
So, autonomous databases promises the following:
Less time on Administration
– Less time on infrastructure
– Less time on patching, upgrades
– Less time on ensuring availability
– Less time on tuning
More time on Innovation
– More time on database design
– More time on data analytics
– More time on data polices
– and very important.. More time on securing data
So.. with databases on Cloud, DBAs must strength their skills in Security
Now Let’s jump to another point of analysis..
Future of DBAs related to Oracle Database Cloud
17 years ago.. it was so simple to design a database architecture. You had to decide to lodge your database in a:
Now, when DBAs will decide where to lodge databases must think in many options.. such as:
They have to decide if the architecture will be implanted:
and more and more..
Before was so simple to design a database architecture.. now not.. Now we have a lot of options.. each one with pros and cons. Basically is a sea of options..
So.. the question is.. Who will be in charge of designing all this.. ?
The General Managers ? obviously not.. this will be designed by Database Architects.. ( DBAs )
Now DBAs will be asked more to understand the business rather than just the mechanics of keeping the database healthy and running
Before the cost of Servers.. services.. etc.. was not the main thing with what DBAs had to deal.. they were focused just in keeping the database running and implanting them. Now is different.. , now creating a database in Cloud, for example.. implies a decision of what kind of service to use and in what mode.. “Metered.. Non-Metered..” etc.. those factors impact directly the economy of the enterprise and the mode of operating these databases, so.. now the DBAs are more related into the business.
Some years ago from the first minute Oracle Corp. announced the release of “Oracle Cloud”, another level of expertise for DBAs was born, turning this business more complex..
DBAs will not be fired.. now the roles of DBAs are even more important.. the role of DBAs is simply shifting to be more of a role of architect..
Who must worry because of all these changes.. ?
Those kind of operational DBAs who are or were in charge just of doing simple tasks.. such as:
– Checking Backups..
– Checking storage..
– Making some reports..
– Installing Patchs..
– Installing softwares..
– Creating constantly new environments for developers..
All those easy and simple tasks.. have been removing with the addition of automation in Oracle Releases..
For instance, now at the time of creating an Oracle Database Cloud Service, there are many elements created automatically including:
– The creation of compute node ( Host )
– Installation of Software
– and more..
Here you can see how simple can be create a disaster recovery configuration on Cloud using Data Guard:
#1 Oracle Cloud (DBaaS): Oracle Data Guard in Database Cloud Service ( DBCS )
So.. with just this simple example.. you can realise that at the time of working with Oracle Database Cloud Service you do not have to install softwares anymore..
If you want to create a RAC configuration in a using Oracle Database Cloud Service is just some simple clicks and you could have complex RAC-DG configurations.
The era of regular and boring tasks is getting away.. so.. if you are a DBA in charge of those kind of simple tasks.. yes.. worry about your future..
Contrary of this, if you are a DBA in charge of implanting MAA architectures.. Cloud Databases, Exadata.. etc.. happy for you.. the importance of your role now will be bigger..
So.. now we come back to the central point of this article..
you can imagine what will be the vision of a person that is starting as DBA with all these numerous options in the market.. A person that is barely learning SQL.. and “Create table..” etc.. when the market is talking about autonomous databases.. It’s a comparison like between a kid bike and one 1000cc Motorbike.. something like that..
My though about all this is:
#1.- DBAs with kind of regular maintenance tasks.. could be removing from their role or job if they do not evolve to be focused in all this new generation related to Cloud
#2.- DBAs that have got the privilege to work with Oracle Databases during the golden era of “On-prem” databases, now they are in the right time to grow in parallel with something that is defining the “before” and “after” of IT. Now the DBAs will have the opportunity to move into a more strategic role in their organisations and based on that the income “salary.. commissions.. etc” will be higher.. now you will be involved in important decisions for the company
#3.- Sorry for new DBAs entering in this database world.. the journey you have to run is even harder than before to get the top level in this area because day by day are generated more and more options
Conclusion
1.- If you are a DBA kind #1 according to the previous description, perhaps you have several options.. evolve to #2, or if you decide to stay in the same role, your payment could be less over time or your role could be slowly disappear.
2.- If you are a DBA kind #2, keep on the track.. and your role will be more and more important in this field, by consequence your payment will have high probabilities to be increased. One more thing.. most of DBAs will not reach to be Cloud architects because this require time of study.. researching.. testing.. etc.. so.. feel proud if you reach it and take advantage of that inside your current or future organizations
3.- If you are a DBA kind #3, do not give up.. do not see the journey too long as It really is, just keep learning and you will get the level to be a good competitor in the market.
Now, perhaps you have the question.. How I can start to get ready to administer databases on Cloud ?
I could tell you, go to https://www.oracle.com/cloud/index.html and start there..
The page is the starting point of that monster called “Oracle Cloud.. ( PaaS, IaaS, SaaS..) etc etc”, you could be lost easily.
If you are DBA and you are interested in managing databases on Cloud, my main recommendation is to follow the path to become OCP Cloud.
The OCP Cloud has the base and initial path of knowledge that every DBA must domain to work with databases on Cloud.
This article finish here. If you have liked, go down below and share it in your prefer social medias: LinkedIn, Facebook.. etc. Thanks!!
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
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
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Oracle Database 19c: The best upcoming features..!!
By Rodrigo Jorge
Hi Readers
In the Oracle Open World 2018 event that happened in San Francisco last week, from October 22nd to 25th, much has been said about the trends and strategy paths that Oracle is taking in both OCI and in Oracle Database.
As we DBA’s are always excited about the upcoming features, We will share below some of the main things that I’ve spotted on OOW. Please note that this can change, and we don’t even have a beta release yet.
First of all, it was very clear that Oracle’s main focus for the 19c database will be stability. This will be the final release for the “12cR2” family. So it was repeated multiple times: “don’t expect to see many new features in this release“, what in my opinion is really great.
Since 12.1.0.1, Oracle has been implementing a lot of core changes in Oracle Database (like multi-tenancy, unified audit, etc) and it’s still very hard nowadays to find a stable 12 release to recommend. 12.1.0.2 is my favorite one, however many bugs are unfixed and it lacks a secure PDB layout (PDB escape techniques are pretty easy to explore). 18c will probably be ignored by all as it was a “transition” release, so I hope that 19c becomes the real stable one, as 11.2.0.4 was for 11g release family. Let’s see…
This is indeed the most important and one of the coolest features I’ve even seen in Oracle DB. Once this kind of automation is implemented and released, it will open doors to many other product automations (like automatic table reorganization, automatic table encryption or anything you can imagine).
The automatic indexing methodology will be based on a common approach to manual SQL Tuning. Oracle will capture the SQL statements, identify the candidate indexes and evaluates the ones that will benefit those statements. The whole process is not something simple.
Basically, Oracle will first create those indexes as unusable and invisible (metadata only). Then, outside the application workflow, oracle will ask the optimizer to test if those candidate indexes improve the SQL performance. In case the performance is better for all statements when indexed is used, it will become visible. If performance is worse, it remains invisible. And if it only performs better for some statements, the index is only marked visible for those SQLs (via SQL Patch, maybe).
The automation will also drop the indexes that become obsoleted by the newly created indexes (logical merge) and also remove the indexes that were created automatically but have not been used in a long time. Everything is customizable. For more details, we need to wait for the Beta Release!
to read the rest of the article, click here:
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Oracle Resource Manager – Oracle Autonomous Data Warehouse..!! By Vivek Sharma
I recently presented a Full Day Tech Event on Autonomous databases (ADB) for the North India Chapter of All India Oracle User Group. Since most of the attendees were Database Administrators, it was important to cover technical aspects of ADB. While Oracle doesn’t publicize the Internals of ADB, I spoke about some of my experiences based on many of POC’s.
Many DBA’s still assume that 18c Database is Autonomous? Therefore it is Important to know What is Autonomous Database and What it is not? First thing to note is that 18c is not Autonomous. 18c is just like any other Oracle Database. Autonomous uses the features of Oracle Database 18c, plus 12c, plus 11g, plus 10g and so on. Autonomous Database ensures that all these features work together. So, 18c is one of the Building Blocks of 18c. Autonomous uses all the features that Oracle Developed for almost 2 decades. The other important underlying technology is Oracle Exadata, which is the fastest Oracle Database Machine with redundancy built-in at each layer. Again, Oracle had been working on many features that makes this machine a powerful database machine, in terms of Performance, Reliability and Scalability. The Journey had been long from Smart Scans to Direct-to-wire protocol to Smart Fusion Block Transfer and the enhancements continue. One important thing to note is – Customers do have an option to move to 18c on Exadata within their own Data Centre. Then does it mean, this combination is Autonomous? The answer is NO. The two components are critical, but what makes it Autonomous is the Cloud Automation with Machine Learning.
During the session, I covered the Performance features and the way Oracle controls resource utilization. The topic that came up was Oracle Database Resource Managers. Database Administrators were more inquisitive to know more about this and how it is been implemented in ADB.
to continue reading click the original article down below:
Resource Manager – Autonomous Data Warehouse
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
All current Oracle databases have an upper limit on the SCN according to Oracle’s kernel design, the upper limit is the second’s difference between the current time and 1988/01/01 then times 16k.
For some specified high version database (11.1.0.7.20, 11.2.0.3.9, 11.2.0.4.*, 12.1.0.2 and above), the current value of this limit is calculated by the algorithm whose main factor is SCN COMPATIBILITY. Through this parameter,the value of SCN won’t exceed the upper limit, and DB Link between databases works well.
However, the SCN COMPATIBILITY of these high version database will be adjusted from 1 to 3 after June 23, 2019, meaning the maximum growth rate will reach 96k, which may result in the situation that the upper limit of high-version DB is much higher than the low-version databases.so when that happens, Low version database cannot connect with high version through DB Link.
Then what do we do?
Basically, the exact version of DB and PSU information can help you to distinguish these two kinds of Database.The high-version database includes the following:
all the other versions are lower versions, including:
If the accurate PSU is known, you can also check the DBMS_SCN package. For in the highversion,Oracle introduces the features of SCN Compatibility, and which is managed by DBMS_SCN package, so if DBMS_SCN package exists, the database is high version.
use the following SQL to find out:
Select count(*) from dba_objects
Where
owner = ‘SYS’ and object_name =’DBMS_SCN’ and object_type=’PACKAGE BODY’;
COUNT(*)
———-
1
If the SQL return 1, it proves the DB is a high version, otherwise a low version. For a higher version database, the current SCN Compatibility information can be obtained by calling DBMS_SCN with the following code.
Set serverout on
declare
v_autorollover_date date;
v_target_compat number;
v_RSL number;
v_hr_in_scn number;
v_hr_in_sec number;
v_t4 number;
v_max_cmpat number;
v_isenabled boolean;
v_current_compat number;
begin
dbms_scn.GETCURRENTSCNPARAMS(
v_RSL,v_hr_in_scn,v_hr_in_sec,v_current_compat,v_max_cmpat);
dbms_scn.GETSCNAUTOROLLOVERPARAMS(
v_autorollover_date,v_target_compat,v_isenabled);
dbms_output.put_line(‘Current SCN compatibility:’||v_current_compat);
dbms_output.put_line(‘Current SCN RATE:’||round((v_hr_in_scn/v_hr_in_sec)/1024)||’k’);
if(v_isenabled) then
dbms_output.put_line(‘AUTO SCN compatibility rollover is ENABLED!!!’);
dbms_output.put_line(‘AUTO rollover time:’||to_char(v_date,’YYYY/MM/DD’));
dbms_output.put_line(‘AUTO rollover target value:’||v_target_compat );
else
dbms_output.put_line(‘AUTO SCN compatibility rollover is DISABLED!!!’);
end if;
end;
/
If no changes have been made, then the Current SCN compatibility is 1 and AUTO rollover is enabled, the time is 2019, 06/23, and the target is 3.
For older databases, we can assume the SCN compatibility is 1.
According to the upper limit algorithm of Oracle’s SCN, the upper limit of 16k speed and 96k speed is obviously different.
If some of the databases automatically change SCN Compatibility to 3 on 2019/06/23, then the SCN limit of these databases will become 3.5E13 or higher soon, and those have not changed will stay between 1.8E13 and 2E13 for 10 years.
Imagine this: the SCN Compatibility = 3 in one database, and SCN abnormal increase due to certain reasons (bugs, manual settings, etc.), and the value exceeds the SCN ceiling with whose rate is 16k if DB Link communication between two data is required, the mutual SCN will equivalent to the higher one, and then value exceeds the upper limit, DB Link communication will fail.
To sum up, the SCN issue usually doesn’t occur unless all the following factors are met:
A. The SCN Compatibility between the two databases is inconsistent.
B. Abnormal growth happens in the Database with high SCN compatibility, and exceeds the upper limit value of databases with low SCN Compatibility
C. These two kinds of databases connected through the DBLink.
To avoid the above problem, the most thorough approach is to unify the SCN Compatibility. There are four situations:
1、If you decide to keep the overall environment in the SCN Compatibility=1 after 2019/06/23, you need to disable the SCN Compatibility Auto–Rollover function of the new version of the database before 2019/06/23.
Note: the following actions are risky and it is not recommended to do it by yourself.
Begin
DBMS_SCN.DISABLEAUTOROLLOVER;
end;
/
The following information will appear in the Alert log
Fri Mar 16 17:15:15 2018
Database SCN compatibility auto-rollover disaedbl
You can also check this by running the script of the second chapter, the expected output is:
AUTO SCN compatibility rollover is DISABLED!!!
2、If you decide to keep the entire environment in the SCN compatibility=1 state, then you also need to pay attention to the database added after 2019/06/23, it needs to be manually changed to SCN compatibility=1 to alter the default value, this operation needs to be performed in the Mount state, as follows.
Begin
DBMS_SCN.DISABLEAUTOROLLOVER;
end;
/
shutdown immediate
startup mount
alter database set SCN COMPATIBILITY 1;
The following information will appear in the Alert log
Completed: alter database set scn compatibility 1
Oracle Support document:
Oracle Databases Need to be Patched to a Minimum Patchset/PSU/RU level before April 2019 (Doc ID 2361478.1)
Mandatory Patching Requirement for Database Versions 11.2.0.3 or Earlier, Using DB Links (Doc ID 2335265.1)
The article finishes here!
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Post 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
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Warning:Oracle Databases Need to be Patched to a Minimum Patchset/PSU/RU level before April 2019
By Eygle Gai ( Oracle ACE Director )
There are two warning articles which were recently released on Oracle‘s official support site My Oracle Support, have caused widespread concern among users of Oracle Database.
Those two articles’ ID are respectively 2361478.1 and 2335265.1
Different from normal reports or news for oracle users, Oracle point the exact version(11.2.0.3), and specific deadline(before April 2019) for certain Database scenarios(Using DB Links) and operations(Patch)and use the strong word( Mandatory) in the title,make it necessary for oracle users to put it into schedule as the deadline is not so far.
After those two articles were published, many users wondered:
How does Oracle trigger this problem after April 2019, how come the exact time point, could it be a time trigger that Oracle laid into the database?
We did a little research and find out this time constraint does exist, but the real trigger time is: June 23, 2019. (about the time difference, we’ll explain it later)
now, let us analyze it step by step.
As we can see, the document 2361478.1 was created and published on the site on February 15, 2018
We may remember that on February 16, 2018, the Oracle 18c database was released,
(referring to: Oracle 18c database has been released and new features introduced)
which means this document was released with the new version Oracle 18c, and the new features of 18c can lead to major changes of Oracle Internal mechanism.
Let’s look at some key contents of this article:
What we are announcing:
All supported releases of Oracle Databases need to be patched to a minimum patchset/PSU level before April 2019 to ensure proper functioning of database links.
Scope of impact: 12.2.0.1 and later versions are not affected, the 11.2.0.4 and 12.1.0.2 patch sets already contain the necessary fixes, and the released patches are available for versions 11.1.0.7 and 11.2.0.3.
Other versions have no patches and need to be upgraded, otherwise there may be problems when connecting other libraries of lower versions and new versions through DB Link.
What changes have caused this effect? The document explain it briefly and effectively as following:
What is the change introduced by the patches listed above?
The patches listed above make the older databases capable of supporting increased SCN soft limit (i.e. support transactions with higher SCN rate) though the increased SCN soft limit only becomes effective later (after April 2019).
Simply put,the algorithm of the SCN needs to be altered, the growth rate to be specific. That way, when data is accessed in multi-DB environment through DB link, the lower and higherversions must use the same algorithm to ensure that the DB Link access is working well.
In those articles, the term “Soft Limit” was described as follows. In the Oracle 11.2.0.2 and before, the threshold of this value 16K,
“At any point in time, the Oracle Database calculates a “not to exceed” limit for the SCN a database can have used, based on the number of seconds elapsed since 1988, multiplied by 16,384. This is known as the ‘Soft Limit’. If the soft limit is likely to be exceeded in the next SCN increment, then Oracle will issue an ORA-0600 error and the process will be cancelled.”
Once the SCN exhausted, problem appeared and the threshold would rise to 32K:
I wrote a article explain how SCN works and may cause problems in the situation of DBlink, you can access that in my blog(www.eygle.com). It works like this: the data query via DB Link will synchronize the SCN of the database. This leads to many Headroom issues that when SCN runs out:
[oracle@jumper oracle]$ sqlplus “/ as sysdba“
SQL*Plus: Release 9.2.0.4.0 – Production on Tue Nov 7 21:07:56 2006
SQL> select dbms_flashback.GET_SYSTEM_CHANGE_NUMBER scn from dual;
SCN
—————
5287824
What would happen then?
Some of the clues can already be seen in 18c. This new feature was introduced in official document as following:
Consistency Levels for Multi-Shard Queries
You can specify different consistency levels for queries across multiple shards in a shardeddatabase. For example, you might want some queries to avoid the cost of SCN synchronization across shards, and these shards could be globally distributed. Another use case is when you use standbys for replication and slightly stale data is acceptable for cross-shard queries, as the results could be fetched from the primary and its standbys. You can use the initialization parameter MULTISHARD_QUERY_DATA_CONSISTENCY to set different consistency levels when executing multi-shard queries across shards.
This feature enables you to avoid the cost of SCN synchronization while executing multi-shard queries across shards and these shards potentially could be distributed globally.
For multi-shard queries, this feature allows slightly stale data from the standby databases.
This feature is currently targeted at the Oracle Sharding database, which means that the cost of SCN synchronization can be avoided in cross-Shard queries.
what does this really mean?
Many customers have been asking questions, which exact BUG should be repaired? Oracle did not answer it in the documentation directly, but it proposes the minimum patch requirements, and different versions of the patch application matrix:
What is the exact minimum patch set we are talking about in this list?
After analyzing, we finally confirmed that the BUG is 14121009, for the minimum patch required to be applied by April 2019 has the exactly same version with the BUG 14121009,Such as 11.2.0.3.9, 11.1.0.7.20, and Windows 11.2.0.3 Patch 28, 11.1.0.7 Patch 57.
So what key function was introduced in this patch and changed the algorithm of Oracle SCN?
From the article we’ve learnt this new feature is SCN compatibility, which has a time limit set in it and requires this patch to be applied.
The command to modify the database SCN algorithm is:
ALTER DATABASE SET SCN COMPATIBILITY.
warnning: do not test it in any of your important environment, it may cause you into big trouble.
The compatibility feature has 4 options that can be changed to three values: 1, 2, 3
SQL> ALTER DATABASE SET SCN COMPATIBILITY 2;
Database altered.
SQL> ALTER DATABASE SET SCN COMPATIBILITY 3;
Database altered.
When the SCN compatibility is modified to a small value, the database needs to be restarted:
The final key question is, what does this all have to do with time?
Our answer is: Oracle sets the time point for each compatibility of the SCN, that means, low-level compatibility will automatically expire in certain time, and all the revised database will beJumped to Compatibility 3 on June 23 2019.
Level 3 allows for a higher SCN growth rate, exceed 32K is possible.
Therefore, if your old database is not upgraded, the database that connects to Level 3 compatibility may immediately exceed the SCN limit, and the data access may be denied.
All this is because Oracle introduced a feature called Auto-RollOver in the kernel, which sets the time for different SCN growth rates and automatically expires. As time goes by, new SCN algorithm will replace the old one yet user known.
You can get the internal information through the DBMS_SCN package. It’s like a time bomb buried in the database
—effective_auto_rollover_ts – timestamp at which rollover becomes effective
—target_compat – SCN compatibility value this database
— will move to, as a result of auto-rollover
— is_enabled – TRUE if auto-rollover feature is currently enabled
The reason why Oracle prompts in the warning 2019 April, I think it is to leave the user 84 days of margin.
Based on the above analysis, we also got the answer to following questions which users most concerned:
No, there will be no problem if there are mutual accesses to the low-level databases that have not been patched; however, problems may arise if there is a data access between the unpatched low-level version and the applied high-level version.
Not necessarily, cross-DB Link access is not necessarily a problem, especially if the SCN’s growth rate keeps a low database; however, due to changes in the algorithm, problems are likely to occur, and the probability is high;
Because SCN is Oracle’s core mechanism, the Headroom problem encountered in the past must be eliminated, so the algorithm needs to be adjusted.
It does not matter if the database is maintained at a low version or does not communicate with each other through DB Link; Oracle also provides the function of disabling this feature, but does not guarantee that it will not change afterwards; since versions below 11.2.0.4 are unsupported versions, users are highly recommended to upgrade.
So what happens if something goes wrong? In MOS document 1393360.1, If the lower version of the database SCN cannot be elevated, then ORA-19706: invalid SCN may be encountered.
Rejected the attempt to advance SCN over limit by 9374 hours worth to 0x0c00.00000f66, by distributed transaction remote logon, remote DB: REMDB.XX.ORACLE.COM.
Client info: DB logon user ME, machine yy, program sqlplus@yy (TNS V1-V3), and OS user uuu
In fact, the last part of this document has revealed changes in the new features of the SCN. In the new version, the SCN’s growth rate can be fully adjusted to be dynamic:
Warning: The SCN intrinsic growth rate has been consistently
higher than system default 16384 per sec. for last 60 mins.
Current SCN intrinsic growth rate is 24416 per sec., zas 7fffff!
The Current SCN value is 3354492471, SCN Compat value is 1
Additional reading related to this topic:
Suggestion and Solution to SCN Compatibility and DB Link Interconnection Issue
The article finishes here!
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Post 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
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Hi Readers
Install 18c.. Little Hack.. For reading click the image or the link down below.
Installing Oracle Database 18.0.0.0.0 binaries on Oracle Linux 7
We hope the content could be useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
Post 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
Joel Pérez’s Linkedin Profile: https://www.linkedin.com/in/sirdbaasjoelperez/
12 Things You Need to Know about Oracle Database 12c R2
Hi Readers
At these times we are talking already about Oracle18c, however most of production systems are in 11g,, 12cR1.. 12cR2.. so.. We think you will love this material.
Enjoy Connor McDonald Talking about Oracle Database 12c R2
We hope the content could useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
Oracle Cloud: How to Start in Oracle Database Cloud Career
Hi Readers
A typical question I receive many times during the week is: “I’m DBA.. I have a lot of experience with “On-Prem” databases.. how I start with Oracle Cloud.
I invite you to read these 3 articles and get the proper answers for that, articles written by the Talent Writer Abhinivesh Jain:
Starting your Cloud Career- Part 1
https://www.linkedin.com/pulse/starting-your-cloud-career-part-1-abhinivesh-jain/
Starting your Cloud Career- Part 2
https://www.linkedin.com/pulse/starting-your-cloud-journey-part-2-abhinivesh-jain/
Starting your Cloud Career- Part 3
https://www.linkedin.com/pulse/starting-your-cloud-career-part-3-abhinivesh-jain/
After reading those 3 amazing articles, We recommend you to read this one, Oracle18c and the future of DBAs
We hope the content could useful for your Oracle DBA Tasks!
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
By Joel Peréz & Skant Gupta
This article is brought by en.enmotech.com
Full Index of Oracle 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
Hi Readers, in this article you will go through the steps to create a disaster recovery configuration with Oracle Data Guard using the public Cloud Service “Oracle Database Cloud Service”. Across a simple wizard you will see how easy is to create a configuration with Data Guard in Cloud-Cloud Deployment. So.. Let’s start..
When creating an Oracle Database Cloud Service database deployment at the Oracle Database Cloud Service level, you can create an Oracle Data Guard configuration.
Since we will talk about Oracle Data Guard, let’s remember the concept:
Oracle Data Guard enables production Oracle databases to survive disasters and data corruptions by providing a comprehensive set of services that create, maintain, manage, and monitor a standby database. Oracle Data Guard maintains the standby database as a copy of the production database. If the production database becomes unavailable because of a planned or an unplanned outage, you can switch the standby database to the production role, minimizing the downtime associated with the outage.
To create an Oracle Data Guard configuration in Database Cloud Service, make the following choices in the Create Service wizard:
When you make these choices, Database Cloud Service creates an Oracle Data Guard configuration with a primary database and a single standby database, hosting the databases on two independent compute nodes. It creates these compute nodes using computing, storage and networking resources provided by Oracle Compute Cloud service.
Create the Oracle Data Guard in Cloud Database Service
a) Login to your Oracle cloud services account, go to the “Oracle Database Cloud Service” page and create a new service.
Then click Next to continue.
Figure1. Creating a new service (DATAGUARD)
b) In the Service Details screen, do the following:
Then click Next to continue.
Figure 2. Specifying the service details
c) Finally, review the configuration and click Create to create your cloud database.
Figure 3. Creating the cloud database instance
c) After a few minutes, the data guard in cloud database instance has been created successfully.
Figure 4. The cloud database has been created
d) Click the service name (DATAGUARD) to open the main page of the database.
Figure 5. Main page of the dataguard on cloud database
Connect the Cloud Database
1. Open the two instances of the PuTTY executable and connect to the machine using SSH public key.
Figure 6. Connecting to machines using PuTTY
Check the Status of Oracle Data Guard on Cloud
On Primary Machine |
---|
[oracle@DATAGUARD-dg01 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Wed Jun 21 18:20:30 2017 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production With the Partitioning and Real Application Testing options SQL> |
On Standby Machine |
---|
[oracle@DATAGUARD-dg02 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Wed Jun 21 18:20:30 2017 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production With the Partitioning and Real Application Testing options SQL> |
2.- Check the status of database role on both machines.
On Primary Machine |
---|
SQL> set lines 200 SQL> select name, db_unique_name, database_role, switchover_status, open_mode from v$database;
NAME DB_UNIQUE_NAME DATABASE_ROLE SWITCHOVER_STATUS OPEN_MODE ——— —————————— —————- ——————– ——————– ORCL ORCL_01 PRIMARY SESSIONS ACTIVE READ WRITE
SQL> |
On Standby Machine |
---|
SQL> set lines 200 SQL> select name, db_unique_name, database_role, switchover_status, open_mode from v$database; NAME DB_UNIQUE_NAME DATABASE_ROLE SWITCHOVER_STATUS OPEN_MODE ——— —————————— —————- ——————– ——————– ORCL ORCL_02 PHYSICAL STANDBY NOT ALLOWED READ ONLY WITH APPLY
SQL> |
Checking the Status of the Oracle Data Guard Configuration with dbaascli utility
You can use the dataguard status subcommand of the dbaascli utility to check the status of your Oracle Data Guard configuration.
Before performing certain operations, you may want to check the status of your Oracle Data Guard configuration.
To check the status of the Oracle Data Guard configuration by using the dataguard status subcommand:
Using username “opc”. Authenticating with public key “rsa-key-20170425” Passphrase for key “rsa-key-20170425”: [opc@DATAGUARD-dg01 ~]$ sudo su – oracle [oracle@DATAGUARD-dg01 ~]$ |
2. Check the status of the configuration
[oracle@DATAGUARD-dg01 ~]$ dbaascli dataguard status DBAAS CLI version 1.0.0 Executing command dataguard status SUCCESS : Dataguard is up and running DETAILS: Configuration – fsc Protection Mode: MaxPerformance Databases: ORCL_01 – Primary database ORCL_02 – Physical standby database Properties: FastStartFailoverThreshold= ’30’ OperationTimeout= ‘120’ FastStartFailoverLagLimit = ’30’ CommunicationTimeout= ‘180’ ObserverReconnect = ‘0’ FastStartFailoverAutoReinstate= ‘TRUE’ FastStartFailoverPmyShutdown= ‘TRUE’ BystandersFollowRoleChange= ‘ALL’ ObserverOverride= ‘FALSE’ ExternalDestination1= ” ExternalDestination2= ” PrimaryLostWriteAction= ‘CONTINUE’ Fast-Start Failover: DISABLED Configuration Status: SUCCESS [oracle@DATAGUARD-dg01 ~]$ |
3. Check the status of the configuration with detail subcommand
[oracle@DATAGUARD-dg01 ~]$ dbaascli dataguard status –details yes DBAAS CLI version 1.0.0 Executing command dataguard status –details yes SUCCESS: Dataguard is up and running { “instances” : [ { “DATABASE_TYPE” : “PRIMARY”, “PROTECTION_MODE” : “MAXIMUM PERFORMANCE”, “PROTECTION_LEVEL” : “MAXIMUM PERFORMANCE”, “ADDITIONAL_MESSAGES” : “”, “DATABASE_NAME” : “ORCL_01”, “PENDING_APPLY_LOG_CNT” : 0, “ACTIVE_SESSIONS” : “3”, “HOST_NAME” : “DATAGUARD-dg01”, “OPEN_MODE” : “READ WRITE” }, { “PROTECTION_LEVEL” : “MAXIMUM PERFORMANCE”, “ADDITIONAL_MESSAGES” : “”, “APPLY_LAG” : “00 days 00 hrs 00 min 00 sec”, “DATABASE_NAME” : “ORCL_02”, “APPROXIMATE_ROLE_TRANSITION_TIME” : “00 days 00 hrs 00 min 00 sec + 30 sec”, “ACTIVE_SESSIONS” : “2”, “HOST_NAME” : “DATAGUARD-dg02”, “TRANSPORT_LAG” : “00 days 00 hrs 00 min 00 sec last computed 0 days 0 hrs 0 min 9 sec before”, “PROTECTION_MODE” : “MAXIMUM PERFORMANCE”, “DATABASE_TYPE” : “PHYSICAL STANDBY”, “OPEN_MODE” : “MOUNTED” } ] } [oracle@DATAGUARD-dg01 ~]$ |
Conclusion
So now you know that it is very easy to create the Oracle Data Guard in Database Cloud Service.
This article will continue with two more parts where we will see the steps necessary to perform Switchover, Failover & Reinstate Operations with Console and then performing the same with dbaascli utility.
If you want to be updated with remarkable articles and information about Oracle Database Cloud,
Join our network, we will be please to have you there:
Joel Pérez: https://www.linkedin.com/in/sirdbaasjoelperez/
Skant Gupta: www.linkedin.com/in/skantali/
We invite you to read the following part of this article:
Oracle Cloud (DBaaS): Switchover, Failover & Reinstate Operations on Oracle Data Guard using DBCS Console
And as a Cloud Topic related you can read here one of our hotest articles:
#10 Oracle 18c: “Oracle 18c and its impact on DBAs”
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
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/
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 answered some interesting questions related to topic of DBA Changing Role.
Questions such as:
Questions like these and more are answered by Penny Avril, read at the link down below 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
This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD En.enmotech.com
Follow our Company in Linkedin: https://www.linkedin.com/company/1856106/