Oracle

Web Seminar LUX: Upgrade / Migrate / Consolidate

Register and sign up here:

https://lnkd.in/dxY6E-h

Agenda :
πŸ“Œ 10:00am – Introduction
πŸ“Œ Release Strategy
πŸ“Œ Database Upgrade with AutoUpgrade
πŸ“Œ 5-minute break
πŸ“Œ Ensure Performance Stability
πŸ“Œ Move to Oracle Multitenant
πŸ“Œ 12:00pm – Conclusion

 

This event was planned originally in-person, but of course due to the current situation, it had to be transformed into a virtual 2 hour workshop hosted by Digora!

Hope to talk to you soon!

Mike…

Continue reading...

Fixed Objects Stats Gathering Fails – what do you do now?

A few days ago I blogged about what you could do when Fixed Objects Stats Gathering is slow in an upgrade process. You can skip the preupgrade gathering, and the postupgrade gathering does not happen anymore since the October 2020 version of AutoUpgrade. Still, I came across another issue the other day: Fixed Objects Stats Gathering Fails – what do you do now?

What happened?

Actually this is connected to the Fixed Objects Stats Gathering is slow in an upgrade case. The customer encountered an incredible long runtime. And the support engineer …

Continue reading...

Upgrade Essentials – Videos for the Virtual Classroom Series 2020

Roy, Daniel and I ran 6 workshops in our Virtual Classroom Series 2000 format. Each of them is between 90 and 120 minutes. This sounds quite long but of course you can scroll forward if you are interested in only a part of it. We consider those the Upgrade Essentials – Videos for the Virtual Classroom Series 2020. As as we now completed the 6th web seminar, it’s time for a short recap.

Is Upgrade that complicated?

Good question. If upgrade is so easy as we say, why do you need 6 virtual sessions …

Continue reading...

APAC OUG: AutoUpgrade to 19c and 21c

October 19-30 – APAC Virtual Groundbreakers Tour

Continue reading...

Which database version can be used with Grid Infrastructure 19c?

This will be a very short blog post today. But a colleague asked me this question just a few minutes ago: Which database version can be used with Grid Infrastructure 19c? And I realized that I neither put it on the blog yet nor did I bookmark it. But I answered this question several times already.

Which database version can be used with Grid Infrastructure 19c?

There are 4 sources I did check:

  • MOS Notes on MyOracle Support
  • Oracle Documentation
  • Certification Information on MyOracle Support
  • Database Upgrade Blog

At first, I answered with MOS

Continue reading...

Transportable Tablespaces: Keep tablespace files read-only

When you Transport Tablespaces, you may be aware of a change in behavior a long while ago. When your tablespace import has been finished, a tablespace will be taken read-write automatically. But there may be situations when you’d like the previous behavior. Now you can have this with Transportable Tablespaces: Keep tablespace files read-only.

Transportable Tablespaces: Keep tablespace files read-only

Photo by freestocks on Unsplash

Default Behavior

Since Oracle Database 12c a tablespace will be taken read-write once the meta data import has been completed automatically. This was different in previous database releases. We used the technique a long time ago for a telco provider …

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...

3 Live Seminars: Slides Download and Questions Seminar 1 answered

Thanks a lot to all of you who participated this week in the 3 live Seminars about Database Upgrade, Performance Stability and Multitenant. We were just overwhelmed but so many tuning in. And I hope you’ve enjoyed it. As promised here you’ll get more. So find here for all 3 Live Seminars: Slides Download and Questions Seminar 1 answered. Once the recordings are published, I will tell you via the blog of course as well.

Slides Download

Thanks again also to Laura Garcia Villareal from Oracle University. If you have more questions regarding …

Continue reading...

Oracle Multitenant: Be aware of the silent COMPATIBLE change

This topic is included in our Multitenant slides for a long time. But whenever I want to point somebody to the blog post, I realize that it’s not on the blog yet. Actually I discussed this topic recently during a customer visit again. It’s time to put it on the blog. When you use Oracle Multitenant: Be aware of the silent COMPATIBLE change.

Oracle Multitenant: Be aware of the silent COMPATIBLE change

Photo by Clint Patterson on Unsplash

Mixed version environments

When you work with Oracle Multitenant, the sooner or later you will have mixed version environments. This may be CDBs with Oracle 12.1.0.2 or Oracle 12.2.0.1 together with …

Continue reading...

Do we offer patched Gold Images already?

Internally we can use a Gold Image service at Oracle. I can download a zip with 19.6.0 included. But externally for you as customers, the download of 19.6.0 required that you download 19.3.0 at first, then apply 19.6.0 on top of it. But a day ago, a tweet by my Belgium friend Philippe Fierens caught my attention. Do we offer patched Gold Images already?

Do we offer patched Gold Images already?

Photo by Sergey Pesterev on Unsplash

What is a Gold Image?

Since Oracle 18c, the installation routine has changed to the better. You download zip file containing the Gold Image, you create a directory and

