We had several discussions on the internal mailing lists the other day about cloning with Pluggable Databases in Oracle 18c (or 18.104.22.168). And I blogged about this topic a while ago but realized I may need to refresh this a bit.
When I changed our Hands-On Lab to Oracle 18c, I encountered one strange issue in case I upgraded the UPGR database to 18.3.0 and wanted to plug it in afterwards. Before plugin I usually do a compatibility check. But this seems to fail. I checked my file, my paths, everything.… [ Read More ]
While I was writing the blog post about Creating CDBs and non-CDBs with less options I realized that Oracle Multimedia is deprecated in Oracle 18c – but I haven’t mentioned this here yet.
Oracle Multimedia was called Oracle Intermedia a long time ago when we introduced it back in the Oracle 8i days.… [ Read More ]
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.
The new features you’ll find in ORAchk 18.3.0 and EXAchk 18.3.0 include:
I wanted to write up this blog post a long time ago. When Helen Vanderheide did ask me a few weeks ago if she can omit
catoctk.sql during the creation of the database, I realized that I should update my previous blog posts about Creating CDBs and non-CDBs with less options.… [ Read More ]
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.
You can download it from OTN:
That’s a question I have gotten several times already: How long can you provision database version X in the Cloud? Meaning, is there a fixed date when you’ll be unable to provision an instance containing Oracle Database 22.214.171.124 for instance?
Thanks to my team mates, Cindy and Hector, who alerted me on this newly detected issue. When your database has been upgraded from release to release, it could happen that a public synonym
XMLCONCAT exists. And before you upgrade to Oracle 12.2.01 or Oracle 18c you must drop this public synonym to avoid upgrade errors.… [ Read More ]
Our doc team has put a lot of effort together with the help of my team mates and created these 9 Upgrade and Migration Scenarios as part of the official Oracle documentation.
The idea is to cut out the most common use cases and give a quick and comprehensive overview on all necessary steps.… [ Read More ]
Monday morning, another way-too-hot July day. Summer is crazy this year in Europe. We all enjoy nice sunny weather but nobody does enjoy a serious drought. Nowhere. While going through my inbox I spot this statement: ““Why should we go to 18.x with support till 2020?“. And this is not an unusual question.… [ Read More ]
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?
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.… [ Read More ]
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 126.96.36.199 to Oracle 18.3.0. A DBUA upgrade will follow in a separate blog post later.… [ Read More ]
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.… [ Read More ]
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.
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.… [ Read More ]
This is a Friday morning blog post. And actually I had no intention to write it. I don’t mean it offensive. But yesterday I received an interesting email from Frits Hoogland from Enkitec/Accenture. Frits asked me about the July RUR and some unlogic things on MOS. Once I had answered his email, the next question came in.… [ Read More ]
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.… [ Read More ]
Hurray, it’s patching day! I know, YOU did look forward to July 17, 2018 as it is patching day again. Last night we released the following Patches: July 2018 Update, Revision, BP and PSU.
First of all, I’m doing the usual check for the alert and the risk matrix to see whether there’s are really important security patches included.… [ Read More ]
Oh, I think it took us years to get rid of recommendations in MOS notes saying before this or that change you must take an offline backup. These recommendations dated back to times where not almost everybody was using RMAN for online backups. But the times have changed. Still, there are situations where the “Offline Backup” word can be mentioned.… [ Read More ]
Again I’ll have to thank my colleague Roland Gräff from the German ACS Support team in Stuttgart for bringing this into our radar. Roland alerted me a week ago about an issue with exports in Oracle 188.8.131.52 only when you are on a certain patch level. I summarize the issue here under Data Pump 184.108.40.206 – Wrong Dump File Version – ORA-39142.… [ Read More ]
Thanks to my support colleague Roland Graeff who told me about this issue at a customer today. And I consider this a pretty serious issue. It can happen that Special characters show junk in CLOB columns after upgrade to Oracle 220.127.116.11. with JDBC.
This is as bad as it sounds. Roland told me about a case where the application showed weird characters instead of German umlauts (ä, ö, ü, Ä, Ö, Ü) after an upgrade from Oracle Database 18.104.22.168 to 22.214.171.124.… [ Read More ]
The last Office Hours I’ve run about the New Release and Patching Model didn’t go very well technically. I’ve had screen/display issues. And Steven Feuerstein tried to save the best parts – but despite Steven’s awesome work neither him nor I did really like the result. So I decided that it may be better to record a Video: The New Database Release and Patching Model again (which I actually planned for quite a while already anyway.… [ Read More ]
I blogged a few days ago about Long Identifiers in Oracle Database 12.2 and accessing the objects via database links from lower database version. As this raised a few questions, I realized there may be a bit more clarification necessary. One question was about what happens during export with Data Pump and Long Identifiers.… [ Read More ]
It took a while – we know. But finally Oracle Fail Safe 4.2.1 is available for Oracle 12.2. You may not see the MOS notes being updated with certification information. Still you can download the software from oracle.com.
This version is certified with Oracle 126.96.36.199. You should be able to use it with Oracle 18c as well but we’ll add another certification notice soon.… [ Read More ]
LONG identifiers are one of the key features in Oracle Database 188.8.131.52. 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 184.108.40.206.… [ Read More ]