Since 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.
You can download Oracle Database 19.3.0 on-prem for SPARC Solaris 64bit now from the usual sources:
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...
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.
Well, stereotypes are great. I live in Bavaria but I’m actually from its Northern part called Franconia. Which belongs geographically to Bavaria but is different. But when you look from any other part of Germany towards its South, …
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 . This note has been updated and republished. It contains DST V.32 and DST V.33 links and references. Amit Grover from AWS contacted me and told me about a potential dependency of DST patches to the Oracle Update such as RU 18.4.0 or 18.5.0.…
Continue reading...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 …
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.
How does this make sense??
When you flash back to the day when we introduced “Updates” (RU) and “Revisions” (RUR) you may remember that we release quarterly “Updates” …
Continue reading...LONG identifiers are one of the key features in Oracle Database 12.2.0.1. But as I learned the other day, you should be a bit careful when you exchange data between different databases. In certain situations, Long Identifiers in Oracle 12.2 may cause trouble.
Long identifiers get introduced with Oracle Database 12.2.0.1. For ages, you could name a table or a column or a user or a package in Oracle with only 30 byte length. Hence, naming a table TAB_THIS_IS_MY_TABLE_AND_I_LIK is ok (30 byte – 30 characters) but naming it TAB_THIS_IS_MY_TABLE_AND_I_LIKE_IT is not possible as it requires …
Dear all,
there was silence on the blog for more than 2 weeks now. And 2018 started already. Let me wish you all a happy and exciting new year 2018. Stay safe and healthy, take care and all the best for 2018 to you, your families and friends!
Source: https://pixabay.com/en/design-2018-to-reach-new-year-3047520/
There will be more updates in the next few days 🙂
Happy New Year!
Mike…
This question is coming up from time to time – and currently not covered in the official Oracle documentation as far as I know: “Can you simply switch from SE2 to EE with Oracle Multitenant?”
First of all, the switch is possible and tested. But you’ll have to satisfy a few requirements:
That’s it. Simply unplug your Standard Edition 2 PDB and plug it into your Enterprise Edition CDB.
In addition you may have to run several component …
Continue reading...There’s a new and improved version of the preupgrade.jar (build 5 – May 2017) available for download from MyOracle Support:
The same note will get you access also to the most recent builds of preupgrd.sql for upgrades to Oracle Database 12.1 and utlu112i.sql for the unlikely event you’ll have to upgrade a database to Oracle 11.2.0.4.
Please always exchange the version getting installed by default with the version we offer via MOS Note:884522.1 as the downloadable version is usually much newer and improved over the one getting deployed …
Continue reading...This topic fits very well as I present about +100 TB migrations today at the “Harmony” User Group Conference in Finland.
Finland in May
The question whether the PERL scripts for RMAN incrementally rolled forward backups we deliver via MOS Note 1389592.1 (11G – Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup) will be supported for migrations to non-Exadata systems such as Oracle SuperCluster as well.
And yes, now we got an update into the note saying:
Although preferred destination system is Linux (either 64-bit Oracle Linux or a certified version of RedHat Linux), this procedure can be used …
Continue reading...
