Another surprise: DBMS_PDB in Oracle 11.2.0.4

Another surprise: DBMS_PDB in Oracle 11.2.0.4 2

ORA-1555 won’t get reported into alert.log anymore since 19.4.0

ORA-1555 won't get reported into alert.log anymore since 19.4.0 4

Pitfall: ORA-1843 – NOT A VALID MONTH in Oracle 19.4 – 19.8

Pitfall: ORA-1843 - NOT A VALID MONTH in Oracle 19.4 - 19.8 15

MGA Issue – and it is fixed with Oracle 19.8.0 and newer

MGA Issue - and it is fixed with Oracle 19.8.0 and newer 2

AutoUpgrade and the Partial Offline Backup Strategy

AutoUpgrade and the Partial Offline Backup Strategy 1

LAOUC Web Seminar: Oracle Multitenant – 3 PDBs and many secrets

LAOUC Web Seminar: Oracle Multitenant - 3 PDBs and many secrets 2

Cloud Migrations: The New Kid on the Blog – DOHDATABASE.com

0

Oracle AutoUpgrade between two servers – and Plugin?

Oracle AutoUpgrade between two servers - and Plugin? 4

Oracle AutoUpgrade between two servers

Oracle AutoUpgrade between two servers 14

AutoUpgrade with Transparent Data Encryption (TDE)

4

Another surprise: DBMS_PDB in Oracle 11.2.0.4

I think I should start a blog post series of surprises. At least, this time it’s not harmful at all. But it still a surprise. And ACE Director Rodrigo Jorge reported about it and did ask me for more details. So yes, here we have Another surprise: DBMS_PDB in Oracle 11.2.0.4.

DBMS_PDB

You use the package DBMS_PDB normally to create the so called XML manifest file which describes the physical layout of a PDB or future PDB. And it adds some markers. You can find the package since Oracle Database 12.1.0.1 …

Continue reading...

ORA-1555 won’t get reported into alert.log anymore since 19.4.0

Many thanks to a German customer for showing me this tiny behavior change with Oracle Database RU 19.4.0. From this RU on the well known ORA-1555 won’t get reported into alert.log anymore since 19.4.0. But if you still like to see the “snapshot too old” error, then you can use a workaround.

Why has this been changed?

Actually this is something I don’t understand completely. It may be just a side effect. Unpublished fix bug 29424999 – DUMP MINIMAL DIAGNOSTICS BY DEFAULT IN CASE OF ORA-01555 IN ADW/ATP ENV has been

Continue reading...

Pitfall: ORA-1843 – NOT A VALID MONTH in Oracle 19.4 – 19.8

Today, I’d like to write about a tiny little issue – which can cause some real trouble in Oracle 19c. This blog post is about the Pitfall: ORA-1843 – NOT A VALID MONTH in Oracle 19.4 – 19.8.

The Testcase

My testcase is super-simple – and you can reproduce it even without any object in 2 seconds (one for “copy“, the other for “paste“). Simply execute this query:

select to_date('20191120','RRMMDD') from dual;

Or this one where I replace “RR” with the more common “YY”:

select to_date('20191120','YYMMDD') from dual;
Continue reading...

MGA Issue – and it is fixed with Oracle 19.8.0 and newer

Where do I start? One of the customer accounts I worked the longest time with recently upgraded to Oracle 19c on Exadata. They are an Exadata customer since 2009. After going live on 19c, a few days later they hit an MGA Issue – and it is fixed with Oracle 19.8.0 and newer. But question no.1 was: Why hasn’t Oracle warned us – and how could we have learned about it?

MGA Issue - and it is fixed with Oracle 19.8.0 and newer

Photo by Scott Webb on Unsplash

What is the MGA?

OK, I have heard of SGA and PGA. But MGA? The first two hits when I search with …

Continue reading...

AutoUpgrade and the Partial Offline Backup Strategy

In our Fallback talk we promote a backup strategy for large DWHs and database which are on purpose in NOARCHIVELOG mode. But last week I learned that there is something important to know about AutoUpgrade and the Partial Offline Backup Strategy. Otherwise you may hit a