Continue reading...

January 2020 AutoUpgrade is available for download

All of you upgrading your databases with AutoUpgrade or planning to do so can now download the newest version of our AutoUpgrade tool. We are offering the 20191220 version. If you ask yourself why we release the December version in January 2020, there’s a simple answer. We do extensive system testing with it before releasing it to the public.

January 2020 AutoUpgrade is available for download

Photo by pixel | visuals – Patrick Humm on Unsplash

Download 20191220 AutoUpgrade

You can always download the newest and some previous versions of the AutoUpgrade tool via this note:

January 2020 AutoUpgrade is available for download

At the bottom of the …

Continue reading...

Welcome onboard: Daniel Overby Hansen as Cloud Migration PM

I’m very happy to announce that as of January 1, 2020 a new decade begins. And Daniel Overby Hansen joins our group as new Cloud Migration Product Manager. I worked with Daniel on the customer side at SimCorp for many years. When we had a job opening in our group, we were very happy when Daniel applied for the opportunity.

Welcome onboard: Daniel Overby Hansen as Cloud Migration PM

Photo by Nick Karvounis on Unsplash

Who is Daniel?

Welcome onboard: Daniel Overby Hansen as Cloud Migration PM

Daniel Overby Hansen – Senior Principal Product Manager – Cloud Migrations – Oracle

Daniel has many years of experience in building enterprise-grade software from the Danish global provider of financial software, …

Continue reading...

Great License News: Spatial and Graph, Machine Learning

Just this week in Brighton at TechFest19 by UKOUG I’ve heard one of the common complaints about our license strategy. Something I can’t comment in my position. But even better that we are announcing some very good news now. Oracle is listening. It is a reaction to customer’s wishes.

Great License News: Spatial and Graph, Machine Learning

Photo by pxoxo on Unsplash

Spatial and Graph

Effective December 5, 2019, Oracle Spatial and Graph (OSG) option will be included with Oracle Database. This will affect Enterprise Edition, SE2 and Database Cloud Service (DBCS) Standard Edition 2 and Enterprise Edition. This means, you can use Spatial and Graph in all …

Continue reading...

Video: Best Practices to Upgrade to Oracle Database 19c

This is a short “Black Friday” blog post. And just if you are tired already of hunting supposed-to-be-bargain-buys, you may need something to relax – and watch this Video: Best Practices to Upgrade to Oracle Database 19c.

Video: Best Practices to Upgrade to Oracle Database 19c

Roy recorded it as part of the Quest Experience Week. We’d like to share it with you here.

Just click on the picture below to open a new TAB and watch the 1 hour video:

 

If you are looking for the slide deck, you can download them from:

Thanks!

–Mike…

Continue reading...

Upgrade / Migrate / Consolidate to 19c – Dubai, VAE

Upgrade / Migrate / Consolidate to Oracle 19c – Dubai, VAE

Oct 14, 2019 – 9:30h-16:30h

Oracle VAE, Dubai Internet City, Building 6, first floor, Jumeirah 1/2

Agenda:

Start: 9:30h

  • Release Model and Patching – Strategies and Best Practices
  • Upgrade to Oracle Database 19c
    • Includes Demo
    • Includes the new AutoUpgrade tool
    • Includes customer example on how to upgrade 150 databases in 2 weeks

Coffee Break: 11:00h – 11:15h

  • Ensure Performance Stability
    • General guidelines
    • SQL Tuning
    • SPM (SQL Plan Management)
    • Real Application Testing (SQL Performance Analyzer and Replay)
    • Performance Comparison before -/- after
  • Migration techniques overview
    • On-prem and to the Oracle
Continue reading...

Database Migration from non-CDB to PDB – Overview

Today I’ll start a blog post series of several “how to” articles about database migration from non-CDB to PDB – Overiew. You’ll find a quick introduction below. And of course, the links to all the other related blog posts.

Database Migration from non-CDB to PDB – Overview

When you plan to move from non-CDB, the Oracle term for regular database deployments, to a Pluggable Database (PDB), you will migrate your database. It will become a PDB and run as part of a Container Database (CDB). This is a well known concept for several years now called Oracle Multitenant. If you …

Continue reading...

AutoUpgrade: Where do you find all the logfiles?

AutoUpgrade: Where do you find all the logfiles?In the previous blog posts you could read about how to create the configuration file, adjust it and tweak the init parameters for the AutoUpgrade tool. And then I described the different modes of it. In this blog post I’d like to give you some insights into AutoUpgrade: Where do you find all the logfiles?

AutoUpgrade: Where do you find all the logfiles?

AutoUpgrade – Step-by-step

  1. The new AutoUpgrade Utility – Download, documentation and supported versions
  2. Create and adjust the config file for AutoUpgrade
  3. Config file for AutoUpgrade – Advanced options
  4. Config file for AutoUpgrade – Tweaking init parameters
  5. AutoUpgrade: ANALYZE, FIXUPS, UPGRADE and DEPLOY modes
  6. AutoUpgrade:
