Hands-On Lab

Upgrade Hands-On Lab – Oracle Database – May 2018

  • Download Hands On Lab “Upgrade, Migrate, Consolidate to Oracle Database
  • 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 - 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 - 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 Hands-On Lab - Oracle Database - May 2018