AutoUpgrade and the Partial Offline Backup Strategy

Photo by Esri Esri on Unsplash

pitfall.

 

Partial Offline Backup Strategy?

I won’t explain in all details what this is. If you’d like to read more, please find all the necessary information on my blog post from July 17, 2018:

with graphics included. In brief, you take …

Continue reading...

LAOUC Web Seminar: Oracle Multitenant – 3 PDBs and many secrets

Just a few hours left until I’ll start my LAOUC Web Seminar: Oracle Multitenant – 3 PDBs and many secrets today, Aug 17, 2020. I’m really looking forward to it even though it is a bit sad this time. Usually in the past years I was traveling to Latin America. And I enjoyed the intense discussions in Uruguay, Argentina and Brazil a lot. The local folks invest so much time in these yearly user group conferences. Hence, as for most other events as well, this year you’ll be able to participate virtually over multiple days.

LAOUC Web Seminar: Oracle Multitenant - 3 PDBs and many secrets

Oracle Multitenant – 3 PDBs

Continue reading...

Cloud Migrations: The New Kid on the Blog – DOHDATABASE.com

You may have realized that you will find mostly on-prem database upgrade and migration topics covered on my blog. Which doesn’t mean that you can’t use most of these techniques to migrate to the cloud either. But it’s really hard to write about everything in full detail. Hence, today I’d like to introduce you to Cloud Migrations: The New Kid on the Blog – DOHDATABASE.com. And no, I was never a fan of this American boyband from the 80s and 90s 😉

Cloud Migrations: The New Kid on the Blog - DOHDATABASE.com

Find Daniel’s blog at: https://dohdatabase.com

DOHDATABASE … huh?

Cloud Migrations: The New Kid on the Blog - DOHDATABASE.com

Daniel Overby Hansen

As you may have read a …

Continue reading...

Oracle AutoUpgrade between two servers – and Plugin?

In my previous blog post I demonstrated how you can upgrade with AutoUpgrade between two servers. This a very typical scenario where you get new server, often also with a newer operating system version installed. But I was wondering if you can use Oracle AutoUpgrade between two servers – and Plugin?

AutoUpgrade between two servers

Please see my previous blog post about all the details:

Upgrade and Plugin?

At the end of it, I was curious if I couldn’t just plugin afterwards. But I …

Continue reading...

Oracle AutoUpgrade between two servers

I try to catch up with missing AutoUpgrade posts. And I should have written this one a while earlier ideally. Just yesterday a colleague asked me about it. So it’s time now to describe how to use Oracle AutoUpgrade between two servers.

Oracle AutoUpgrade between two servers

Photo by Alex Motoc on Unsplash

Documentation

The Oracle Database 19c Upgrade Guide has this section about the scenario:

And you see that it consists of 5 steps:

  1. Run the -mode analyze step on source server
  2. Run the -mode fixups step on source server
  3. Shutdown and
Continue reading...

AutoUpgrade with Transparent Data Encryption (TDE)

I knew, one fine day I will have to dig into TDE. Resistance is futile. There were so many questions regarding AutoUpgrade with Transparent Data Encryption (TDE) in the past weeks and months. And the team is still working hard on a solution to make the non-CDB to PDB plugin flawless and automated for such cases. But I won’t cover the latter in this post here. I will solely focus on the database upgrade itself.

AutoUpgrade with Transparent Data Encryption (TDE)

Photo by Jason Dent on Unsplash

TDE?

Almost everybody of you reading this blog post may have more knowledge of Transparent Data Encryption than I. …

Continue reading...

Install and Patch in one single action with OUI

This is such a common case: You want to install a new Oracle Home and you’d like to apply the most recent patch bundle to it as well. But as we don’t officially offer Gold Images to download where the RU is included already, you have to do three tasks instead of one. But you can avoid this and Install and Patch in one single action with OUI.

Recommendation and 3 standard actions

We always recommend that you apply the most recent RU. Hence, usually you will download Oracle Database 19.3.0 from …

Continue reading...

Web Seminar MEA – Recap, Slides, Recording and Answers

