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

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. 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 Show Details Migrating Non-CDBs to New Hardware with a Different Endian…

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…

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…

Upgrade and Migration Office Hours on March 21, 2018

The 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 your questions…

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  

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 of…

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 large…

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 –…

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…

DOAG Noon2Noon – Upgrade/Multitenant – 2.-3.2.2017

++++++ Sorry – this is a German event only thus I will write in German ++++++ . 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 den interaktiven…

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 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 plan to…

Full Transportable Export/Import – Things to Know

This blog post is an addition to: Full Transportable Export/Import – Migrating an 11.2.0.4 database to Oracle Database 12c- into the Oracle Cloud 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…

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, grants, sequences etc etc etc. You can…

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 Data Guard Support…

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…

Simplify your Migration from AIX to Solaris

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

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 that bitnes move…

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…