Please download the new July 2019 (20190715) AutoUpgrade

5

Oracle Security Alerts for July 2019 got published

Oracle Security Alerts for July 2019 got published 0

AutoUpgrade: Where do you find all the logfiles?

0

Behavior Change in Oracle 18c/19c: No symbolic links for Data Pump directories

Behavior Change in Oracle 18c/19c: No symbolic links for Data Pump directories 4

AutoUpgrade: ANALYZE, FIXUPS, UPGRADE and DEPLOY modes

0

Yatra 2019 – Oracle Groundbreakers: Roy Swonger travels to India

0

The new Oracle 19c Hands-On Lab is available

4

Config file for AutoUpgrade – Tweaking init parameters

0

Config file for AutoUpgrade 19c – Advanced options

8

Update (RU) 19.3.0 withdrawn and superseded with 19.3.1

8

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 noted releases are the minimum releases … [ Read more ]

Oracle Security Alerts for July 2019 got published

It’s patching day. And I’m already downloading the patch bundles for all my installations (11.2.0.4, 12.1.0.2, 12.2.0.1, 18c and 19c). The Oracle Security Alerts for July 2019 got published today.

Oracle Security Alerts for July 2019 got published

Patch Advisory and Risk Matrix

You can find the July 2019 Patch Advisory here. I checked the risk matrix for the database. It contains 8 new fixes for the database server. Please pay attention that 3 of the vulnerabilities may be exploitable from a client without an Oracle Database server being installed. The highest score is 9.8.

Please check the risk matrix by yourself:

[ Read more ]

AutoUpgrade: Where do you find all the logfiles?

AutoUpgrade: Where do you find all the logfiles?In the previous blog posts you could read about how to create the configuration file, adjust it and tweak the init parameters for the AutoUpgrade tool. And then I described the different modes of it. In this blog post I’d like to give you some insights into AutoUpgrade: Where do you find all the logfiles?

AutoUpgrade: Where do you find all the logfiles?

AutoUpgrade – Step-by-step

  1. The new AutoUpgrade Utility – Download, documentation and supported versions
  2. Create and adjust the config file for AutoUpgrade
  3. Config file for AutoUpgrade – Advanced options
  4. Config file for AutoUpgrade – Tweaking init parameters
  5. AutoUpgrade: ANALYZE, FIXUPS, UPGRADE and DEPLOY modes
  6. AutoUpgrade:
[ Read more ]

Behavior Change in Oracle 18c/19c: No symbolic links for Data Pump directories

Most of you may have recognized the desupport of UTL_FILE_DIR with Oracle Database 18c. Reason is mostly that UTL_FILE_DIR opens a lot of possibilities to do insecure things. But this has another effect which may not be obvious to you. There’s a behavior change in Oracle 18c/19c: No symbolic links for Data Pump directories. Read further to learn more about it.

UTL_FILE_DIR Desupport

In Oracle Database 18c we announced the desupport of UTL_FILE_DIR initialization parameter. But as you can read as well in the Database Upgrade Guide, there’s this remark:

UTL_FILE Package Symbolic Link in Directory Paths Not Supported

[ Read more ]

AutoUpgrade: ANALYZE, FIXUPS, UPGRADE and DEPLOY modes

AutoUpgrade: ANALYZE, FIXUPS, UPGRADE and DEPLOY modes

Photo by Debby Hudson on Unsplash

In the previous blog posts I explained mainly how to create, alter and tweak the configuration file for the AutoUpgrade tool. By now you should have your config file set up and adjusted for your environment(s). Let me go a step further and explain the different processing modes of AutoUpgrade: ANALYZE, FIXUPS, UPGRADE and DEPLOY modes. Then you’ll have a precise idea what the tool is actually doing, and how it operates.

AutoUpgrade – Step-by-step

  1. The new AutoUpgrade Utility – Download, documentation and supported versions
  2. Create and adjust the config file for
[ Read more ]

