Home
Videos uploaded by user “Oracle Database Upgrades and Migrations”
Full Transportable Export/Import into the DBaaS Cloud - Oracle 12c
 
20:54
Video provided by Roy Swonger - Database Upgrade and Utilities Product Manager and Senior Director at Oracle Corporation Video lenght: 20 minutes This video demonstrates first of all how to use the Oracle Database 12c feature "Full Transportable Export/Import". This feature utilized Transportable Tablespaces as a cross-version and cross-platform migration technology but let Oracle Data Pump handle all the manual stuff involved with TTS and xTTS in just one command. Furthermore the feature can be combined with RMAN Incremental Backups to decrease the downtime if necessary and desired. Please find a presentation at the Database Upgrade Blog at: https://blogs.oracle.com/UPGRADE/ in the Slides Download Center titled: Full Transportable Export/Import with RMAN Incrementals In addition Roy is demonstrating also how to utilize this feature to migrate a database into the Oracle DBaaS Cloud. Interesting fact: Even though Full Transportable Export is an Oracle Database 12c feature included in the standard license set it can be used with an Oracle 11.2.0.3 or Oracle 11.2.0.4 database - but the destination version must be at least an Oracle Database 12.1.0.1 (or newer). Further question? Please get in touch with us via the Oracle Database Upgrade Blog: https://blogs.oracle.com/UPGRADE/ Thanks!
Oracle Database 12c - Upgrade from Oracle 10.2 to Oracle 12.1
 
06:17
This viewlet - produced by the Oracle Server Technologies Database Upgrade team will show a database upgrade from an Oracle 10.2.0.5 database to Oracle Database 12.1.0.1 on the command line using the new preupgrade checks and the new parallel upgrade script
Database Upgrade Assistant (DBUA) in Oracle Database 12c - Upgrade from 10.2 to 12.1
 
03:07
This viewlet shows the DBUA for an upgrade from Oracle Database 10.2.0.5 to Oracle 12.1.0.1 in GUI mode. This will be a valid option once old and new installation reside on the same server. If this isn't the case please refer to the command line upgrade shown here: http://youtu.be/d8-YVdiMbQM
The New Oracle Database Release and Patching Model
 
26:46
For a higher resolution video please click here: https://youtu.be/JIfZPMzQDwA With Oracle Database 12.2 Oracle changes it's release and patching model. There are no first and second releases but yearly releases. And patching should be done with Updates or Revisions. This 26 min video explains the new model in depth. Please find more information on: https://MikeDietrichDE.com Or follow me on Twitter: MikeDietrichDE
Apply the Oracle Database 11.2.0.4 Patch Set Update (PSU) July 2018
 
03:17
https://mikedietrichde.com/2018/07/19/patching-my-databases-with-the-july-2018-psu-bp-and-ru/ This video shows how to simply apply the Oracle Database 11.2.0.4 Patch Set Update (PSU) of July 2018 for non-Engineered Systems
Installation of Oracle Database 18.3.0 on premises / Linux
 
04:22
https://mikedietrichde.com/2018/07/25/oracle-database-18-3-0-installation-on-premises/ This video shows a quick demo of the installation of Oracle Database 18.3.0 on-prem for Linux.
Database Upgrade to Oracle 18c 18.3.0 on premises on the command line with catctl.pl
 
04:17
https://mikedietrichde.com/2018/07/26/oracle-database-18-3-0-upgrade-on-premises/ This video shows you in less than 5 minutes a complete database upgrade on the command line to Oracle Database 18.3.0 on premises. For the preupgrade checks please see: https://www.youtube.com/watch?v=2R0Plcn7Udk
Running the preupgrade.jar for Oracle 18.3.0 Upgrades
 
06:27
https://mikedietrichde.com/2018/07/26/oracle-database-18-3-0-upgrade-on-premises/ This video shows and demonstrates how to download and execute the preupgrade.jar for a preupgrade check for upgrades to Oracle Database 18c - in this case 18.3.0 on premises for Linux. Furthermore it has all the preupgrade checks included and explained as well.
Applying the July 2018 Bundle Patch to Oracle Database 12.1.0.2
 
06:32
https://mikedietrichde.com/2018/07/19/patching-my-databases-with-the-july-2018-psu-bp-and-ru/ This video shows how to simply apply the Oracle Database 12.1.0.2 Bundle Patch (BP) of July 2018
Postupgrade Checks and Time Zone Change -  Command Line Ugrade to Oracle 18.3.0
 
07:58
https://mikedietrichde.com/2018/07/26/oracle-database-18-3-0-upgrade-on-premises/ This video shows the post upgrade steps after a successful Oracle Database upgrade to Oracle 18.3.0 on the command line. It includes checking the logfiles, recompilation with utlrp.sql and the time zone adjustment from DST v.14 to v.31
New Oracle Database Release and Patching Model
 
26:46
** Better resolution than https://youtu.be/pmyxUzs6TVM ** With Oracle Database 12.2 Oracle changes it's release and patching model. There are no first and second releases but yearly releases. And patching should be done with Updates or Revisions. This 26 min video explains the new model in depth.
Apply the Oracle Database 18.3.0 Update (RU) July 2018
 
04:29
https://mikedietrichde.com/2018/07/19/patching-my-databases-with-the-july-2018-psu-bp-and-ru/ Short video on how to apply the 18.3.0 July 2018 Release Update (RU) to my Oracle Database 18.1.0
Oracle Data Pump Export with Long Identifiers
 
05:37
See also: https://mikedietrichde.com/2018/07/09/export-with-data-pump-and-long-identifiers/ This short 5 minute video demonstrates where you have to be careful with Long Identifiers since Oracle 12.2 when exchanging data between databases lower versioned than Oracle 12.2.0.1.
Data Pump 12.1.0.2 - Wrong Dump File Version - ORA-39142
 
10:24
https://MikeDietrichDE.com/2018/07/16/data-pump-12-1-0-2-wrong-dump-file-version-ora-39142 This video describes an issue and the workaround for ORA-39142: Wrong Dump File Version in Oracle 12.1.0.2 BP Apr/Jul 2018.