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 ]
Oracle Multimedia is deprecated in Oracle 18c
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 is deprecated in Oracle 18c
Oracle Multimedia was called Oracle Intermedia a long time ago when we introduced it back in the Oracle 8i days.… [ Read More ]
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:
|
Creating CDBs and non-CDBs with less options
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 ]
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.… [ Read More ]
How long can you provision database version X in the Cloud?
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 12.1.0.2 for instance?
How long can you provision database version X in the Cloud?
… [ Read More ]Drop public synonym XMLCONCAT prior to upgrade
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 ]
9 Upgrade and Migration Scenarios
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 ]
Clarification: Support Periods for Oracle 12.2.0.1 and 18c
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 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.… [ Read More ]
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.… [ Read More ]
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.… [ Read More ]
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.… [ Read More ]
ZDLRA ready for Oracle Database 18c
ZDLRA is one of the best acronyms ever. It took me 5+ years to not mix up the sequence of characters 🙂 And even Larry made a joke about the name a while ago at his OOW keynote (I think it was 2016). ZDLRA stands for Zero Data Loss Recovery Appliance.… [ Read More ]
July 2018 Update, Revision, BPs, PSUs – delays and other issues
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 ]
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.… [ Read More ]
July 2018 Update, Revision, BP and PSU
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.
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 ]
Fallback Strategy: Partial Offline Backup
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 ]
Data Pump 12.1.0.2 – Wrong Dump File Version – ORA-39142
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 12.1.0.2 only when you are on a certain patch level. I summarize the issue here under Data Pump 12.1.0.2 – Wrong Dump File Version – ORA-39142.… [ Read More ]
Special characters show junk in CLOB columns after upgrade to Oracle 12.2.0.1 with JDBC
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 12.2.0.1. 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 12.1.0.2 to 12.2.0.1.… [ Read More ]
Video: The New Database Release and Patching Model
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 ]
Export with Data Pump and Long Identifiers
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 ]
Oracle Fail Safe 4.2.1 is available for Oracle 12.2
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 12.2.0.1. You should be able to use it with Oracle 18c as well but we’ll add another certification notice soon.… [ Read More ]
Long Identifiers in Oracle 12.2 may cause trouble
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.
What are Long Identifiers?
Long identifiers get introduced with Oracle Database 12.2.0.1.… [ Read More ]
_optimizer_ignore_hints is now optimizer_ignore_hints
I’m refreshing our Hands-On Lab for Oracle Database 18c. And as part of a performance evaluation I wanted to set an underscore parameter to ignore all hints my load test tool sets. But then I learned: This does not work anymore as _optimizer_ignore_hints is now optimizer_ignore_hints. We made the underscore obsolete in Oracle Database 18c.… [ Read More ]