Yatra 2019 – Oracle Groundbreakers: Roy Swonger travels to India

In April in Vienna a colleague from the US asked me: “Is Roy serious to travel to India in July?”. He mentioned the temperatures, the humidity – and the rain. But Roy is serious – and while I’m writing this, he should be already on his way  to India to present about Upgrade and Migrations in 5 locations at Yatra 2019 – Oracle Groundbreakers: Roy Swonger travels to India.

Yatra 2019 - Oracle Groundbreakers: Roy Swonger travels to India

Why you need to attend?

The organizers have listed 6 fine reasons for attending Yatra on the official Yatra 2019 conference page. And I’m adding another one: You want to … [ Read more ]

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 … [ Read more ]

Config file for AutoUpgrade – Tweaking init parameters

In the previous blog posts I explained how to generate a sample config file for the AutoUpgrade tool and how to adjust it. Then I gave you an overview about the most important Advanced Options you may want or need to deal with when using the utility. And in the below blog post I would like to show you have you need to edit the Config file for AutoUpgrade – Tweaking init parameters is an important topic.

This is the forth post of a series of blog posts regarding the new AutoUpgrade tool. Please find all the other available … [ Read more ]

Config file for AutoUpgrade 19c – Advanced options

Config file for AutoUpgrade 19c – Advanced optionsIn the previous blog post I explained how to create a config file for the AutoUpgrde utility. And now I’d like to show how you can use some important advanced options to have the AutoUpgrade utility do or skip specific tasks. Read about how you can tweak the config file for AutoUpgrade 19c – Advanced options.

I will describe only the most important advanced parameters which I think can be very useful in your environments. Of course, there are many more as you can see in the Database Upgrade Guide.

AutoUpgrade – Step-by-step

  1. The new AutoUpgrade Utility – Download,
[ Read more ]

Update (RU) 19.3.0 withdrawn and superseded with 19.3.1

Actually I really refused to blog about this for a few weeks now. But as I receive more questions and read more tweets, I think I need to shed some light and help avoiding confusion. And as readmes and MOS notes are not entirely in sync, you may get confused if you don’t read the “correct” document.

Update (RU) 19.3.0 withdrawn and superseded with 19.3.1

Photo by camilo jimenez on Unsplash

Oracle 19.3.0 Update (RU)

In April, Oracle released the 19.3.0 Release Update (RU) on Linux and Solaris only. As you can read in my blog post from April 25, 2019, this is a patch bundle meant for … [ Read more ]

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

[ Read more ]

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,
[ Read more ]

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:

[ Read more ]

In case you miss DBMS_OPTIM_BUNDLE … again …?!?

In case you miss DBMS_OPTIM_BUNDLE ... again ...?!?

Photo by Caleb Woods on Unsplash

I’m tempted to copy and paste my blog post about DBMS_OPTIM_BUNDLE from February 2019, and exchange only 12.2.0.1 with 19c. But in this case the root cause is different. So this blog post is meant for Oracle 19.3.0 to be precise – in case you miss DBMS_OPTIM_BUNDLE … again … ?!?

Information about DBMS_OPTIM_BUNDLE

You will find a lot of information about DBMS_OPTIM_BUNDLE, what it does, since which release it exists and much more in these blog posts:

[ Read more ]

Automatic SQL Plan Management in Oracle Database 19c

Automatic SQL Plan Management in Oracle Database 19cWhen you upgrade to a new database release, there will be changes. Some are obvious, others are not. This one is somewhere in between because it is documented quite well but not very well known yet as far as I see. I’m talking about the Automatic SQL Plan Management in Oracle Database 19c.

What is changing in Oracle 19c?

First of all, I don’t want to rewrite everything Nigel Bayliss wrote in his detailed blog post about Automatic SQL Plan Management in Oracle 19c in April 2019. But the essence is:

  • Automatic SQL Plan Management is enabled by
[ Read more ]

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 … [ Read more ]

DOAG Datenbank 2019: Roy Swonger will be there!

