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.
You may recognize the first change after downloading the image: The installation and configuration of Oracle Database software is simplified with image-based installation. You’ll extract a zip file (db_home.zip) into the directory where you’d like your Oracle installation to be located in – and then call the
runInstaller. Be aware: it sits now directly in the $ORACLE_HOME, not in the $ORACLE_HOME/oui subdirectory:
cd $ORACLE_HOME ./runInstaller
runInstaller is a script in this case. The name is kept for persistence.
Furthermore there are two other new features:
- RPM based installation in Oracle 18c
It performs preinstall checks, extracts the database software, reassigns ownership to the preconfigured user and groups, maintains the inventory, and executes all root operations required. Works for a single-instance and client software.
- Read-Only Oracle Home in Oracle 18c
In Oracle 18c you can configure read-only homes. In this case all the configuration data and log files reside outside the Oracle home. You can deploy it as a software image across multiple servers.Apart from the traditional
ORACLE_HOMEdirectories, the following directories contain files that used to be in
And interesting thing happens if you call the installer kept for internal purposes in
it will start with a different versioning, i.e. as an Oracle 12.2 OUI. The install script
runInstaller is in the
$ORACLE_HOME directory. And it will greet you with Oracle 18c – and not Oracle 12.2.
Yes, the deprecation of Oracle Streams has been announced in the Oracle Database 22.214.171.124 Upgrade Guide a while ago. And Oracle 18c is now the terminal release for Oracle Streams. Beginning with Oracle 19c the feature Oracle Streams won’t be supported anymore. Please note that Oracle Multitenant, regardless of Single- or Multitenant, never implemented Oracle Streams functionality.
Beginning with Oracle 18c Oracle Multimedia is deprecated now. In case you’d like to remove Oracle Multimedia from your database please see this blog post: Remove Oracle Multimedia. In addition, Multimedia DICOM gets desupported with Oracle 18c as well.
Please note (and thanks Felipe for asking):
The Locator will become a top level component once Oracle Multimedia gets removed and therefore not depend on Multimedia anymore. This will happen in the first release of Oracle where Multimedia does not get installed anymore by default or even removed as part of an upgrade.
Deprecated and Desupported Features in Oracle Database 18c
Please find the full list of deprecated features in Oracle Database 18c in the Database 18c Upgrade Guide. Furthermore you’ll find a list of desupported features and parameters in Oracle Database 18c within the same book.
If Oracle Multimedia is going to be unavailable in 19c, then does it mean that Locator will be deprecated as well?
The installation of Locator depends on the successful and proper installation of Oracle Multimedia. Oracle Multimedia is installed and configured with Oracle Database, although you can install Oracle Multimedia manually if necessary, as documented in Oracle Multimedia User’s Guide. During the installation of Oracle Multimedia, Locator is installed.
Starting in Oracle Database 18c, Oracle Multimedia is deprecated. This is the terminal release for Oracle Multimedia.
Oracle Multimedia is unavailable with Oracle Database 19c
that’s a very good question.
I’ll ask internally and get back to you as soon as I receive a reply.
here we go – and thanks for this question.
The locator will be available in 19c as a top level component and non-dependent on Multimedia.
We are an ISV, so just to confirm before we notify our customers. When 18c is available on-prem, they should continue installing Oracle Multimedia (even though it’s deprecated in 18c) to get Locator. Starting with 19c, they will need to install a new top level component to get Locator installed and/or upgraded, without having to install Multimedia. Is that correct?
I will find out – and I’ll blog about it as soon as I have more information.
And thanks again for all your questions – you raise very valid points which aren’t answered right now in the docs.
the database software rpms don’t seem to be available at the locations specified in the documentation (OTN, edelivery). Will these rpms be made available or is this a documentation bug? 😉
I think to remember that they may be available with 18.4.0. But there were some delays …
Sorry for the inconvenience,