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...18.3.0
Oracle Database 18c on-prem for MS Windows is available
I know it got delayed a bit. But there’s a good reason for the delay. In addition, my post is a bit late as well but I was on vacation. Anyway, you can download it since Aug 22, 2018. Oracle Database 18c on-prem for MS Windows is available.
Oracle Database 18c on-prem for MS Windows is available
You can download it from oracle.com and eDelivery:
Start here with the Oracle 18c on Windows Installation Guide.
As far as I see, the certification information has not been …
Continue reading...Oracle ORAchk and EXAchk Version 18.3.0 are released
If you are a regular user of ORAchk and/or EXAchk, you should download the most recent and newest version as Oracle ORAchk and EXAchk Version 18.3.0 are released now.
Oracle ORAchk and EXAchk Version 18.3.0 are released
The new features you’ll find in ORAchk 18.3.0 and EXAchk 18.3.0 include:
|
Oracle Database 18.3.0 on SPARC Solaris is available
Usually I don’t post twice on a day, especially not on a Friday and not in the holiday season. But since last night, Aug 2, Oracle Database 18.3.0 on SPARC Solaris is available for download from OTN.
Oracle Database 18.3.0 on SPARC Solaris is available
You can download it from OTN:
And I couldn’t find it on eDelivery – where I find only the 18.1.0 version. But I simply may be not clever enough to use the right search phrase (I used “Oracle Database” as “18” leads to something different).
Further Information
… Continue reading...Oracle 18.3.0 on premises includes 1.4GB patches?
Oracle Database 18.3.0 on premises is available for download on Linux since July 23, 2018. The other ports will follow soon. And via twitter I received a question why Oracle 18.3.0 on premises includes 1.4GB patches?
Oracle 18.3.0 on premises includes 1.4GB patches?
When you unzip the downloaded database image:
then you may discover the following folder .patch_storage
of 1.4GB size:
[oracle@localhost .patch_storage]$ ls -lrt total 40 drwxr-xr-x. 4 oracle dba 4096 Jul 18 19:39 28090523_Jul_14_2018_00_03_50 drwxr-xr-x. 4 oracle dba 4096 Jul 18 19:40 28090553_Jul_11_2018_19_20_31 drwxr-xr-x. 4 oracle dba 4096 Jul 18 19:41 27923415_Jul_15_2018_10_33_22 drwxr-xr-x. 8 oracle dba 4096… Continue reading...
Oracle Database 18.3.0 Upgrade on premises
As Oracle Database 18c is now available on Linux on premises, I blogged about the installation already. And the next logical step is the Oracle Database 18.3.0 Upgrade on premises. In this case I will show an upgrade on the command line from Oracle 11.2.0.4 to Oracle 18.3.0. A DBUA upgrade will follow in a separate blog post later.
Oracle Database 18.3.0 Upgrade on premises
Before you can start with the upgrade, you may download the software first, and then install it:
- Oracle Database 18.3.0 on premises is available on Linux
- Oracle Database 18.3.0 Installation on premises
If …
Continue reading...Oracle Database 18.3.0 installation on premises
Oracle Database 18.3.0 is available on Linux since July 23, 2018. And I wanted to quickly sneak into the Oracle Database 18.3.0 installation on premises. I did blog about the Oracle 18c installation a few weeks ago but this was a plain 18.1.0. This time I install the 18.3.0 on-prem edition for Linux.
Oracle Database 18.3.0 installation on premises
Are the any differences between an 18.1.0 and the 18.3.0 installation? No, there aren’t any (at least not anything I recognized). The most important thing: you must unzip the downloaded file into your future destination directory.
In my case I …
Continue reading...Oracle Database 18.3.0 on premises available for download on Linux
Finally … it took a bit longer than expected and many people have mailed me in the past days. But Oracle Database 18.3.0 on premises available for download on Linux.
Oracle Database 18.3.0 on premises available for download on Linux
The other ports may follow soon after. I can’t give dates but you can download Oracle Database 18.3.0 on-prem for Linux now from OTN:
Follow this link to access the download location:
The download gets you the zip file but not the rpm. Those may take a couple of weeks for unknown reasons.
And …
Continue reading...Patching my databases with the July 2018 PSU, BP and RU
As usual I download the patch bundles and apply them to our Hands-On Lab environment as quickly as possible. First of all for the simple reason that I don’t want to trap into issues which are fixed already. Second for the reason that I always tell you: YOU MUST PATCH! But if I’m saying this over and over again, then I can’t have my own environments unpatched. And at third, because I want to learn if anything is not working correctly or has changed (see below).
Of course my tiny single instance environments are not comparable to your critical production …
Continue reading...Upgrade Oracle 12.2.0.1 to Oracle Database 18c on-premises
I’m currently refreshing our Hands-On Lab and will exchange Oracle 12.2.0.1 with Oracle 18.2.0. This blog post series is about how to Upgrade to Oracle 12.2.0.1 to Oracle Database 18c on-premises. There are other blog posts available you may use by yourself if you plan to refresh the lab by yourself until we uploaded a newer version. And it’s actually a good exercise.
- Deinstalling Oracle Database 12.2.0.1
- Installing Oracle Database 18.1.0
- Patching Oracle 18.1.0 to 18.2.0
- Upgrade Oracle 12.2.0.1 to Oracle Database 18c on-premises
For Multitenant upgrades from Oracle 12.1.0.2 to Oracle 12.2.0.1 you may read this:
… Continue reading...