A few weeks ago, on June 29, 2020, I delivered an Upgrade Web Seminar for the MEA region. Thanks a lot if your participated. And today I’d like to share with you for this Web Seminar MEA – Recap, Slides, Recording and Answers.

Web Seminar MEA - Recap, Slides, Recording and Answers

Photo by Nathan John on Unsplash

Recap

Thanks to those who found the time to participate. I enjoyed the hour a lot. And thanks also to my colleagues from Oracle Dubai who set up the session and handled the registration and the logistics.

Slides

You can download the slides for this session as usual from the Slides

Continue reading...

How to skip a Fixup in AutoUpgrade

In this blog post I’d like to demonstrate how to skip a fixup in AutoUpgrade. This can be very useful in cases where you know that an issue may happen. Recently we saw several cases with unexpected long runtime for the gathering of fixed objects stats.

How to skip a Fixup in AutoUpgrade

Photo by Warren Wong on Unsplash

Analyze Mode

During the analyze phase, AutoUpgrade creates a <SID>_checklist.cfg file. You will find it in your job’s prechecks subdirectory, e.g.

/home/oracle/logs/DB12/100/prechecks

My SID is DB12, and 100 is the job number.

This is how the db12_checklist.cfg looks in my example:

[SID]          [DB12]
==========================================
[container]          [DB12]
Continue reading...

More information on AutoUpgrade’s TARGET_PDB_COPY_OPTION

A few weeks ago I blogged about the 3 new parameter options to plugin a non-CDB right after the upgrade and make it a PDB. As I explained, you must create the receiving CDB by yourself. But from your emails and comments, we realized that the examples in the documentation are not sufficient. Hence, today I’d like to give more information on AutoUpgrade’s TARGET_PDB_COPY_OPTION parameter.

What does this parameter do?

At first, this AutoUpgrade parameter (not an init.ora parameter!) is optional. If you don’t set it, the NOCOPY option will be used. Your …

Continue reading...

Oracle Database In-Memory BASE_LEVEL Feature available since 19.8.0

These are absolutely exciting news. I found this email from our PM for Oracle In-Memory, Andy Rivenes, in my inbox this morning. Andy explained that with the database Release Update 19.8.0 the In-Memory BASE_LEVEL feature is now available. And you don’t have to purchase an extra license for it.

What is Oracle In-Memory?

So many things have been written and published about the In-Memory option. I’d rather link to this White Paper here (Oracle Database In-Memory with Oracle 19c) and put some additional links at the end of the blog post.

What is Oracle

Continue reading...

datapatch and OPatch documentation and MOS note

Did you ever ask yourself whether there is documentation available for OPatch and for datapatch? It is not easy to find. And you won’t find it under “Database” in the Oracle Bookshelf. So today I would like to guide you in this short blog post to the datapatch and OPatch documentation and MOS note.

OPatch? Datapatch?

Just to recap: You use OPatch (or opatchauto) to apply the binaries to an Oracle installation. As a result, you change the second or the third number of the release from Oracle 19.5.0 to Oracle 19.8.0. But …

Continue reading...

AutoUpgrade: Refresh Status Information automatically

I have heard and received this question several times. And I always pointed people to the status logs in AutoUpgrade’s logging directory. But I wasn’t aware how simple the monitoring can be. Kudos to my colleague Meir Burmanov from Oracle Israel for explaining me today how you can simply monitor AutoUpgrade: Refresh Status Information automatically.

Like it – and it’s very simple

This won’t be a long blog post. And maybe there are even more fancier ways to do the monitoring. But for me it does the job. And it is super simple. …

Continue reading...

Patching all my environments with the July 2020 Patch Bundles

Quarterly routine: When the new security alert get published, then it is patching time again. I’ll show you as usual how Patching all my environments with the July 2020 Patch Bundles works. And I heard your comments – in the next round in October, I will do this for GI and OJVM most likely, too. If not earlier …

And just an important annotation upfront: I patch in-place due to space issues. But in reality, you please patch always out-of-place with a separate home.

Security Alert July 2020

This is the Security Alert for

