Migration

The new Oracle 19c Hands-On Lab is available

Well, it’s been a while since we refreshed the lab being downloadable via this blog. But finally, the new Oracle 19c Hands-On Lab is available – you can download it as of now.

What’s new in the lab?

First of all, the biggest change you’ll see is that the operating system is now Oracle Linux 7. Well, to be honest, I’m not a die-hard Linux expert and you may find my setup a bit creepy. Feel free to exchange things or adjust them – or drop me a message if you think that adjustments should be made. And of … [ Read more ]

OOW 2018: How to Migrate to Oracle Autonomous Database Cloud

OOW 2018: How to Migrate to Oracle Autonomous Database Cloud

And last but not least our forth talk at OOW 2018: How to Migrate to Oracle Autonomous Database Cloud on Tuesday, Oct 23 at a fairly late slot at 5:45 p.m. (or 17:45h) as well in Moscone West 3004.

What is this talk all about?

It’s about the Oracle Autonomous Database cloud. But not so much about the Cloud offering itself. There are other talks covering this topic. We are the upgrade and migration guys. Hence, in this talk my boss, Roy Swonger and my PM mate Bill Beauregard will demonstrate you in a live demo how to migrate … [ Read more ]

OOW 2018: Cloud Migration from AIX to ExaCC – for DBAs and managers

OOW 2018: Cloud Migration from AIX to ExaCC - for DBAs and managers

Yes, OOW starts next week. And I’d like to introduce the third of our 4 talks. And let me say upfront about this talk at OOW 2018: Cloud Migration from AIX to ExaCC – for DBAs and managers. This is not the usual “cloud” talk 🙂 The official title is: Oracle Database Cloud Migration: Fast, Simple, Universal. Well, we should discuss the “simple“. But that’s why you want to see this talk. It will happen on Thursday, 9:00 a.m.. Hence, remember to leave the party the night before not too late. You need to be awake when … [ Read more ]

OOW 2018: Upgrade to Oracle 18c – Live and Uncensored

OOW 2018: Upgrade to 18c - Live and Uncensored

Less than two weeks until the potentially busiest Oracle Open World conference I’ve ever attended. The schedule is filled up already and closed down. And I’m pretty sure I will need time off afterwards to relax and recover. But I’m looking forward to our annual big event in San Francisco. To make it as exciting as possible for you we are very happy to have high profile speakers with us in all our talks. And we promise: No marketing. Just tech facts. If you’d like to sneak into OOW 2018: Upgrade to 18c – Live and uncensored, then mark … [ Read more ]

Office Hours: Upgrade and Migrations – September 20, 2018

It’s time for the next Office Hours: Upgrade and Migrations – September 20, 2018. This time Roy and Bill will run it as I’m traveling. And they’ve set it on purpose to a convenient time for the Americas. Roy has prepared a few slides upfront – and then it’s your time for questions.

Office Hours: Upgrade and Migrations - September 20, 2018 Office Hours: Upgrade and Migrations – September 20, 2018

You simply sign-up via this link:
https://asktom.oracle.com/pls/apex/f?p=100:551:::NO:551:P551_CLASS_ID:1382:
Click the big petrol colored Sign Up to Subscribe button to the right.

Topic for this week