Continue reading...

Yatra 2019 – Oracle Groundbreakers: Roy Swonger travels to India

In April in Vienna a colleague from the US asked me: “Is Roy serious to travel to India in July?”. He mentioned the temperatures, the humidity – and the rain. But Roy is serious – and while I’m writing this, he should be already on his wayΒ  to India to present about Upgrade and Migrations in 5 locations at Yatra 2019 – Oracle Groundbreakers: Roy Swonger travels to India.

Yatra 2019 - Oracle Groundbreakers: Roy Swonger travels to India

Why you need to attend?

The organizers have listed 6 fine reasons for attending Yatra on the official Yatra 2019 conference page. And I’m adding another one: You want to …

Continue reading...

Oracle Database 19c (19.3.0) for HP-UX and AIX is available for download

Oracle Database 19c (19.3.0) for HP-UX and AIX is available for downloadFor a few days, in addition to Linux and SPARC Solaris, Oracle Database 19c (19.3.0) for HP-UX and AIX is available for download now as well. The missing platforms, Windows, Intel Solaris and zLinux should be available soon as well.

Oracle Database 19c on premises for HP-UX and AIX

You can download Oracle Database 19.3.0 on-prem for HP-UX ia64 and IBM AIX from the usual sources:

Oracle 19c Documentation

And of course you can find the Oracle 19c Documentation here:

See especially the operating …

Continue reading...

Oracle GoldenGate 19c is available for download for Linux

Oracle GoldenGate 19c is available for download for Linux

Photo by Raquel Stanton on Unsplash

I have a good numbers of customers waiting for it – and since two days Oracle GoldenGate 19c is available for download for Linux. You can download it from the usual sources. The other platforms should follow soon.

Download Sources for Oracle GoldenGate 19c

Certification for Oracle GoldenGate 19c

New Features and Documentation

For a list of new features in Oracle GoldenGate 19c see the list in the documentation – and of course, the most important feature is …

Continue reading...

Oracle 18.4.0 installation on AIX may fail with ORA-40238

Oracle 18.4.0 for IBM AIX is available since mid November 2018. But I’ve received several emails from people saying that Oracle 18.4.0 installation on AIX may fail with ORA-40238. And it’s true, this can happen. But there’s a simple workaround which unfortunately is not in the documentation yet. We’ll take care that it will be added soon.

Oracle 18.4.0 installation on AIX may fail with ORA-40238

Oracle 18.4.0 installation on AIX may fail with ORA-40238

First of all, this is an error pattern you may see on IBM AIX only. You may receive the following error message either during installation or startup of ASM or any …

Continue reading...

Does OJVM patching require a specific Database Release Update?

This question came up several times in the past days: Does OJVM patching require a specific Database Release Update? People mentioned that there’s a significant difference between the OJVM Patch Readme between Oracle 12.2.01 and Oracle 18.4.0.

Does OJVM patching require a specific Database Release Update?

Photo by Jimmy Ofisia on Unsplash

What’s the point?

In the OJVM (Oracle Java Virtual Machine) Patch Readme for Oracle Database 12.2.0.1 a sentence clarified that you can combine different states of OJVM and Database patch bundle with each other. Your database home could have been patched with the April 2018 Update, whereas you decided to apply the October 2018 OJVM patch.

The …

Continue reading...

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

Oracle Database 18.3.0 on SPARC Solaris is availableOracle 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. But I simply may be not clever enough to use the right search phrase (I used “Oracle Database” as “18” leads to something different).

Further Information

Continue reading...

July 2018 Update, Revision, BP and PSU

July 2018 Update, Revision, BP and PSUHurray, 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. For the risk matrix you’ll have to scrooooooooooolllll down quite a bit as the list of products is strictly alphabetically ordered:

Continue reading...

upobjxt.lst lists Oracle Supplied Objects

I blogged about upobjxt.lst lists Oracle Supplied Objects a while ago. But I thought it’s time to refresh this blog post a bit and adjust it to be more useful. upobjxt.lst displays the Oracle Supplied Objects since Oracle Database 12.1.0.1.

upobjxt.lst lists Oracle Supplied Objects

upobjxt.lst lists Oracle Supplied Objects and Users

You can access upobjxt.lst simply with an external table.

  1. Create a directory object:
    CREATE OR REPLACE DIRECTORY ext_tab_data AS '/u01/app/oracle/product/12.2.0.1/rdbms/admin/';
  2. Define the external table to query it:
    CREATE TABLE oracle_supplied_obj_ext (
    owner Β  Β  Β  VARCHAR2(31),
    name Β  Β  Β  Β VARCHAR2(127),
    placeholder VARCHAR2(20),
    object_type NUMBER
    )
    ORGANIZATION EXTERNAL (
    TYPE ORACLE_LOADER
    DEFAULT DIRECTORY ext_tab_data
    ACCESS PARAMETERS (
    RECORDS DELIMITED 
Continue reading...