DOAG Datenbank 2019: Roy Swonger will be there!

The last DOAG 2018 conference happened half a year ago – time flies! And if you are eagerly waiting for a lot of cool presentation by very experienced speakers, then visit DOAG Datenbank 2019: Roy will be there!

Upgrade Talks

DOAG Datenbank 2019: Roy will be there!

Roy Swonger, Vice President, Oracle

Roy will deliver two talks. Be aware, the first one is currently not in the web agenda as it was on standby.

Dienstag, 4. Juni, 10:15 – 11:00
Raum Amsterdam 1
Dienstag, 4. Juni, 11:15 – 12:00
Raum Düsseldorf 2
[ Read more ]

DBMS_JOB – Behavior Change in Oracle 19c during upgrade

DBMS_JOB - Behavior Change in Oracle 19c during upgrade

Actually I missed to blog about this change but luckily a colleague did ask a question the other week about the migration of jobs when you upgrade to Oracle 19c. Let me shed some light on DBMS_JOB – Behavior Change in Oracle 19c.

DBMS_JOB vs DBMS_SCHEDULER

Back in the 10g days, we introduced a new interface to run and monitor jobs in the database: The scheduler. The scheduler with DBMS_SCHEDULER is way more powerful than the old job interface. And we use it internally a lot as well. But as things appear in the real world. the introduction … [ Read more ]

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 … [ Read more ]

Transportable Tablespace PDB Migration and Local Undo

Transportable Tablespace PDB Migration and Local Undo

Photo by Steve Johnson on Unsplash

Sometimes it is necessary to warn you about known pitfalls to avoid frustration. In this particular case I decided not to blog about it simply because I thought this won’t happen to too many other people. Well, yesterday my good friend Philippe Fierens dropped me a message about an issue he ran into with a Transportable Tablespace PDB Migration and Local Undo. And I immediately knew what caused him trouble – and I regret that I didn’t blog about it (sorry Philippe!). We’ve seen the same problem with a large ExaCC migration project … [ Read more ]

Data Pump: The Time Zone Pitfalls

Data Pump: The Time Zone Pitfalls

Photo by Luis Cortes on Unsplash

Last week a very experienced colleague called me. He had issues with an export dump taken from an Oracle 20c database importing into 19c. It failed. So this blog post is about Data Pump: The Time Zone Pitfalls.

The Case

Usually you will see this issue only when you try to export from a higher version, and then attempt to import into a lower one. But the same thing can happen when you patched your databases partially with a newer time zone patch regardless of the version.

My colleague saw this error:

impdp system/welcome1@//localhost:1521/MYDB 
[ Read more ]

Hello, hello … Vienna Calling … AOUG 2019

Hello, hello ... Vienna Calling ... AOUG 2019

When I think about Vienna, the Falco song “Vienna Calling” from 1985 is coming to my mind immediately. It was on “Falco 3“, the record which had “Jeanny” as third single – getting banned from Bavarian radio stations. Well, Bavaria is a bit more conservative than other places. Most people of course will remember “Rock Me Amadeus” from the same record. It made no.1 positions in the US, UK, USSR, Germany and many other countries. But why is a Falco song in my mind this morning? Very simple: This week the Austrian [ Read more ]

The new AutoUpgrade utility in Oracle 19c

The new AutoUpgrade utility in Oracle 19cOracle Database 19c on premises is available – and one of the key features is the new AutoUpgrade utility. In the following days I will publish several blog posts explaining and showcasing the new AutoUpgrade.

What is the AutoUpgrade?

The Oracle Database AutoUpgrade utility is a new tiny little command line tool which allows you to upgrade your databases in an unattended way. I call it the Hands-Free Upgrade. TThe new AutoUpgrade utility in Oracle 19che idea of the tool is to run the prechecks against multiple databases, fix 99% of the potential issues, set a restore point in case something goes wrong … [ Read more ]

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:

[ Read more ]

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 … [ Read more ]