The next edition of upgrade & migration office hours will start with a short … [ 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.

9 Upgrade and Migration Scenarios

The idea is to cut out the most common use cases and give a quick and comprehensive overview on all necessary steps.

9 Upgrade and Migration Scenarios

These comprehensive 9 scenarios cover non-CDB and PDB/CDB as well as changing to new hardware:

  • Migrating and Converting Non-CDBs to a PDB with a Different Endian Operating System
    HTML
    PDF
  • Migrating Non-CDBs to New Hardware with a Different
[ Read more ]

Upgrade Hands-On Lab – Oracle Database 12.2.0.1 – May 2018

Roy just uploaded a newer version of our Upgrade Hands-On Lab – Oracle Database 12.2.0.1 – May 2018.

The previous version had – I believe – and early drop of Oracle 12.2.0.1 installed. And recently somebody complained that certain Multitenant operations such as Hot Cloning with Oracle Database 12.2.0.1 don’t work but result in errors. Therefore, we updated it.

Upgrade Hands-On Lab – Oracle Database 12.2.0.1 – May 2018

The size requirements unfortunately are still the same. Your machine should have 8GB of RAM and you will need a bit more than 60GB free space on disk. You “could” run … [ Read more ]

Upgrade Office Hours: June 20, 2018 – 14:00 CET – The New Release Model

Well, time really flies. And I just realized this morning: It’s time to promote our next session for the Upgrade Office Hours: June 20, 2018 – 14:00 CET – The New Release Model. Yes, Wednesday next week. Time to let us know your questions upfront. BE AWARE: WE HAD TO CHANGE THE BEGIN TIME FROM 11:00 CET to 14:00 CET

Upgrade Office Hours: June 20, 2018 – 14:00 CET – The New Release Model

Roy, Bill and I have taken a decision to alter the begin dates for the upcoming Office hours. This time it is more easier for customers … [ Read more ]

Upgrade and Migration Office Hours on March 21, 2018

Upgrade and Migration Office Hours on Mar 21, 2018The first Office Hours Session was just a month ago. It was a very good experience and based on the feedback we received from customers it was very helpful. You don’t believe it? Then you may watch the recording. But now it’s time for our second Upgrade and Migration Office Hours on March 21, 2018.

What are “Office Hours”?

This is a new interactive format we’d like to try out. Several groups in Oracle schedule Office Hours sessions. Roy and I held our first Office Hours session on February 21, 2018 for a full hour trying to answer … [ Read more ]

Upgrade and Migration – Office Hours – Feb 21, 2018

Sign up for our first Upgrade and Migration Office Hours Session on February 21, 2018:

https://asktom.oracle.com/pls/apex/f?p=100:551:::NO:551:P551_CLASS_ID:3201:

Time:

UTC 02:00 PM February 21 2018
US/Eastern 09:00 AM February 21 2018
Asia/Hong_Kong 10:00 PM February 21 2018
Australia/Sydney 01:00 AM February 22 2018
Asia/Calcutta 07:30 PM February 21 2018
Europe/London 02:00 PM February 21 2018
Europe/Berlin 03:00 PM February 21 2018
US/Pacific 06:00 AM February 21 2018

 

Share this:
[ Read more ]

Upgrade and Migration Office Hours on Feb 21, 2018

Upgrade and Migration Office Hours on Feb 21, 2018

Thanks to the team of Steven Feuerstein who built up the framework for a new interactive format, the Office Hours. You can sign up now for our first Upgrade and Migration Office Hours on Feb 21, 2018.

What are “Office Hours”?

This is a new interactive format we’d like to try out. Several groups in Oracle schedule Office Hours sessions. Roy and I will be available during our first Office Hours session on February 21, 2018 for a full hour trying to answer your questions regarding database upgrades and migrations live and directly.

How do you sign up?

First … [ Read more ]

OOW 2017 – Slides Download: Migrate 100 TB databases in less than one day

I was shocked. Positively. We’ve had a packed room on Wednesday at Oracle Open World 2017 for our talk together with Jay Barnhart of Centric Consulting on How to Migrate 100 TB databases in less than one day. And we’ve had so much fun. Thanks for coming by, thanks for being so active. This makes all the travel and the stress really worth it.

OOW 2017 – Slides Download: Migrate 100 TB databases in less than one day

I gave a quick overview about all Transportable Tablespaces techniques, about how to use the PERL scripts to deal with very … [ Read more ]

OOW 2017 – Slides Download: Migrate to the Oracle Cloud

Thanks for coming to Roy’s and Julian Dontcheff‘s presentation about How to migrate to the Oracle Cloud – 13 different techniques and customer experiences on Tuesday at Oracle Open World 2017. The talk was very well attended, I saw many people taking pictures and notes.

OOW 2017 – Slides Download: Migrate to the Oracle Cloud

Personally I liked the talk a lot as it gives a very good (and very rare) complete overview on techniques how to migrate to the Oracle Cloud, advantages, use cases, database versions, where to use it. This all garnished with the experience Accenture has … [ Read more ]

Oracle Open World 2017: Must see sessions for UPGRADE / MIGRATION / CONSOLIDATION

Oracle Open World 2017: Must see sessions for UPGRADE / MIGRATION / CONSOLIDATION

Just a few days to go … I’ll be on my way to San Francisco soon for my tenth or eleventh Oracle Open World Conference 2017 soon. And I look forward to it. Roy has compiled a Focus-On document for Oracle Open World 2017: Must see sessions for UPGRADE / MIGRATION / CONSOLIDATION

  • Upgrades
  • Migrations
  • Consolidation with Multitenant
  • Patching
  • The new release model
  • Our talks and labs of course
Oracle Open World 2017: Must see sessions for UPGRADE / MIGRATION / CONSOLIDATION

Please find the Focus-On Upgrades and Migrations page here:

https://events.rainfocus.com/widget/oracle/oow17/1505826559931001NQPG

Register for our talks and labs at OOW

[ Read more ]

DOAG Noon2Noon – Upgrade/Multitenant – 2.-3.2.2017

++++++ Sorry – this is a German event only thus I will write in German ++++++

.

DOAG Noon2Noon

Ich bin schon sehr gespannt.

Am 2. Februar 2017 wird im Intercity Hotel in Mainz das DOAG Noon2Noon zum Thema “Upgrade, Migration und Multitenant” stattfinden. Von 12:00h mittags bis 12:00h mittags am Folgetag. Der Praxisbezug steht im Vordergrund. Garniert mit kurzen Vorträgen.

In der praxisorientierten “Noon2Noon”-Veranstaltung wollen wir uns mit den Herausforderungen beim Upgrade nach Oracle 12c bzw. Oracle 12c Release 2 (falls diese zu diesem Zeitpunkt für On Premises Datenbanken freigegeben ist) auseinandersetzen. Das ungewöhnliche Format zielt auf Lösungsorientiertheit. Bei

[ Read more ]

Upgrade to Oracle Database 12.2 – Slides are available

The workshops in Brussels and Utrecht were awesome with great audience – I enjoyed both events a lot. And thanks for your patience with my voice and the microphone issues we’ve had in Brussels before lunch.

I promised the workshop slides – and here they are, ready for download:

Upgrade, Migrate and Consolidate to Oracle Database 12.2 and the Cloud

Slides Oracle 12.2 Upgrade Migrate Consolidate

Please be aware: It’s the first drop of the slides, not everything has been updated yet for Oracle Database 12.2, and of course there are no 12.2 customer examples in the slides yet. But as usual, if you … [ Read more ]

Full Transportable Export/Import – Things to Know

This blog post is an addition to:

Seth Miller commented the pitfall of having a serious issue during the Data Pump run, Data Pump exiting and not finishing, and you’ll have to do the entire backup/restore/incremental-roll-foward thing again. Without any doubt, this is no fun at all.

So let me point out a few things to take into consideration – and some of them are not obvious I guess.

Do you need to backup/restore/incremental-roll-forward again?

When you let do Data Pump all the manual … [ Read more ]

Full Transportable Export/Import – Migrating an 11.2.0.4 database to Oracle Database 12c- into the Oracle Cloud

Full Transportable Export/Import – one of the coolest features in Oracle Database 12c 

We blogged about Full Transportable Export/Import a while back. It is – no doubt – one of the coolest features in Oracle Database 12c. And it is part of our Hands-On Lab exercise (Hands On Lab – Upgrade, Migrate, Consolidate to Oracle Database 12c) as well.

It utilizes the technique of Transportable Tablesspaces – cross-platform, cross- Endianness, cross-version – but lets Oracle Data Pump do all the “dirty” work of rebuilding everything kept in your SYSTEM and SYSAUX tablespace including views, synonyms, public objects, … [ Read more ]

Migration IBM AIX ==> SPARC Solaris with Data Guard

Can we migrate our database with Oracle Data Guard?

We are getting this question asked quite often during our workshops or via email. And if you are staying within the same operating system family (such as Red Hat 5.8 to OL 7) all is fine, and this is one of the best and most simple approaches to jump between servers. Even when you add a subsequent database upgrade all is very straight forward.

But what if you mix operating systems?

The Support Note for Heterogeneous Data Guard Configurations explains which combinations are allowed beginning with specific releases:

MOS Note: 413484.1 [ Read more ]

Migration of an EM Repository cross-platform?

Can you migrate your EM Cloud Control Repository to another OS platform? Cross-platform and cross-Endianness?

This question sounds so incredibly simple that you won’t even start thinking I guess. Same for ourselves. Use Data Pump. Or Transportable Tablespaces. Or Full Transportable Export/Import if your source is at least 11.2.0.3 or newer.

But sometimes in life things seem to be simple, but as soon as you unmask them you’ll find a full bunch of issues. It’s a fact that the repository of EM Cloud Control is quite a bit complicated. And uses plenty of databases technologies.

Actually all credits go to [ Read more ]

Simplify your Migration from AIX to Solaris

Oracle Solaris 11There is a brand new white paper available that will be of interest to anybody contemplating a database and/or application migration from AIX to Solaris. Simplify the Migration of Oracle Database and Oracle Applications from AIX to Oracle Solaris gives a good description of the steps involved in planning and executing a migration project, along with the benefits you can expect to achieve and a solid example of migration using Oracle Data Pump, complete with scripted steps.

Share this:
[ Read more ]

Migration of a database from 32bit to 64bit

Database migrations from an 32bit environment to an 64bit environment keeping the same platform architecture (e.g. moving an Oracle 10.2.0.5 database from MS Windows XP 32bit to MS Windows Server 2003 64bit) does not happen that often anymore. But still we see them getting done. And there are a few things to note when doing such a move.

First of all the important question is:
Will you upgrade your database as part of this move – Yes or No?

If you say “Yes” then you are almost done with that topic as we will take care of … [ Read more ]

Move to Locally Managed Tablespaces

As I’ve got asked during the workshop in Warsaw how to migrate Dictionary Managed to Locally Managed tablespaces here’s some additional information and an example.

To find out if a tablespace is dictionary or locally managed you’d use this query:

SQL> select
TABLESPACE_NAME, EXTENT_MANAGEMENT from DBA_TABLESPACES;

The procedure to migrate to locally managed tablespace is:

SQL> EXECUTE
DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL(‘tbs’);

And the whole migration procedure would look like this:

STARTUP RESTRICT
EXCLUSIVE;
EXEC
DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL(‘TBS’);
— do this for all tablespaces except SYSTEM, TEMP and SYSAUX
DROP TABLESPACE
TEMP;
— necessary if there’s no “real” temp tablespace definded yet – see Note:160426.1
CREATE

[ Read more ]