Continue reading...

Pitfalls: Connect to a PDB directly with ORACLE_PDB_SID

A few weeks ago I learned about the ability to connect directly into a PDB by using the environment variable ORACLE_PDB_SID. I blogged about it in Can you connect as SYSDBA without password into a PDB directly?. And today, I’d like to give you a bit more insights and warn you about the Pitfalls: Connect to a PDB directly with ORACLE_PDB_SID.

How does it work?

When I wrote the blog post Can you connect as SYSDBA without password into a PDB directly? I haven’t dug into the technique behind the ability …

Continue reading...

Windows Only: Upgrade to Oracle 18.10.0 fails with ORA-01722

Liron Amitzi reported this on his blog a few days ago already. And it is a very nasty tiny little issue happening with RUs where the second number of the release enters the two-digit-space, such as 18.10.0. At this point, on Windows Only: Upgrade to Oracle 18.10.0 fails with ORA-01722. This happens late in the upgrade phase.

What is the issue?

The problem here is a tiny little piece in %ORACLE_HOME\admin\catupstr.sql – a SUBSTR function is used in a way that it does not take into account a potential two-digit …

Continue reading...

Transportable Tablespaces – Example and strange error with a PDB

Yesterday I was browsing around for a useful simple example to test Transportable Tablespaces. A colleague mailed with the other day with a strange error message. The attempt to import into a PDB in Oracle 19c failed. My first thought: Oh, this is simple. But I failed, too. And even worse, I couldn’t find a single useful note in MyOracle Support (MOS) for ORA-31640, ORA-27037, Linux-x86_64 Error: 2 with Additional information: 7. So I decided to summarize this in Transportable Tablespaces – Example and strange error with a PDB.

A simple Transportable Tablespace

Continue reading...

Upgrade Seminars 2020 – Recap and Videos on-demand

Thank you for participating in our 4 Database Upgrade to Oracle 19c seminars in the past two weeks. There were over 800 questions during the seminars – and it was a good idea that we prerecorded them. This way, I could answer your questions as it was a more convenient time for me than for Roy. We enjoyed it a lot – and from the feedback I read, most of you enjoyed it, too. Now please read about Upgrade Seminars 2020 – Recap and Videos on-demand below.

The Slides

I uploaded all 4 decks …

Continue reading...

Collection of EBS upgrade information for Oracle Database 19c

This was the question I received the most often during the Virtual Classroom web seminars last week: “Can you say something about EBS upgrades with 19c?”. And I promised to publish a blog post about it. But as I’m not an EBS expert, I can only share a Collection of EBS upgrade information for Oracle Database 19c. For all further inquiries, please open an SR or get in touch with your Oracle contact.

Recap – EBS and Oracle 19c

In September 2019, right before Oracle Open World, we announced the certification of EBS …

Continue reading...

Upgrade Seminars 1 and 2 – A quick recap, slides download and more

Thank you for participating in the first two seminars. Roy and I did already the “Release and Patching Strategy” webinar on Tuesday, June 23. And today  “AutoUpgrade to Oracle 19c”. So it time for Upgrade Seminars 1 and 2 – A quick recap, slides download and more.

Upgrade Seminars 1 and 2 - A quick recap, slides download and more

Photo by v2osk on Unsplash

Slides Download

I uploaded the slides already to https://mikedietrichde.com/slides/#WEB2020. Of course, I will upload the other slide decks as well to the same location.

Seminar Recordings

As soon as the recordings page has been completed, we will send out an email. And I will post the links …

Continue reading...

Special characters show junk in CLOB columns after upgrade to Oracle 19.7.0 with JDBC

When you’d copy & paste the above title into a search engine, you may come across a very similar sounding blog post I wrote two years ago. Today, my dear colleague Dirk asked me on behalf of a customer if it’s possible that this bug is back in 19.7.0. Of course, I said “No”, for sure not. Bug 26380097 was fixed in Oracle 18c already. Gladly, Dirk insisted. So I checked the SR his customer opened.

And now I can write an unplanned blog post about Special characters show junk in CLOB columns

Continue reading...