Mike Dietrich's Blog About Oracle Database Upgrades... Mostly. Based in Bavaria, Germany. >25 years IT experience. Database Upgrade and Migration specialist, currently in the role of a Master Product Manager working for Oracle for over 20 years.
When 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.… [ Read More ]
For 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:
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!
Roy will deliver two talks. Be aware, the first one is currently not in the web agenda as it was on standby.… [ Read More ]
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.… [ Read More ]
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.
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.… [ Read More ]
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.
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.… [ Read More ]