Download

Video: Best Practices to Upgrade to Oracle Database 19c

This is a short “Black Friday” blog post. And just if you are tired already of hunting supposed-to-be-bargain-buys, you may need something to relax – and watch this Video: Best Practices to Upgrade to Oracle Database 19c.

Video: Best Practices to Upgrade to Oracle Database 19c

Roy recorded it as part of the Quest Experience Week. We’d like to share it with you here.

Just click on the picture below to open a new TAB and watch the 1 hour video:

 

If you are looking for the slide deck, you can download them from:

Thanks!

–Mike…

Continue reading...

DOAG 2019 – Recap and a personal complaint

Nürnberg and München are just 175 km away from each other, a bit more than 1 hour by train. Still I felt a post-conference blues already when I boarded the ICE train yesterday to head back to the south. It was an awesome conference – again. Except for one thing which I will write about below. So here’s my report on DOAG 2019 – Recap and a personal complaint.

DOAG 2019 - Recap and a personal complaint

Photo by Philippe Mignot on Unsplash

DOAG 2019 – What an agenda

I knew it before already. But my VP, Roy Swonger, visited DOAG Conference in Nürnberg for the first time. …

Continue reading...

New version of Upgrade / Migrate / Consolidate to Oracle 19c uploaded

Please apologize that it took me a bit longer to upload a new version of our comprehensive slide deck. You can download now a new version of “Upgrade / Migrate / Consolidate to Oracle 19c” via the blog’s download page.

New version of Upgrade / Migrate / Consolidate to Oracle 19c uploaded

Why is there a new version?

Since Oracle Open World 2019 we have a new corporate template. And while I like the graphics quite a bit, I’d say, the people who built it have a good sense for graphics. But they aren’t powerpoint experts. In fact, almost every slide had to be adjusted. This may not be a huge …

Continue reading...

Patching all my environments with the Oct 2019 Patch Bundles

Yesterday I blogged about the Oct 2019 Patch Bundles being available for download. And while I wrote this blog post, I downloaded all of them for my environments. Here I’d like to share with you the most simple path to apply them. As I have no cluster or ASM, I don’t have to patch Grid Infrastructure. And I don’t even have OJVM in any of my databases right now. Due to space constraints in my lab environment I will apply the patches in-place. You shouldn’t do this but instead use always a new home you patch. This allows you …

Continue reading...

CPU October 2019 Patch Bundles are available

As of Oct 15, 2019, the CPU October 2019 Patch Bundles are available for download. So let me do the quarterly exercise to download and install all of them into my various environments.

CPU October 2019 Patch Bundles are available

Critical Patch Alert October 2019

At first, I check the Alert and the Risk Matrix whether critical issues with a high risk score are included. I will install the patch bundles anyway, but I’m curious. In my particular case I will take care on the database only. You of course will check for other products you are using, too.

Continue reading...

Oracle Open World 2019 – Recap and Thank You!

OOW 2019 has ended over one week ago – and I just wrote the date for OOW 2020 into my calendar: Oct 4, /2020 –  Oct 8, 2020 – at least according to the events calendar of Moscone Center. But lets not talk about OOW20 but instead about my summary for Oracle Open World 2019 – Recap and Thank You!

Oracle Open World 2019 - Recap and Thank You!

Oracle Open World 2019 - Recap and Thank You!As usual, this was not a week to relax or hang out in all the nice places in San Francisco. OOW for me means usually a lot of stress. There are so many things we need to prepare. From …

Continue reading...

The September 2019 AutoUpgrade – and the AutoUpgrade Video

My team mates work really hard. And I’m really proud on all of them. We try to fix upcoming issues or requirements with the new AutoUpgrade tool as quickly as possible and still maintain very high quality standards. And here it is, the September 2019 AutoUpgrade – and the AutoUpgrade video as a bonus in addition. Just in case you haven’t seen it in action and can’t join us at OOW 2019.

The September 2019 AutoUpgrade - and the AutoUpgrade Video

Download the September 2019 AutoUpgrade Tool

You can simply download the tool from MOS Note: 2485457.1 – AutoUpgrade Tool.

MOS Note: 2485457.1 – AutoUpgrade Tool:

Watch the AutoUpgrade Video

I just uploaded …

Continue reading...

Please download the new July 2019 (20190715) AutoUpgrade

Since last night, the new version of the AutoUpgrade utility is available. Please download the new July 2019 (20190715) AutoUpgrade and exchange your previous version in your destination $ORACLE_HOME/rdbms/admin with this one.

Download

Please download the tool from: MOS Note: 2485457.1 – AutoUpgrade Tool

When you copied the new tool, call it for a version check to make sure you are using the most recent one:

$ java -jar $OH19/rdbms/admin/autoupgrade.jar -version
build.version 20190715
build.date 2019/07/15 12:45:48

Please notice that the tool allows you to upgrade to Oracle 12.2.0.1 and Oracle 18c as well:

 

Please download the new July 2019 (20190715) AutoUpgrade

The listed releases are the minimum …

