Uncategorized

Oracle Database 19c (19.3.0) for SPARC Solaris is available for download

Oracle Database 19c (19.3.0) for SPARC Solaris is available for downloadSince yesterday you can download Oracle Database 19.3.0 on premises for Linux. And as of today, 19c for SPARC Solaris 64bit is available, too.

Oracle Database 19c on premises for SPARC Solaris

You can download Oracle Database 19.3.0 on-prem for SPARC Solaris 64bit now from the usual sources:

Oracle 19c Documentation

And of course you can access the Oracle 19c Documentation from now on as well:

See especially the operating system dependent install guides:

Continue reading...

Collaborate 2019 – San Antonio, TX – Upgrade Talks and Labs

Collaborate 2019 - San Antonio, TX - Upgrade Talks and Labs

I have to be careful when posting something today. But this is actually not an April’s fool joke. Collaborate Conference is less than a week away. And for me this means: I’m going to Texas for the first time ever. And I hope to see you at Collaborate 2019 – San Antonio, TX – Upgrade Talks and Labs.

Texas?

Collaborate 2019 - San Antonio, TX - Upgrade Talks and LabsWell, stereotypes are great. I live in Bavaria but I’m actually from its Northern part called Franconia. Which belongs geographically to Bavaria but is different. But when you look from any other part of Germany towards its South, …

Continue reading...

DST Time Zone Patch V.32 and V.33 for Oracle 18.5.0

If you’d ever attended one of Roy’s or my workshops, you know that we talk about time zone adjustments after the database upgrade. We explain why this is important. But as everything, it depends if you really need to apply and adjust. In our workshops we recommend one single note for time zone adjustments: MOS Note:412160.1 . This note has been updated and republished. It contains DST V.32 and DST V.33 links and references. Amit Grover from AWS contacted me and told me about a potential dependency of DST patches to the Oracle Update such as RU 18.4.0 or 18.5.0.…

Continue reading...

Why is the October Patch Bundle from July?

Strange blog headline, isn’t it? Intentionally. Peter Lehmann mailed me a question – and asked more or less: Why is the October Patch Bundle from July? Sounds strange? It is strange …

Strange notation

Peter wanted to download the most recent patch bundle for Grid Infrastructure from October. And he found patch 28507693:

But he was wondering about the headline having the date of October 18, 2018 together with JUL 2018.

Why is the October Patch Bundle from July?

How does this make sense??

Flashback

When you flash back to the day when we introduced “Updates” (RU) and “Revisions” (RUR) you may remember that we release quarterly “Updates” …

Continue reading...

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. For ages, you could name a table or a column or a user or a package in Oracle with only 30 byte length. Hence, naming a table TAB_THIS_IS_MY_TABLE_AND_I_LIK is ok (30 byte – 30 characters) but naming it TAB_THIS_IS_MY_TABLE_AND_I_LIKE_IT is not possible as it requires …

Continue reading...

Happy New Year 2018!

Dear all,

there was silence on the blog for more than 2 weeks now. And 2018 started already. Let me wish you all a happy and exciting new year 2018. Stay safe and healthy, take care and all the best for 2018 to you, your families and friends!

Happy New Year 2018

Source: https://pixabay.com/en/design-2018-to-reach-new-year-3047520/

There will be more updates in the next few days 🙂

Happy New Year!
Mike…

Continue reading...

Can you simply switch from SE2 to EE with Oracle Multitenant

Oracle MultitenantThis question is coming up from time to time – and currently not covered in the official Oracle documentation as far as I know: “Can you simply switch from SE2 to EE with Oracle Multitenant?”

Yes, you can!

First of all, the switch is possible and tested. But you’ll have to satisfy a few requirements:

  • Both database versions must be the same
  • Both databases must have the same character set (in Oracle Database 12.1)

That’s it. Simply unplug your Standard Edition 2 PDB and plug it into your Enterprise Edition CDB.

In addition you may have to run several component …

Continue reading...

New version of preupgrade.jar (build 5) is available

There’s a new and improved version of the preupgrade.jar (build 5 – May 2017) available for download from MyOracle Support:

The same note will get you access also to the most recent builds of preupgrd.sql for upgrades to Oracle Database 12.1 and utlu112i.sql for the unlikely event you’ll have to upgrade a database to Oracle 11.2.0.4.

Please always exchange the version getting installed by default with the version we offer via MOS Note:884522.1 as the downloadable version is usually much newer and improved over the one getting deployed …

Continue reading...

PERL scripts for large migrations supported on all platforms (except Windows)

This topic fits very well as I present about +100 TB migrations today at the “Harmony” User Group Conference in Finland.

Finland May Helsinki 2017

Finland in May

The question whether the PERL scripts for RMAN incrementally rolled forward backups we deliver via MOS Note 1389592.1 (11G – Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup) will be supported for migrations to non-Exadata systems such as Oracle SuperCluster as well.

And yes, now we got an update into the note saying:

Although preferred destination system is Linux (either 64-bit Oracle Linux or a certified version of RedHat Linux), this procedure can be used

Continue reading...