Hands-On Lab

Hands On Lab – Oracle Database 12.2.0.1

  • Download Hands On Lab “Upgrade, Migrate, Consolidate to Oracle Database 12.2.0.1
  • Hands-On Lab Instructions
  • Known Issues:
    • HOL Part 1
      • If the Upgrade Phase 107 takes more than 3 or 4 minutes please stop the upgrade with CTRL-C and restart it with catctl.pl -R -l /home/oracle catupgrd.sql – it should then complete within the given time. At this point of the lab there are some privileges cleaned up with DBMS_ASSERT – and in some cases this takes up to 45 minutes – not reproducible.
    • HOL Part 3
      • impdp fails in 1 out of 100 cases with:
        • $ impdp parfile=/home/oracle/IMP/ft.par 
          
          Import: Release 12.2.0.1.0 - Production on Tue Mar 28 21:31:02 2017
          
          Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.
          
          Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
          ORA-39006: internal error
          ORA-39113: Unable to determine database version
          ORA-06550: line 1, column 7:
          PLS-00352: Unable to access another database 'SOURCEDB'
          ORA-06550: line 1, column 7:
          PLS-00201: identifier 'SYS@SOURCEDB' must be declared
          ORA-06550: line 1, column 7:
          PL/SQL: Statement ignored
          
          ORA-39097: Data Pump job encountered unexpected error -6550
          
        • If this happens, reset the virtual box network configuration (disabled it, re-enabled it, set it back to NAT). Then start the image again – and now it should work.
  • Overview – what’s in the lab:

    Upgrade HOL Oracle 12.2

    Upgrade Hands-On Lab – Oracle Database 12.2 including Multitenant