As Willie Hardie, VP Oracle Database Produce Management, wrote in his blog post, Oracle Database 19.2 is available in LiveSQL since yesterday. You can try out scripts and such in a container. Of course, feature usage is restricted. But that’s a pretty nice thing for an early start with Oracle Database 19c.… [ Read More ]
Happy New Year 2019 to all of you!
Happy New Year 2019 to all of you! And thanks for reading the blog. And thanks also for the warm feedback you gave me in the past 20 months since I started this blog on a new platform.
I wish you all a very good start into the new year. If you wonder why I post this while the year is already 7 days old, we Germans have a lot of holidays – and this season it was pretty attractive to take two weeks off with just spending 5 vacation days.… [ Read More ]
Oracle 18.4.0 installation on AIX may fail with ORA-40238
Oracle 18.4.0 for IBM AIX is available since mid November 2018. But I’ve received several emails from people saying that Oracle 18.4.0 installation on AIX may fail with ORA-40238. And it’s true, this can happen. But there’s a simple workaround which unfortunately is not in the documentation yet. We’ll take care that it will be added soon.… [ Read More ]
How to patch all PDBs with the a new time zone file?
Yesterday I wrote about how to adjust the time zone setting in the PDB$SEED as by default the time zone scripts won’t touch the PDB$SEED when you execute them. And in addition, MOS Note:1509653.1 tells you, that the PDB$SEED can’t be adjusted. But this leads to a weird mix of time zone settings across a Multitenant deployment.… [ Read More ]
Does the PDB$SEED get “time zone” patched or not?
Today I received a question from a very experienced Oracle ACS engineer whether the PDB$SEED get time zone patched or not when a time zone patch gets applied. I’d say spontaneously “Of course, it does” but after thinking for a few seconds I started having doubts. Question is: Does the PDB$SEED get “time zone” patched or not?… [ Read More ]
OPatch … oh OPatch … why is datapatch so stubborn?
Well, it is Friday night – and I’d rather should sleep or do something cool people tend to do on Friday night’s. But I try to verify a strange issue with DBMS_OPTIM_BUNDLE and the October 2018 Update for Oracle 12.2.0.1. I’m patching. Can you think of anything better on a Friday night than patching?… [ Read More ]
Premier Support Extension for Oracle 19c – and more
Wait a bit. Oracle Database 19c is not out yet (only in beta right now) but how can we initiate a Premier Support Extension for Oracle 19c already? Well, Oracle 12.2.0.1, Oracle 18c and Oracle 19c all together sail under the cover of the “Oracle 12.2 Release Family” and hence have a common support frame.… [ Read More ]
UKOUG Tech18 – Recap, Slides, Videos and Impressions
UKOUG Tech18 this year was an excellent event. And even though I was very skeptical of having to travel to Liverpool where you really can’t fly into except when you live in Amsterdam, I enjoyed it a lot. Liverpool is really a lovely city. And being honest, the conference center was very nice – and IMHO better than the one in Birmingham.… [ Read More ]
Does OJVM patching require a specific Database Release Update?
This question came up several times in the past days: Does OJVM patching require a specific Database Release Update? People mentioned that there’s a significant difference between the OJVM Patch Readme between Oracle 12.2.01 and Oracle 18.4.0.
What’s the point?
In the OJVM (Oracle Java Virtual Machine) Patch Readme for Oracle Database 12.2.0.1 a sentence clarified that you can combine different states of OJVM and Database patch bundle with each other.… [ Read More ]
UKOUG Tech18 : See you there!
It’s time for my (and our) final conference this year: UKOUG in Liverpool. Liverpool? Yeah … the city of The Reds and The Blues (and Sunday is Merseyside derby time). The city of the greatest pop band ever, the Beatles. And well, the city which has an airport you can’t really fly into.… [ Read More ]
Direct INSERTs into HCC tables may be slower since Oracle 12.2
I work with several customers at the moment on their Oracle 12.2/18c “go live” projects. And one of these customers encountered a strange issue when comparing Oracle 11.2.0.4 to Oracle 12.2.0.1/18.3.0: Direct INSERTs into HCC tables may be slower since Oracle 12.2. Actually in this particular case, significantly slower. Read below why this can happen and how the workarounds look like.… [ Read More ]
How long can you provision database version X in the Cloud? – NEW
A few weeks ago I published a blog post about provisioning dates in Oracle Cloud environments for different databases releases. As we did an important update, I rewrite today: How long can you provision database version X in the Cloud? – NEW.
What has changed since the original post?
The key point in the previous blog post was:
“And by end of this calendar year, the option to provision an Oracle 12.2.0.1 instance will go away.… [ Read More ]
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.… [ Read More ]
DOAG Conference 2018 in Nuernberg – Upgrade and AutoUpgrade talk
Well, how do I realize it is November already? When I receive my conference pass for DOAG conference. And actually when the first snow falls right on time when I plan to hit the road. Lovely! If you are coming to DOAG Conference 2018 in Nuernberg – Upgrade and AutoUpgrade talk is the one you should see.… [ Read More ]
How to speed up Multitenant CUSTOM database creation
I usually create my container databases for testing with the CUSTOM option of DBCA. That allows me to specify exactly the components I’d like to have – or not. But I realized two things during the CUSTOM creation: It takes very long. And in the alert.log I see resize operations especially with the PDB$SEED during dictionary view creation.… [ Read More ]
Oracle Open World 2018 – Recap, Slides, Impressions – and a BIG THANK YOU!
Oracle Open World 2018 is over since two weeks now. And for me it was the by far busiest OOW ever. We had 4 presentations, 4 labs, 12 customer CVCs, several other customer appointments … and I wouldn’t want to miss a single one. It was a lot of work – but meeting with these customers, the discussions after the talks, at the hallways, at the lab, that is so important for us.… [ Read More ]
Why Release Update Revisions (RUR) are tricky
A while ago we introduced Release Updates (RU) and Release Update Revisions (RUR). And despite the fact that not only we but also well known external experts such as Ludovico Caldara recommend to stay with Release Updates and simply ignore the Revisions, some people use them. There may be reasons for doing so.… [ Read More ]
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.… [ Read More ]
Oracle GoldenGate 18c is finally available
It took a while – and my blog post is a bit late due to OOW as well. But Oracle GoldenGate 18c is finally available since Oct 19, 2018. And it brings Oracle Database 18c support.
Oracle GoldenGate 18c is finally available
You can download it from the usual sources:
- https://edelivery.oracle.com/
- https://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html
The new release includes for the Oracle database:
- Oracle Database 18c Support
Capture and Delivery support for Oracle Database 18c, cloud and on-premises - Autonomous Data Warehouse Cloud (ADWC) and Autonomous Transaction Processing (ATP) Support
Easily connect to ADWC and ATP to deliver transactions - Identity Column Support
Simplified support for handling identity columns in the Oracle Database - AutoCDR Improvements
Support for tables with unique keys (UK) - Composite Sharding
Support for multiple shardspaces of data using consistent partitioning - In-Database Row Archival Support
Support for compressed invisible rows
More Information
- Oracle Database Integration Blog
- Oracle GoldenGate certification matrices
- Script: Is your database ready for Oracle GoldenGate?
Why is the October Patch Bundle from July?
Strange blog headline, isn’t it? Intentionally. Peter Lehmann mailed me a question – and asked more or less: Why is the October Patch Bundle from July? Sounds strange? It is strange …
Strange notation
Peter wanted to download the most recent patch bundle for Grid Infrastructure from October. And he found patch 28507693:
But he was wondering about the headline having the date of October 18, 2018 together with JUL 2018.… [ Read More ]
To which release should you upgrade to? Plus: Extended Support?
A few days ago I blogged about the Current Support Status for Oracle Database Releases. And you’ve sent several questions to me. Some asked about clarification to which release should you upgrade to? Plus: Extended Support questions were quite frequent. So let me clarify this previous blog post a bit.… [ Read More ]
OOW 2018: How to Migrate to Oracle Autonomous Database Cloud
And last but not least our forth talk at OOW 2018: How to Migrate to Oracle Autonomous Database Cloud on Tuesday, Oct 23 at a fairly late slot at 5:45 p.m. (or 17:45h) as well in Moscone West 3004.
What is this talk all about?
It’s about the Oracle Autonomous Database cloud.… [ Read More ]
Current Support Status for Oracle Database Releases
Yesterday a former colleague from the UK pointed me to a very old blog post about the fact that no patches will be produced for Oracle 11.2.0.3 anymore. Which is a true fact. But it reminded me that it may be time for an overview on the current support status for Oracle database releases as of October 2018.… [ Read More ]
OOW 2018: Cloud Migration from AIX to ExaCC – for DBAs and managers
Yes, OOW starts next week. And I’d like to introduce the third of our 4 talks. And let me say upfront about this talk at OOW 2018: Cloud Migration from AIX to ExaCC – for DBAs and managers. This is not the usual “cloud” talk 🙂 The official title is: Oracle Database Cloud Migration: Fast, Simple, Universal.… [ Read More ]
OOW 2018: Upgrade to Oracle 18c – Live and Uncensored
Less than two weeks until the potentially busiest Oracle Open World conference I’ve ever attended. The schedule is filled up already and closed down. And I’m pretty sure I will need time off afterwards to relax and recover. But I’m looking forward to our annual big event in San Francisco. To make it as exciting as possible for you we are very happy to have high profile speakers with us in all our talks.… [ Read More ]