Oracle database 12cR2 new patching concept RU RUR

Oracle database 12cR2 new patching RU RUR

The new database patching for Oracle 12cR2 (12.2) and above using new RUs and RURs patches replaces the old patching concept. Means, the legacy terms and patches Patchset, Patchset Update (PSU), Database Bundle Patch, Critical Patch Update (CPU) will no longer be meaningful for 12.2 database software. The new patches will be applied in the same way using opatch utility with ability using RAC Rolling or Data Guard/GG switchover techniques.

The major points about the new patching concept are below:

New quarterly Release Update (RUs)
– More aggressive patching for test / dev and early production roll-outs -> more testing required
– Released quarterly (Jan, Apr, Jul, Oct)
– Proactive, highly tested bundles of critical fixes
– Include all security fixes for the same quarterly cycle
– Enable customers to avoid known issues.
– Might contain small, important new features
– Query optimizer fixes that can change execution plans might be included but must be enabled manually by the customer after patching.
– Separate Database RU, Grid Infrastructure RU, and OJVM RU available

New quarterly Release Update Revisions (RURs)
– A bit similar to former PSUs
– Less aggressive pathing for stable production environments -> less testing required
– Released quarterly (Jan, Apr, Jul, Oct) Read more »

Oracle Open World Conference 2017 Highlights

JavaOne and Oracle Open World Conference 2017JavaOne & Oracle OpenWorld (OOW) conference is one of the biggest and most important technology conference in the world. It hosts tens of thousands of attendees as well as millions online who want to connect, learn and explore industry trends and breakthroughs driven by IT technology. The conference offers more than 2,500 educational sessions, hundreds of demos and hands-on labs, plus exhibitions from more than 400 partners and customers from around the world.

The conference does not focus purely on databases. There are many more interesting technology areas presented from HW, OS and software development to modern IT trends like Cloud, Big Data, Blockchain, Internet of Things, Machine Learning, etc. But what about the database? Is Oracle not a pure database provider? No, it was probably long time back, but NOT ANY MORE.

Below are a few major topics that were dominating at the last OOW

Cloud

Oracle is aggressively scaling its cloud business and effectively catching-up with competitors like Amazon (AWS), Azur and Salesforce introducing at OOW17 an array of new Cloud offerings and enhancements and demonstrating its cost efficiency and unbeatable Infrastructure performance. At the same time comparing these all the way against AWS. For example, Larry Ellison (Oracle Founder & CTO) stated that Oracle Cloud would cost at least 50% less of your AWS bill and they would write this in the contract.
The recent launch of Oracle data Centers in Frankfurt supporting European Availability region can only confirm serious Oracle intention in the Cloud business. I personally think that soon only a few large Cloud providers will cover the major Cloud market that in turn will be driven mostly by Software Cloud Services (SaaS and partly PaaS). And there is a big chance that Oracle will be soon in the Cloud leaders caused by a large range of own quality software, modern Java development platform as well as own cost efficient HW, OS and Virtualization stack.

Machine learning

What is this thing by the way? Read more »

Oracle database In-Memory development workshop

Oracle database In-Memory development workshop

Oracle database In-Memory development workshop

This month I had a chance to talk with the Oracle database In-Memory development team at the Oracle Headquarter in Redwood Shores and meet there the Oracle product managers, VP of Oracle In-Memory and the mother of Oracle Query Optimizer Maria Colgan. In a 3 hours workshop we discussed the current challenges in implementing new database and in-memory computing technologies, talked about new trends and possibilities in the future product versions.

I really liked the atmosphere of the workshop, the openness of the Oracle development team and the constructive discussion that we could have there. This certainly can help us to be prepared and build a database platform of tomorrow that will be capable to cope with enormous data growth and tough availability and performance requirements that come from the customers.

Thanks to Maria, Tirthankar, Raj, Andy, Shasank and entire Oracle In-Memory team to make it happen.

Oracle 12c In-Memory database how to start

The In-Memory Column Store feature that was introduced by Oracle in the database version 12c (12.1.0.2) brings the solution for accelerating performance of database-driven business decision-making to real-time speeds. Since it is an extra-license feature for which Oracle makes you pay around 50% on top of your CPU license (similar to RAC option), you probably ask yourself a few valid questions. Don’t we cache everything already in memory anyway? Is it really required for my application, my company? Will it work for my workload at all? In this post I’ll give you a short guideline and introduction into Oracle database In-Memory feature.

First of all me personally and so probably you do not know any database that works only on disk. Indeed we cache most of our data, code and intermediate results in memory already. Furthermore there are some extra Oracle database performance features that help you to achieve that fairly efficiently, for example:

– KEEP/RECYCLE Pools
– RESULT Cache
– 12c Big Table Caching
– 12c Full Database Caching
– ….

The key point of Oracle In-Memory is not “What to cache” but “How”. So the major difference of Oracle In-Memory Column Store is that it enables individual database segments to be loaded into memory in the compressed columnar format. This technique enables segment scans to perform much faster than the traditional on-disk formats, providing performance boost for analytical and reporting workload.

Oracle 12c database In-Memory Architecture dadbm.com

Oracle 12c database In-Memory Architecture

Read more »

Oracle RMAN recovery script for EMC NetWorker

In this article I’ll share an Oracle RMAN script to do restore and recovery an Oracle database from tape library using EMC NetWorker. Apply this RMAN template to different recovery situations you might have. Before looking into the RMAN script see my notes below:

– Read about Oracle Recovery Manager (RMAN) concepts
– Look at the corresponding RMAN backup script for NetWorker
– The recovery script should work for Oracle database 11g, 12c (maybe 10g)
Oracle database name = ORCL
– I use 2 RMAN channels to speed up the recovery of database
– Recovery of spfile and/or control file is optional and depends on your recovery situation
– PARMS section includes instructions for EMC NetWorker server (depends on Networker server configuration)
– Choose appropriate database recovery scenario (by default -> compete DB recovery; I commented 3 options for incomplete DB recovery scenario)
– This script is independent from RMAN configuration parameters

Read more »

Next Page »

DBMS Blog Updates : Subscribe RSS RSS: Subscribe to Articles · Subscribe to Comments Subscribe RSS Receive site updates via email