Continue reading...

The new Oracle 19c Hands-On Lab is available

Well, it’s been a while since we refreshed the lab being downloadable via this blog. But finally, the new Oracle 19c Hands-On Lab is available – you can download it as of now.

What’s new in the lab?

First of all, the biggest change you’ll see is that the operating system is now Oracle Linux 7. Well, to be honest, I’m not a die-hard Linux expert and you may find my setup a bit creepy. Feel free to exchange things or adjust them – or drop me a message if you think that adjustments should be made. And of …

Continue reading...

A new version (June 2019) of the AutoUpgrade is available for download

My team mates worked very hard – and many customers did the same. Thanks for all your feedbacks. We tried to help and assist everybody where possible. And here it is. A new version (June 2019) of the AutoUpgrade is available for download.

A new version of the AutoUpgrade is available for download

Download the new AutoUpgrade

Please download the newest version 20190620 of the AutoUpograde from:

and replace your current version with the new one (20190620..

The new version has 51 additional fixes. At the end of MOS Note: you’ll find a list of bugs fixed on X64_190620 update file.

Where

Continue reading...

Create and adjust the config file for AutoUpgrade 19c

Create and adjust the config file for AutoUpgrade 19cThis is the first of a series of blog post explaining the new AutoUpgrade utility step-by-step. You’ll find the tool and overview information in The New AutoUpgrade Utility in Oracle 19c

In this blog post here I will explain and demonstrate how you can create a sample config file and adjust it for a standard database upgrade.

You will see how to add additional options and change default settings. Furthermore, I will showcase how to change, adjust and tweak init.ora parameters during or after upgrade in the upcoming blog posts.

AutoUpgrade – Step-by-step

  1. The new AutoUpgrade Utility – Download,
Continue reading...

Oracle Database 19c (19.3.0) for Windows and zLinux is available

Oracle Database 19c (19.3.0) for Windows and zLinux is availableAs of now, Oracle Database 19c (19.3.0) for Windows and zLinux is available for download in addition to Linux, SPARC Solaris, HP-UX and AIX.

Oracle Database 19c on premises for Windows and zLinux

Oracle Database 19c (19.3.0) for Windows and zLinux is availableYou can download Oracle Database 19.3.0 on-prem for MS Windows and zLinux from the usual sources:

Oracle 19c Documentation

And of course you can find the Oracle 19c Documentation here:

See especially the operating system dependent install guides:

Continue reading...

Oracle Database 19c (19.3.0) for HP-UX and AIX is available for download

Oracle Database 19c (19.3.0) for HP-UX and AIX is available for downloadFor a few days, in addition to Linux and SPARC Solaris, Oracle Database 19c (19.3.0) for HP-UX and AIX is available for download now as well. The missing platforms, Windows, Intel Solaris and zLinux should be available soon as well.

Oracle Database 19c on premises for HP-UX and AIX

You can download Oracle Database 19.3.0 on-prem for HP-UX ia64 and IBM AIX from the usual sources:

Oracle 19c Documentation

And of course you can find the Oracle 19c Documentation here:

See especially the operating …

Continue reading...

Oracle GoldenGate 19c is available for download for Linux

Oracle GoldenGate 19c is available for download for Linux

Photo by Raquel Stanton on Unsplash

I have a good numbers of customers waiting for it – and since two days Oracle GoldenGate 19c is available for download for Linux. You can download it from the usual sources. The other platforms should follow soon.

Download Sources for Oracle GoldenGate 19c

Certification for Oracle GoldenGate 19c

New Features and Documentation

For a list of new features in Oracle GoldenGate 19c see the list in the documentation – and of course, the most important feature is …

Continue reading...

Oracle Database 19c (19.3.0) for SPARC Solaris is available for download

Oracle Database 19c (19.3.0) for SPARC Solaris is available for downloadSince yesterday you can download Oracle Database 19.3.0 on premises for Linux. And as of today, 19c for SPARC Solaris 64bit is available, too.

Oracle Database 19c on premises for SPARC Solaris

You can download Oracle Database 19.3.0 on-prem for SPARC Solaris 64bit now from the usual sources:

Oracle 19c Documentation

And of course you can access the Oracle 19c Documentation from now on as well:

See especially the operating system dependent install guides:

Continue reading...

Oracle Database 19c (19.3.0) for Linux is available for download

Oracle Database 19c (19.3.0) for Linux is available for download as of now from OTN and eDelivery. For those of you who started with Oracle Database 19.2 already, the Updates (RU) 19.3.0 for the database and GI are available as well for Linux and Solaris.

Oracle Database 19c on premises for Linux

You can download Oracle Database 19.3.0 on-prem for Linux now from the usual sources:

The download offering includes the zip, the RPM for the database, and Grid Infrastructure, the Client and more.

Oracle Database 19c (19.3.0) for Linux is available for download

The other ports will follow soon.

Oracle 19c Documentation

And of course …

Continue reading...

Oracle 18c Express Edition (XE) for Windows is available

Oracle 18c Express Edition (XE) for Windows is availableOracle 18c Express Edition (XE) for Windows is available for download as of now. Oracle XE 18c on other platforms is available since November 2018. As of now you can download the Windows version as well.

Use the Quick Start guide which explains the installation and how to connect to the database.

General availability of Oracle Database 18c Express Edition on Windows!

Whether you are a developer, a DBA, a data scientist, an educator, or just curious about databases, Oracle Database 18c Express Edition (XE) is the ideal way to get started. You will get the same powerful Oracle …

Continue reading...

Oracle Database 19c requires OL7, RHEL7 or SLES12 or newer

Oracle Database 19.2 for Oracle Exadata systems is available for download since yesterday night. One important thing you need to take into account once Oracle 19c will be generally available: On Linux, Oracle Database 19c requires OL7, RHEL7 or SLES12 or newer.

Database Installation Guide for Linux

Oracle Database 19c requires OL7, RHEL7 or SLES12 or newer

You will find the exact minimum OS and kernel version requirements in the Database Installation Guide for Linux for Oracle 19c. Please see here the Operating System Checklist for Oracle Database Installation on Linux:

Please be aware that the list of minimum requirements has been updated – always check Operating

Continue reading...

Oracle Database 19.2 for Exadata is now available for download

Time flies – and we have 2019. Since a few minutes Oracle Database 19.2 for Exadata is now available for download.

Oracle Database 19.2 for Exadata is now available for download

You can download as of today Oracle Database 19.2 for Exadata from the Software Delivery Cloud (eDelivery).

Just type in “Oracle Database” into the search window:

Oracle Database 19.2 for Exadata is now available for download

And then add it to your cart:

Oracle Database 19.2 for Exadata is now available for download

Documentation

And of course, the Oracle Database 19c documentation is available as of now as well:

Oracle Database 19.2 for Exadata is now available for download

Further Information

Please read more on the Oracle Database Blog.

–Mike…

Continue reading...

Different MOS Notes for xTTS PERL scripts – Use V4 scripts

A long time ago my colleagues published PERL scripts to assist especially with cross platform Transportable Tablespace migrations. The PERL scripts allow you to utilize incremental backups. This way you can decrease the downtime in a migration with large databases significantly. But there are different MOS Notes for xTTS PERL scripts available. Which one should you take?

Photo by VanveenJF on Unsplash

Transportable Tablespaces and Incremental Backups

The biggest pain points in a transportable tablespace migration are usually the size of the database and its complexity. With RMAN Incrementally Rolled Forward Backups you can tackle the size aspect. Instead of having a long downtime …

Continue reading...

Oracle Database 18c for AIX, HP-UX and zLinux available

I rarely blog twice a day – but this message is the one a good number of people have waited for quite a while. Oracle Database 18c for AIX, HP-UX and zLinux available for download from eDelivery as of now. The software is not on OTN or oracle.com yet in the usual download section. I’m blindly guessing that it will be there soon, maybe tonight already.

Oracle Database 18c for AIX, HP-UX and zLinux available

→ Please go to eDelivery (also known as the Oracle Software Cloud) and type into the search line:
Oracle Database” – then hit …

Continue reading...

Oracle Express Edition XE 18c available for download

This was hard work right before Oracle Open World – and you had to wait a very long time. The last Oracle Express Edition we delivered was based on Oracle 11.2.0.2. Not exactly the most modern release these days. And my mates, especially Gerald Venzl, but of course also the involved developers and managers worked hard to have Oracle Express Edition XE 18c available for download. It of course has some restrictions. And you can’t get support for it. If you need support for anything, please visit the Community Forum. But it’s pretty cool Oracle database with …

Continue reading...

New Oracle Database Upgrade Lab for Oracle 18.3.0

New Oracle Database Upgrade Lab for Oracle 18.3.0

Our new and updated Oracle Database Upgrade Hands-On Lab for Oracle 18.3.0 is finally live and can be downloaded via this link:

What’s new?

Of course, Oracle 18.3.0 is inside to upgrade to. But we changed the entire instructions set a bit. We included a simple load generator. And we added way more performance stuff. And of course fallback. As soon as Oracle 18.4.0 becomes available, patching will be included in the instructions as well. Everybody should have used OPatch at least once 🙂

What’s in

Continue reading...

Improved preupgrade.jar for Oracle 12.2 and 18c

My team mates are really quick. We received an information early this week about a missing or wrong DV check in the preupgrade – and they implemented it within a day or so. The September 2018 version of the improved preupgrade.jar for Oracle 12.2 and 18c is available for download.

Improved preupgrade.jar for Oracle 12.2 and 18c

What’s new in this version:

  • It adds a recycle bin check when the autofixup for dictionary statistics is run
  • And it updates DV_AUDIT_CLEANUP  to 11.2.0.4

Improved preupgrade.jar for Oracle 12.2 and 18c

Please find the new September versions of:

  • Oracle 12.2.0.1 preupgrade.jar – build 17
    • There’s issue with “creating directories”
Continue reading...