Oracle Database 18c

Bug Fixing Support for Oracle 18c ends June 30, 2021

Time flies so quickly. I remember when we had intense discussions with a very large automotive customer whether they should use Oracle 18c, or rather wait for Oracle 19c. They went straight to Oracle 19c. But I know that many customers out there are still on Oracle 18c. So this date coming up in less than 3 weeks is very important for you. Bug Fixing Support for Oracle 18c ends June 30, 2021.

Oracle Database 18c

I quickly checked on my blog. On March 20, 2018 I wrote When will Oracle Database 18c

Continue reading...

Messaging Gateway – Upgrade can’t find mgwu122.sql

Thanks to Christian Ballweg from Optiz Consulting who brought this issue to my attention. I haven’t seen it before since I haven’t installed it but you may encounter this if you have the Messaging Gateway – Upgrade can’t find mgwu122.sql.

What is the Messaging Gateway?

Actually I steal this from the documentation:

Messaging Gateway enables communication between applications based on non-Oracle messaging systems and Oracle Database Advanced Queuing.

Oracle Database Advanced Queuing provides propagation between two Oracle Database Advanced Queuing queues to enable e-business (HTTP through IDAP). Messaging Gateway extends

Continue reading...

Oracle 18c Express Edition (XE) for Windows is available

Oracle 18c Express Edition (XE) for Windows is availableOracle 18c Express Edition (XE) for Windows is available for download as of now. Oracle XE 18c on other platforms is available since November 2018. As of now you can download the Windows version as well.

Use the Quick Start guide which explains the installation and how to connect to the database.

General availability of Oracle Database 18c Express Edition on Windows!

Whether you are a developer, a DBA, a data scientist, an educator, or just curious about databases, Oracle Database 18c Express Edition (XE) is the ideal way to get started. You will get the same powerful Oracle …

Continue reading...

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. It of course has some restrictions. And you can’t get support for it. If you need support for anything, please visit the Community Forum. But it’s pretty cool Oracle database with …

Continue reading...

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

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...

New August 2018 preupgrade.jar for upgrades to 18c and 12.2.0.1

My team mates worked hard to improve release the new August 2018 preupgrade.jar for upgrades to 18c and 12.2.0.1. You can download both from myOracle Support.

New August 2018 preupgrade.jar for upgrades to 18c and 12.2.0.1

As usual, MOS Note: 884522.1 gives you access to the most recent versions of the preupgrade.jar tools (and of course the previous preupgrd.sql and utlu112i.sql scripts). One of the major changes is the inclusion for a check for the XMLCONCAT synonym.

Please find the most recent versions here and exchange your current version of preupgrade.jar with the newer ones.

New August 2018 preupgrade.jar for upgrades to 18c and 12.2.0.1

MOS Note: 884522.1 –

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:

Oracle 18.3.0 on premises includes 1.4GB patches?

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...

When will Oracle Database 18c be available on-prem?

When will Oracle Database 18c be available on-prem?When will Oracle Database 18c be available on-prem? Some of you will answer: It is available already, isn’t it? And you are right. But I don’t want to blog just a marketing message but some facts. Others may ask: When will it be generally available on-premises?

==> July 23, 2018: Linux 18.3.0 on-prem is available – please click here <==

When will Oracle Database 18c be available on-prem?

As of today, March 20, 2018, Oracle Database 18c is available already in/for:

Actually …

Continue reading...

Oracle Database 18c – Some important changes

I know that Oracle Database 18c is available in the Oracle Cloud and on Exadata engineered systems only right now. But actually I’ve had conversations with some customers who downloaded Oracle 18c on-prem software for Exadata and installed it on their systems. Therefore it may be useful to talk about Oracle Database 18c – Some important changes.

Oracle Database 18c – Some important changes

I will highlight some important changes but of course won’t cover all of them here.

Installation

You may recognize the first change after downloading the image: The installation and configuration of Oracle Database software is simplified …

Continue reading...

Oracle Database 18c released for Oracle Cloud and Engineered Systems

Oracle Database 18c has been released Friday, February 16, 2018 in the Oracle Cloud and for Engineered Systems.

Oracle Database 18c released for Oracle Cloud and Engineered Systems

What is new in Oracle Database 18c?

Please read this comprehensive description by Dominic Giles, Master Product Manager for Oracle Database on https://blogs.oracle.com/database/oracle-database-18c-:-now-available-on-the-oracle-cloud-and-oracle-engineered-systems. Dominic summarizes the most important features in the areas of Multitenant, In-Memory, Sharding, Performance, High Availability, Security, Spatial/Graph and of course Developer features.

You’d like to read more about New Features?

In case you’d been now interested please see the New Features Guide for more details in Oracle Database 18c.

Well, and there’s not only a New Features …

Continue reading...