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 ]
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.… [ Read More ]
Oracle 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.… [ Read More ]
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:
COMPATIBLE is an almost mystic parameter. It has a default setting for each release. But if you try to find more information what it really does, you won’t be very happy. And in reply to my previous blog post about whether you need to change COMPATIBLE when you apply an RU, I received the following question: When and how should you change COMPATIBLE?… [ Read More ]
There usually a philosophic battle happening when it comes to underscore parameters. The official statement is more or less: It’s an underscore, hence it is undocumented and you shouldn’t touch it unless Oracle Support advises you to do so. I agree in many cases. But in this specific one, I don’t.… [ Read More ]
The responsible team announced it at Collaborate Conference in San Antonio, TX, a few days ago: If you are an Oracle E-Business Suite customer with Oracle Database 12.1 or 11.2 in use for your EBS environment, then you will like this announcement. As of now the Extended Support Fee has been waived for EBS customers for Oracle 12.1 and 11.2 until December 2020.… [ Read More ]
I have a million ideas for blog posts. But I like it even more when people ask me to explain something on the blog which isn’t there yet but may be interesting for others as well. And Robert Ortel mailed me the other day and asked if he should change COMPATIBLE when he applies an RU for Oracle 18c.… [ Read More ]
I have to be careful when posting something today. But this is actually not an April’s fool joke. Collaborate Conference is less than a week away. And for me this means: I’m going to Texas for the first time ever. And I hope to see you at Collaborate 2019 – San Antonio, TX – Upgrade Talks and Labs.… [ Read More ]
Oracle Database 19c is available for Exadata on-prem for quite a few weeks now. But even if you didn’t download it yet, you may want to use the new 19.2 preupgrade.jar tool to check and examine your database. For this purpose you can find the Oracle 19c preupgrade.jar and preupgrade checks available and documented on MOS.… [ Read More ]
First of all, this blog post is not new. I blogged about this SCN topic a while ago already. But some of you seem to operate still older databases for various reasons. And even if you think that you are safe, double check for any older databases in your environments. You MUST patch 184.108.40.206 and 220.127.116.11 and older databases before June 23, 2019.… [ Read More ]
Strange things happen sometimes. I got alerted by a customer before Christmas about package DBMS_OPTIM_BUNDLE missing after applying a Release Update. I’ve had a conversation with Nigel Bayliss, the Optimizer PM – but Nigel hasn’t heard of such things either. We both investigated but couldn’t reproduce the issue. But after the end-of-the-year holidays I received similar messages from other customers.… [ Read More ]
If you’d ever attended one of Roy’s or my workshops, you know that we talk about time zone adjustments after the database upgrade. We explain why this is important. But as everything, it depends if you really need to apply and adjust. In our workshops we recommend one single note for time zone adjustments: MOS Note:412160.1 .… [ Read More ]
This question sounds very simple: How long will Oracle Database 12.2 be supported? Right? But I learned at a customer site recently that the information about the support periods for Oracle 12.2 may puzzle people sometimes. Hence I thought some clarification may be useful.
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.… [ Read More ]
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 ]