Upgrade to Oracle 12c Database using manual method


Now the DBUA upgrade has been discussed before. We will checkout the manual method now.

1. Preupgrade Steps

1.1 Remove Enterprise Manager DBConsole

Since 12c DBConsole has been replaced by Database Express

1.1.2 Stop DBConsole

[bash ~]$ emctl stop dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0 
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
http://localhost:1158/em/console/aboutApplication
Stopping Oracle Enterprise Manager 11g Database Control ... 
 ...  Stopped.

1.1.3 Switch to /rdbms/admin and exeucute emremove.sql

[bash ~]$ cd /opt/oracle/app/product/12.1.0/dbhome_1/rdbms/admin/
[bash admin]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Sat Jul 13 12:17:28 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning and Oracle Label Security options

SQL> set echo on;
SQL> @emremove.sql
SQL> Rem
SQL> Rem $Header: rdbms/admin/emremove.sql /main/2 2012/07/27 01:19:53 spramani Exp $
SQL> Rem
SQL> Rem emremove.sql
SQL> Rem
SQL> Rem Copyright (c) 2012, Oracle and/or its affiliates. All rights reserved.
SQL> Rem
SQL> Rem    NAME
SQL> Rem emremove.sql - This script removes EM Schema from RDBMS
SQL> Rem
SQL> Rem    DESCRIPTION
SQL> Rem This script will drop the Oracle Enterprise Manager related schemas and objects.
SQL> Rem This script might take few minutes to complete; it has 6 phases to complete the process.
SQL> Rem The script may take longer if you have SYSMAN and related sessions are active
SQL> Rem from Oracle Enterprise Manager(OEM) application.
SQL> Rem
SQL> Rem    NOTES
SQL> Rem Please do following two steps  before running this script
SQL> Rem set serveroutput on
SQL> Rem set echo on
SQL> Rem
SQL> Rem
SQL> Rem
SQL> Rem    RECOMMENDATIONS
SQL> Rem
SQL> Rem You are recommended to shutdown DB Control application immediately before running this
SQL> Rem OEM repository removal script.
SQL> Rem To shutdown DB Control application, you need to run emctl stop dbconsole
SQL> Rem
SQL> Rem
SQL> Rem Steps to be performed manually (after this script is run)
SQL> Rem
SQL> Rem
SQL> Rem Please note that you need to remove the DB Control Configuration Files
SQL> Rem manually to remove DB Control completly; remove the following
SQL> Rem directories from your filesystem
SQL> Rem <ORACLE_HOME>/<hostname_sid>
SQL> Rem <ORACLE_HOME>/oc4j/j2ee/OC4J_DBConsole__
SQL> Rem
SQL> Rem If the dbcontrol is upgraded from lower version, for example, from 10.2.0.3 to 10.2.0.4,
SQL> Rem then the following directory also needs to be removed from the file system.
SQL> Rem <ORACLE_HOME>/<hostname_sid>.upgrade
SQL> Rem <ORACLE_HOME>/oc4j/j2ee/OC4J_DBConsole__.upgrade
SQL> Rem
SQL> Rem On Microsoft platforms, also delete the DB Console service, generally with name
SQL> Rem OracleDBConsole
SQL> Rem
SQL> Rem #############################################################################################
SQL> Rem
SQL> Rem
SQL> Rem    MODIFIED   (MM/DD/YY)
SQL> Rem    spramani    07/20/12 - more fix
SQL> Rem    spramani    12/21/11 - Created
SQL> Rem
...

PL/SQL procedure successfully completed.

1.1.3 Optional you can delete old directories

To have a clean 11g installation, clean old EM configuration
* ORACLE_HOME/HOSTNAME_SID
* ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole_HOSTNAME_SID

2 Run preupgrade information utility

Switch to /rdbms/admin and exeucute preupgrd.sql

[bash]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Sat Jul 13 12:28:13 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning and Oracle Label Security options

SQL> @preupgrd.sql
Loading Pre-Upgrade Package...
Executing Pre-Upgrade Checks...
Pre-Upgrade Checks Complete.
      ************************************************************

Results of the checks are located at:
 /opt/oracle/app/product/11.2.0.3/dbhome_2/cfgtoollogs/DBUPGRD/preupgrade/preupgrade.log

Pre-Upgrade Fixup Script (run in source database environment):
 /opt/oracle/app/product/11.2.0.3/dbhome_2/cfgtoollogs/DBUPGRD/preupgrade/preupgrade_fixups.sql

Post-Upgrade Fixup Script (run shortly after upgrade):
 /opt/oracle/app/product/11.2.0.3/dbhome_2/cfgtoollogs/DBUPGRD/preupgrade/postupgrade_fixups.sql

      ************************************************************

         Fixup scripts must be reviewed prior to being executed.

      ************************************************************

      ************************************************************
                   ====>> USER ACTION REQUIRED  <<====       ************************************************************  The following are *** ERROR LEVEL CONDITIONS *** that must be addressed                     prior to attempting your upgrade.             Failure to do so will result in a failed upgrade.            You MUST resolve the above errors prior to upgrade       ************************************************************ SQL>

2.1 Check output

Logfiles are generated at /cfgtoollogs//preupgrade

Here the example output from preupgrade.log

[bash]$ cat /opt/oracle/app/product/11.2.0.3/dbhome_2/cfgtoollogs/DBUPGRD/preupgrade/preupgrade.log
Oracle Database Pre-Upgrade Information Tool 07-13-2013 12:28:22
Script Version: 12.1.0.1.0 Build: 006
**********************************************************************
   Database Name:  DBUPGRD
         Version:  11.2.0.3.0
      Compatible:  11.2.0.0.0
       Blocksize:  8192
        Platform:  Linux x86 64-bit
   Timezone file:  V14
**********************************************************************
                          [Renamed Parameters]
                     [No Renamed Parameters in use]
**********************************************************************
**********************************************************************
                    [Obsolete/Deprecated Parameters]
             [No Obsolete or Desupported Parameters in use]
**********************************************************************
                            [Component List]
**********************************************************************
--> Oracle Catalog Views                   [upgrade]  VALID     
--> Oracle Packages and Types              [upgrade]  VALID     
--> JServer JAVA Virtual Machine           [upgrade]  VALID     
--> Oracle XDK for Java                    [upgrade]  VALID     
--> Oracle Workspace Manager               [upgrade]  VALID     
--> OLAP Analytic Workspace                [upgrade]  VALID     
--> Oracle Text                            [upgrade]  VALID     
--> Oracle XML Database                    [upgrade]  VALID     
--> Oracle Java Packages                   [upgrade]  VALID     
--> Oracle Multimedia                      [upgrade]  VALID     
--> Oracle Spatial                         [upgrade]  VALID     
--> Expression Filter                      [upgrade]  VALID     
--> Rule Manager                           [upgrade]  VALID     
--> Oracle Application Express             [upgrade]  VALID     
--> Oracle OLAP API                        [upgrade]  VALID     
**********************************************************************
                              [Tablespaces]
**********************************************************************
--> SYSTEM tablespace is adequate for the upgrade.
     minimum required size: 1211 MB
--> SYSAUX tablespace is adequate for the upgrade.
     minimum required size: 1400 MB
--> UNDOTBS1 tablespace is adequate for the upgrade.
     minimum required size: 400 MB
--> TEMP tablespace is adequate for the upgrade.
     minimum required size: 60 MB

                      [No adjustments recommended]

**********************************************************************
**********************************************************************
                          [Pre-Upgrade Checks]
**********************************************************************
WARNING: --> Existing DBMS_LDAP dependent objects

     Database contains schemas with objects dependent on DBMS_LDAP package.
     Refer to the Upgrade Guide for instructions to configure Network ACLs.
     USER APEX_030200 has dependent objects.

INFORMATION: --> OLAP Catalog(AMD) exists in database

     Starting with Oracle Database 12c, OLAP is desupported.
     If you are not using the OLAP Catalog component and want
     to remove it, then execute the 
     ORACLE_HOME/oraolap/admin/catnoamd.sql script before or 
     after the upgrade.

INFORMATION: --> Older Timezone in use

     Database is using a time zone file older than version 18.
     After the upgrade, it is recommended that DBMS_DST package
     be used to upgrade the 11.2.0.3.0 database time zone version
     to the latest version which comes with the new release.
     Please refer to My Oracle Support note number 977512.1 for details.

**********************************************************************
                      [Pre-Upgrade Recommendations]
**********************************************************************

                        *****************************************
                        ********* Dictionary Statistics *********
                        *****************************************

Please gather dictionary statistics 24 hours prior to
upgrading the database.
To gather dictionary statistics execute the following command
while connected as SYSDBA:
    EXECUTE dbms_stats.gather_dictionary_stats;

^^^ MANUAL ACTION SUGGESTED ^^^

**********************************************************************
                     [Post-Upgrade Recommendations]
**********************************************************************

                        *****************************************
                        ******** Fixed Object Statistics ********
                        *****************************************

Please create stats on fixed objects two weeks
after the upgrade using the command:
   EXECUTE DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;

^^^ MANUAL ACTION SUGGESTED ^^^

**********************************************************************
                   ************  Summary  ************

 0 ERRORS exist in your database.
 1 WARNING that Oracle suggests are addressed to improve database performance.
 2 INFORMATIONAL messages that should be reviewed prior to your upgrade.

 After your database is upgraded and open in normal mode you must run 
 rdbms/admin/catuppst.sql which executes several required tasks and completes
 the upgrade process.

 You should follow that with the execution of rdbms/admin/utlrp.sql, and a
 comparison of invalid objects before and after the upgrade using
 rdbms/admin/utluiobj.sql

 If needed you may want to upgrade your timezone data using the process
 described in My Oracle Support note 977512.1
                   ***********************************

If there are some warnings you can check out the upgrade documentation, where many cases have been documented:
http://docs.oracle.com/cd/E16655_01/server.121/e17642/preup.htm#BABBCGJC

Some of the warnings are fixable and included in the preupgrade_fixups.sql

Here the example output from preupgrade_fixups.sql

[bash]$ cat /opt/oracle/app/product/11.2.0.3/dbhome_2/cfgtoollogs/DBUPGRD/preupgrade/preupgrade_fixups.sql
dbms_preup.clear_run_flag(TRUE);
END;
/
BEGIN
-- *****************  Fixup Details ***********************************
-- Name:        DBMS_LDAP_DEPENDENCIES_EXIST
-- Description: Check for dependency on DBMS_LDAP package
-- Severity:    Warning
-- Action:      ^^^ MANUAL ACTION REQUIRED ^^^
-- Fix Summary: 
--     Network Objects must be reviewed manually.

dbms_preup.run_fixup_and_report('DBMS_LDAP_DEPENDENCIES_EXIST');
END;
/
BEGIN
-- *****************  Fixup Details ***********************************
-- Name:        AMD_EXISTS
-- Description: Check to see if AMD is present in the database
-- Severity:    Informational
-- Action:      ^^^ MANUAL ACTION REQUIRED ^^^
-- Fix Summary: 
--     Manually execute ORACLE_HOME/oraolap/admin/catnoamd.sql script to remove OLAP.

dbms_preup.run_fixup_and_report('AMD_EXISTS');
END;
/
BEGIN
dbms_output.put_line ('');
dbms_output.put_line ('**********************************************************************');
dbms_output.put_line ('                      [Pre-Upgrade Recommendations]');
dbms_output.put_line ('**********************************************************************');
dbms_output.put_line ('');
END;
/
BEGIN
dbms_output.put_line ('                        *****************************************');
dbms_output.put_line ('                        ********* Dictionary Statistics *********');
dbms_output.put_line ('                        *****************************************');
dbms_output.put_line ('');
dbms_output.put_line ('Please gather dictionary statistics 24 hours prior to');
dbms_output.put_line ('upgrading the database.');
dbms_output.put_line ('To gather dictionary statistics execute the following command');
dbms_output.put_line ('while connected as SYSDBA:');
dbms_output.put_line ('    EXECUTE dbms_stats.gather_dictionary_stats;');
dbms_output.put_line ('');
dbms_output.put_line ('^^^ MANUAL ACTION SUGGESTED ^^^');
dbms_output.put_line ('');
END;
/
BEGIN dbms_preup.fixup_summary(TRUE); END;
/
BEGIN
dbms_output.put_line ('**************** Pre-Upgrade Fixup Script Complete *********************');
END;
/

REM Pre-Upgrade Script Closed At: 2013-07-13 12:28:22

3. Shutdown database, copy needed files (pfile/spfile and password file) to new oracle home

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning and Oracle Label Security options
[bash ~]$ cd $ORACLE_HOME/dbs
[bash dbs]$ cp spfileDBUPGRD.ora orapwDBUPGRD /opt/oracle/app/product/12.1.0/dbhome_1/dbs

4. Change environment, check init parameter and startup instance

Notice: Under Windows you have to create a windows service with oradim

[bash dbs]$ export ORACLE_HOME=/opt/oracle/app/product/12.1.0/dbhome_1
[bash dbs]$ export PATH=$ORACLE_HOME/bin:$PATH
[bash dbs]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Sat Jul 13 12:48:17 2013

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount;
ORACLE instance started.

Total System Global Area 1185853440 bytes
Fixed Size                  2287672 bytes
Variable Size             436209608 bytes
Database Buffers          738197504 bytes
Redo Buffers                9158656 bytes
SQL> alter database mount;

Database altered.

SQL> alter database open upgrade;

Database altered.

SQL>

5. Start upgrade process

Since 12c the script “catupgrd.sql” is not supported anymore. The upgrade can be done in parallel now. Specify -n or -n 0 to disable no parallel:

[bash dbs]$ cd $ORACLE_HOME/rdbms/admin
[bash admin]$ pwd
/opt/oracle/app/product/12.1.0/dbhome_1/rdbms/admin
[bash admin]$ $ORACLE_HOME/perl/bin/perl catctl.pl -n 4 catupgrd.sql
Analyzing file catupgrd.sql
14 scripts found in file catupgrd.sql
Next path: catalog.sql
32 scripts found in file catalog.sql
Next path: catproc.sql
37 scripts found in file catproc.sql
Next path: catptabs.sql
61 scripts found in file catptabs.sql
Next path: catpdbms.sql
205 scripts found in file catpdbms.sql
Next path: catpdeps.sql
77 scripts found in file catpdeps.sql
Next path: catpprvt.sql
260 scripts found in file catpprvt.sql
Next path: catpexec.sql
26 scripts found in file catpexec.sql
Next path: cmpupgrd.sql
16 scripts found in file cmpupgrd.sql

[Phase 0] type is 1 with 1 Files
catupstr.sql     

[Phase 1] type is 1 with 3 Files
cdstrt.sql       cdfixed.sql      cdcore.sql       

[Phase 2] type is 1 with 1 Files
ora_restart.sql  

[Phase 3] type is 2 with 18 Files
cdplsql.sql      cdsqlddl.sql     cdmanage.sql     cdtxnspc.sql 
cdenv.sql        cdrac.sql        cdsec.sql        cdobj.sql 
cdjava.sql       cdpart.sql       cdrep.sql        cdaw.sql 
cdsummgt.sql     cdtools.sql      cdexttab.sql     cddm.sql 
catldr.sql       cdclst.sql       

[Phase 4] type is 1 with 1 Files
ora_restart.sql  

[Phase 5] type is 1 with 5 Files
cdoptim.sql      catsum.sql       catexp.sql       cddst.sql 
cdend.sql        

[Phase 6] type is 1 with 1 Files
catpstrt.sql     

[Phase 7] type is 1 with 3 Files
catptyps.sql     catpgrants.sql   catgwm.sql       

[Phase 8] type is 1 with 1 Files
ora_restart.sql  

[Phase 9] type is 2 with 60 Files
catnodpt.sql     catbac.sql       prvtrctv.plb     catactx.sql 
prvtuttv.plb     catsvrmg.sql     prvtlsis.plb     prvtlsss.plb 
cattrans.sql     catrule.sql      catsnap.sql      catpitr.sql 
catdip.sql       catrls.sql       catar.sql        catfga.sql 
catamgt.sql      catidxu.sql      cattsm.sql       catchnf.sql 
catodm.sql       catkppls.sql     catsscr.sql      catqueue.sql 
cathae.sql       catadvtb.sql     catrm.sql        catsch.sql 
catol.sql        catdpb.sql       catcrc.sql       dbmscr.sql 
dbmsutil.sql     catdbfus.sql     catalrt.sql      catatsk.sql 
catmntr.sql      catsqlt.sql      catawrtv.sql     catsmbvw.sql 
catwrrtb.sql     catsumat.sql     catrep.sql       catlmnr.sql 
catdef.sql       catadrvw.sql     catrepv.sql      catpexe.sql 
cattlog.sql      catcapi.sql      catpspi.sql      catts.sql 
catnacl.sql      catredact.sql    catproftab.sql   catpstdy.sql 
catrupg.sql      catratmask.sql   catqitab.sql     catappcont.sql 

[Phase 10] type is 1 with 1 Files
ora_restart.sql  

[Phase 11] type is 1 with 1 Files
catpspec.sql     

[Phase 12] type is 1 with 1 Files
ora_restart.sql  

[Phase 13] type is 2 with 199 Files
utlinad.sql      utlsmtp.sql      utlurl.sql       utlenc.sql 
utlgdk.sql       utlcstk.sql      utlcomp.sql      utli18n.sql 
utllms.sql       dbmsplsw.sql     utlnla.sql       dbmspdb.sql 
dbmstrns.sql     dbmsrwid.sql     dbmspclx.sql     dbmserlg.sql 
dbmsspu.sql      dbmsapin.sql     dbmssyer.sql     dbmspipe.sql 
dbmsalrt.sql     dbmsdesc.sql     dbmspexp.sql     dbmsjob.sql 
dbmsstat.sql     dbmsstts.sql     dbmsddl.sql      dbmsedu.sql 
dbmspp.sql       prvthddl.plb     prvthjob.plb     prvthsye.plb 
prvtzhlp.plb     dbmsidxu.sql     prvthidx.plb     dbmspsp.sql 
dbmstran.sql     dbmsxa.sql       dbmstxfm.sql     dbmsread.sql 
prvtreut.plb     dbmspb.sql       dbmspbt.sql      dbmsplts.sql 
dbmspitr.sql     utlrefld.sql     utlcoll.plb      dbmstrst.sql 
dbmsrlsa.sql     dbmsrpr.sql      dbmsobtk.sql     dbmshtdb.sql 
dbmslm.sql       dbmslmd.sql      prvtlmes.plb     utlcxml.sql 
dbmsfga.sql      dbmsamgt.sql     dbmstypu.sql     dbmsres.sql 
dbmstxin.sql     dbmsdrs.sql      dbmsdg.sql       dbmssum.sql 
dbmshord.sql     dbmsxfr.sql      dbmsmap.sql      dbmsfi.sql 
dbmsdbv.sql      dbmstcv.sql      dbmscoll.sql     dbmscdcu.sql 
dbmscdcp.sql     dbmscdcs.sql     dbmspbp.sql      dbmshpro.sql 
dbmssrv.sql      dbmschnf.sql     dbmsxpln.sql     utlmatch.sql 
dbmsdbvn.sql     dbmspool.sql     dbmsrcad.sql     prvthcrc.plb 
prvtkpps.plb     dbmsaq.plb       dbmsaqad.sql     dbmsaq8x.plb 
dbmsaqem.plb     prvtaqxi.plb     dbmsslrt.sql     dbmsmntr.sql 
dbmshm.sql       catsqltk.sql     dbmsir.sql       prvtsss.plb 
dbmsocm.sql      dbmslobu.sql     dbmsmp.sql       dbmsaddm.sql 
prvttxfs.plb     dbmsrmin.plb     dbmsrmad.sql     dbmsrmpr.sql 
dbmsrmpe.plb     dbmsrmge.plb     dbmsrmpa.plb     prvtrmie.plb 
prvthjob.plb     prvthesh.plb     dbmsol.sql       prvtdputh.plb 
dbmsmeta.sql     dbmsmetb.sql     dbmsmetd.sql     dbmsmet2.sql 
dbmsdp.sql       prvthpp.plb      prvthpd.plb      prvthpdi.plb 
prvthpvi.plb     prvtdtde.plb     prvtsum.plb      prvtjdbs.plb 
dbmsslxp.sql     prvssmgu.plb     dbmsawr.sql      prvsemxi.plb 
prvsemx_admin.plb prvsemx_dbhome.plb prvsemx_memory.plb prvsemx_perf.plb 
dbmsperf.sql     prvsrept.plb     prvsrepr.plb     prvshdm.plb 
prvsrtaddm.plb   prvs_awr_data_cp.plb prvscpaddm.plb   prvsadv.plb 
prvsawr.plb      prvsawri.plb     prvsawrs.plb     prvsash.plb 
prvsawrv.plb     dbmssqlu.sql     prvssqlf.plb     dbmswrr.sql 
dbmsfus.sql      prvsfus.plb      dbmsuadv.sql     dbmsrepl.sql 
dbmsspm.sql      prvsspmi.plb     prvssmb.plb      prvssmbi.plb 
dbmsstr.sql      dbmssqlt.sql     dbmsspa.sql      prvsautorepi.plb 
dbmsautorep.sql  dbmsratmask.sql  dbmsdiag.sql     dbmsobj.sql 
dbmskzxp.sql     dbmscu.sql       dbmsdst.sql      dbmscomp.sql 
dbmsilm.sql      dbmspexe.sql     prvthpexei.plb   dbmscapi.sql 
dbmsfuse.sql     dbmsfspi.sql     dbmspspi.sql     dbmsdnfs.sql 
dbmsadr.sql      dbmsadra.sql     prvsadri.plb     xsrs.sql 
xssc.sql         xsacl.sql        xsds.sql         xsns.sql 
xsdiag.sql       xssess.sql       dbmsredacta.sql  dbmssqll.sql 
dbmsgwm.sql      dbmsappcont.sql  dbmsspd.sql      prvsspdi.plb 
dbmsfs.sql       dbmssqlm.sql     catprofp.sql     prvtsys.plb 
dbmspart.sql     dbmsrupg.sql     dbmstsdp.sql     

[Phase 14] type is 1 with 1 Files
ora_restart.sql  

[Phase 15] type is 1 with 3 Files
dbmsmeti.sql     dbmsmetu.sql     dbmsqopi.sql     

[Phase 16] type is 1 with 1 Files
ora_restart.sql  

[Phase 17] type is 2 with 33 Files
catmettypes.sql  prvthdbu.plb     catost.sql       dbmshae.sql 
catxpend.sql     prvtotpt.plb     prvthlut.plb     prvthlin.plb 
prvthsdp.plb     dbmsrman.sql     dbmsbkrs.sql     dbmstrig.sql 
dbmsrand.sql     dbmsjdwp.sql     catxs.sql        dbmssnap.sql 
prvtxrmv.plb     depsaq.sql       prvthlrt.plb     catadv.sql 
dbmscred.sql     catcredv.sql     cataqsch.sql     catrssch.sql 
catplug.sql      prvtsql.plb      prvtssql.plb     prvtlmd.plb 
prvtlmcs.plb     prvtlmrs.plb     dbmslms.sql      prvthpu.plb 
prvthpv.plb      

[Phase 18] type is 1 with 1 Files
ora_restart.sql  

[Phase 19] type is 1 with 3 Files
prvtkupc.plb     prvtaqiu.plb     catlsby.sql      

[Phase 20] type is 1 with 1 Files
ora_restart.sql  

[Phase 21] type is 2 with 23 Files
catmetviews.sql  prvthpw.plb      prvthpm.plb      prvthpfi.plb 
prvthpf.plb      dbmsodm.sql      prvtitrg.plb     prvtsms.plb 
depssvrm.sql     deptxn.sql       catstr.sql       prvthsts.plb 
prvthfgr.plb     prvthfie.plb     prvthcmp.plb     catpexev.sql 
depscapi.sql     depspspi.sql     catwrrvw.sql     dbmsjdcu.sql 
dbmsjdmp.sql     prvthpc.plb      prvt_awr_data.plb 

[Phase 22] type is 1 with 1 Files
ora_restart.sql  

[Phase 23] type is 2 with 11 Files
catmetgrant1.sql catldap.sql      prvtocm.sql      prvtrepl.sql 
catpstr.sql      prvthpci.plb     catilm.sql       catemxv.sql 
catnaclv.sql     dbmsnacl.sql     dbmswlm.sql      

[Phase 24] type is 1 with 1 Files
ora_restart.sql  

[Phase 25] type is 1 with 1 Files
catcdbviews.sql  

[Phase 26] type is 1 with 1 Files
ora_restart.sql  

[Phase 27] type is 2 with 0 Files

[Phase 28] type is 1 with 1 Files
ora_load_without_comp.sql 

[Phase 29] type is 2 with 130 Files
prvtfile.plb     prvtrawb.plb     prvttcp.plb      prvtinad.plb 
prvtsmtp.plb     prvthttp.plb     prvturl.plb      prvtenc.plb 
prvtgdk.plb      prvtlob.plb      prvtlobu.plb     prvtcstk.plb 
prvtcomp.plb     prvti18n.plb     prvtlms2.plb     prvtnla.plb 
prvttrns.plb     prvtsess.plb     prvtrwid.plb     prvtpclx.plb 
prvterlg.plb     prvtapin.plb     prvtsyer.plb     prvtlock.plb 
prvtpipe.plb     prvtalrt.plb     prvtdesc.plb     prvtpexp.plb 
prvtzexp.plb     prvtstts.plb     prvtddl.plb      prvtpp.plb 
prvtscrp.plb     prvtkppb.plb     prvtutil.plb     prvtpsp.plb 
prvttran.plb     prvtxa.plb       prvtany.plb      prvtread.plb 
prvtpb.plb       prvtpbt.plb      prvtxpsw.plb     prvtcoll.plb 
prvttrst.plb     prvtrlsa.plb     prvtodci.plb     prvtrpr.plb 
prvtobtk.plb     prvthtdb.plb     prvtxmlt.plb     prvturi.plb 
prvtxml.plb      prvtcxml.plb     prvtemxi.plb     prvtemx_admin.plb 
prvtemx_dbhome.plb prvtemx_memory.plb prvtemx_perf.plb prvtperf.plb 
prvtrep.plb      prvtrept.plb     prvtrepr.plb     prvtfga.plb 
prvtamgt.plb     prvttypu.plb     prvtjdwp.plb     prvtjdmp.plb 
prvtres.plb      prvtcr.plb       prvttxin.plb     prvtdrs.plb 
prvtdg.plb       prvtfi.plb       prvtmap.plb      prvthpui.plb 
prvtdbv.plb      prvttcv.plb      prvtpbp.plb      prvthpro.plb 
prvtbdbu.plb     prvtsrv.plb      prvtpool.plb     prvtkzxs.plb 
prvtkzxp.plb     prvtcrc.plb      prvtrc.plb       prvtaq.plb 
prvtaqdi.plb     prvtaqxe.plb     prvtaqis.plb     prvtaqim.plb 
prvtaqad.plb     prvtaq8x.plb     prvtaqin.plb     prvtaqal.plb 
prvtaqjm.plb     prvtaqmi.plb     prvtaqme.plb     prvtaqem.plb 
prvtaqip.plb     prvtaqds.plb     prvtsqdi.plb     prvtsqds.plb 
prvtsqis.plb     prvthm.plb       prvtwlm.plb      prvtsqtk.plb 
prvtkjhn.plb     prvtir.plb       prvtssb.plb      prvttxfm.plb 
prvtrmin.plb     prvtrmad.plb     prvtrmpr.plb     prvtrmpe.plb 
prvtrmge.plb     prvtrmpa.plb     prvtjob.plb      prvtbsch.plb 
prvtesch.plb     prvtcred.plb     prvtol.plb       prvtlm.plb 
prvtlmcb.plb     prvtlmrb.plb     prvtlms.plb      prvtlmeb.plb 
prvtbpu.plb      prvtwrr.plb      

[Phase 30] type is 1 with 1 Files
ora_load_with_comp.sql 

[Phase 31] type is 1 with 1 Files
ora_restart.sql  

[Phase 32] type is 1 with 1 Files
ora_load_without_comp.sql 

[Phase 33] type is 2 with 122 Files
prvtbpui.plb     prvtdput.plb     prvtmeta.plb     prvtmeti.plb 
prvtmetu.plb     prvtmetb.plb     prvtmetd.plb     prvtmet2.plb 
prvtdp.plb       prvtbpc.plb      prvtbpci.plb     prvtbpw.plb 
prvtbpm.plb      prvtbpfi.plb     prvtbpf.plb      prvtbpp.plb 
prvtbpd.plb      prvtbpdi.plb     prvtbpv.plb      prvtbpvi.plb 
prvtdpcr.plb     prvtplts.plb     prvtpitr.plb     prvtreie.plb 
prvtrwee.plb     prvtidxu.plb     prvtrcmp.plb     prvtchnf.plb 
prvtedu.plb      prvtlsby.plb     prvtlsib.plb     prvtlssb.plb 
prvtsmv.plb      prvtsma.plb      prvtbxfr.plb     prvtbord.plb 
prvtjdbb.plb     prvtslrt.plb     prvtslxp.plb     prvtatsk.plb 
prvtmntr.plb     prvtsmgu.plb     prvtdadv.plb     prvtadv.plb 
prvtawr.plb      prvtawrs.plb     prvtawri.plb     prvtash.plb 
prvtawrv.plb     prvtsqlf.plb     prvtsqli.plb     prvtsqlt.plb 
prvtautorepi.plb prvtautorep.plb  prvtfus.plb      prvtmp.plb 
prvthdm.plb      prvtaddm.plb     prvtrtaddm.plb   prvt_awr_data_cp.plb 
prvtcpaddm.plb   prvtuadv.plb     prvtsqlu.plb     prvtspai.plb 
prvtspa.plb      prvtratmask.plb  prvtspmi.plb     prvtspm.plb 
prvtsmbi.plb     prvtsmb.plb      prvtfus.plb      catfusrg.sql 
prvtwrk.plb      prvtsmaa.plb     prvtxpln.plb     prvtstat.plb 
prvtstai.plb     prvtsqld.plb     prvtspcu.plb     prvtodm.plb 
prvtkcl.plb      prvtdst.plb      prvtcmpr.plb     prvtilm.plb 
prvtpexei.plb    prvtpexe.plb     prvtcapi.plb     prvtfuse.plb 
prvtfspi.plb     prvtpspi.plb     prvtdnfs.plb     prvtfs.plb 
prvtadri.plb     prvtadr.plb      prvtadra.plb     prvtadmi.plb 
prvtutils.plb    prvtxsrs.plb     prvtsc.plb       prvtacl.plb 
prvtds.plb       prvtns.plb       prvtdiag.plb     prvtkzrxu.plb 
prvtnacl.plb     prvtredacta.plb  prvtpdb.plb      prvttlog.plb 
prvtsqll.plb     prvtappcont.plb  prvtspd.plb      prvtspdi.plb 
prvtpprof.plb    prvtsqlm.plb     prvtpart.plb     prvtrupg.plb 
prvtrupgis.plb   prvtrupgib.plb   prvtpstdy.plb    prvttsdp.plb 
prvtqopi.plb     prvtlog.plb      

[Phase 34] type is 1 with 1 Files
ora_load_with_comp.sql 

[Phase 35] type is 1 with 1 Files
ora_restart.sql  

[Phase 36] type is 1 with 4 Files
catmetinsert.sql catpcnfg.sql     utluppkg.sql     catdph.sql 

[Phase 37] type is 1 with 1 Files
ora_restart.sql  

[Phase 38] type is 2 with 13 Files
catmetgrant2.sql execemx.sql      execcr.sql       caths.sql 
catemini.sql     execaq.sql       execsvrm.sql     exechae.sql 
execsec.sql      execbsln.sql     dbmspump.sql     olappl.sql 
execrep.sql      

[Phase 39] type is 1 with 1 Files
ora_restart.sql  

[Phase 40] type is 2 with 10 Files
execstr.sql      execsvr.sql      execstat.sql     catsnmp.sql 
wpiutil.sql      owainst.sql      catilmini.sql    execocm.sql 
exectsdp.sql     execqopi.sql     

[Phase 41] type is 1 with 1 Files
ora_restart.sql  

[Phase 42] type is 1 with 1 Files
catpend.sql      

[Phase 43] type is 1 with 1 Files
ora_restart.sql  

[Phase 44] type is 1 with 1 Files
catupprc.sql     

[Phase 45] type is 1 with 1 Files
cmpupstr.sql     

[Phase 46] type is 1 with 1 Files
ora_restart.sql  

[Phase 47] type is 1 with 2 Files
cmpupjav.sql     cmpupnjv.sql     

[Phase 48] type is 1 with 1 Files
ora_restart.sql  

[Phase 49] type is 1 with 2 Files
cmpupxdb.sql     cmpupnxb.sql     

[Phase 50] type is 1 with 1 Files
ora_restart.sql  

[Phase 51] type is 1 with 2 Files
cmpupord.sql     cmpupmsc.sql     

[Phase 52] type is 1 with 1 Files
ora_restart.sql  

[Phase 53] type is 1 with 1 Files
cmpupend.sql     

[Phase 54] type is 1 with 1 Files
catupend.sql     

[Phase 55] type is 1 with 1 Files
catuppst.sql     

[Phase 56] type is 1 with 1 Files
catshutdown.sql  

Using 4 processes.
Serial   Phase #: 0 Files: 1      Time: 121s
Serial   Phase #: 1 Files: 3      Time: 69s
Restart  Phase #: 2 Files: 1      Time: 0s
Parallel Phase #: 3 Files: 18     Time: 15s
Restart  Phase #: 4 Files: 1      Time: 1s
Serial   Phase #: 5 Files: 5      Time: 27s
Serial   Phase #: 6 Files: 1      Time: 13s
Serial   Phase #: 7 Files: 3      Time: 9s
Restart  Phase #: 8 Files: 1      Time: 0s
Parallel Phase #: 9 Files: 60     Time: 47s
Restart  Phase #:10 Files: 1      Time: 0s
Serial   Phase #:11 Files: 1      Time: 16s
Restart  Phase #:12 Files: 1      Time: 0s
Parallel Phase #:13 Files: 199 
   Time: 27s
Restart  Phase #:14 Files: 1      Time: 0s
Serial   Phase #:15 Files: 3      Time: 0s
Restart  Phase #:16 Files: 1      Time: 1s
Parallel Phase #:17 Files: 33     Time: 25s
Restart  Phase #:18 Files: 1      Time: 0s
Serial   Phase #:19 Files: 3      Time: 7s
Restart  Phase #:20 Files: 1      Time: 0s
Parallel Phase #:21 Files: 23     Time: 70s
Restart  Phase #:22 Files: 1      Time: 0s
Parallel Phase #:23 Files: 11     Time: 33s
Restart  Phase #:24 Files: 1      Time: 0s
Serial   Phase #:25 Files: 1      Time: 28s
Restart  Phase #:26 Files: 1      Time: 0s
Parallel Phase #:27 Files: 0      Time: 0s
Serial   Phase #:28 Files: 1      Time: 0s
Parallel Phase #:29 Files: 130    Time: 5s
Serial   Phase #:30 Files: 1      Time: 0s
Restart  Phase #:31 Files: 1      Time: 0s
Serial   Phase #:32 Files: 1      Time: 0s
Parallel Phase #:33 Files: 122    Time: 9s
Serial   Phase #:34 Files: 1      Time: 0s
Restart  Phase #:35 Files: 1      Time: 0s
Serial   Phase #:36 Files: 4      Time: 37s
Restart  Phase #:37 Files: 1      Time: 0s
Parallel Phase #:38 Files: 13     Time: 44s
Restart  Phase #:39 Files: 1      Time: 0s
Parallel Phase #:40 Files: 10     Time: 7s
Restart  Phase #:41 Files: 1      Time: 0s
Serial   Phase #:42 Files: 1      Time: 6s
Restart  Phase #:43 Files: 1      Time: 0s
Serial   Phase #:44 Files: 1      Time: 4s
Serial   Phase #:45 Files: 1      Time: 0s
Restart  Phase #:46 Files: 1      Time: 0s
Serial   Phase #:47 Files: 2      Time: 177s
Restart  Phase #:48 Files: 1      Time: 0s
Serial   Phase #:49 Files: 2      Time: 271s
Restart  Phase #:50 Files: 1      Time: 0s
Serial   Phase #:51 Files: 2      Time: 1384s
Restart  Phase #:52 Files: 1      Time: 0s
Serial   Phase #:53 Files: 1      Time: 1s
Serial   Phase #:54 Files: 1      Time: 163s
Serial   Phase #:55 Files: 1      Time: 181s
Serial   Phase #:56 Files: 1      Time: 22s
Grand Total Time: 2820s

To check state you can also take a look into alert.log:

grep SERVER /opt/oracle/app/diag/rdbms/dbupgrd/DBUPGRD/trace/alert_DBUPGRD.log
SERVER COMPONENT id=CATPROC: timestamp=2013-07-13 13:32:12
SERVER COMPONENT id=RDBMS: status=UPGRADED, version=12.1.0.1.0, timestamp=2013-07-13 13:32:16
SERVER COMPONENT id=JAVAVM: status=VALID, version=12.1.0.1.0, timestamp=2013-07-13 13:34:19
SERVER COMPONENT id=XML: status=VALID, version=12.1.0.1.0, timestamp=2013-07-13 13:34:48
SERVER COMPONENT id=APS: status=VALID, version=12.1.0.1.0, timestamp=2013-07-13 13:35:13
SERVER COMPONENT id=CONTEXT: status=VALID, version=12.1.0.1.0, timestamp=2013-07-13 13:35:44
SERVER COMPONENT id=XDB: status=VALID, version=12.1.0.1.0, timestamp=2013-07-13 13:38:49
SERVER COMPONENT id=CATJAVA: status=VALID, version=12.1.0.1.0, timestamp=2013-07-13 13:38:58
SERVER COMPONENT id=OWM: status=VALID, version=12.1.0.1.0, timestamp=2013-07-13 13:39:44
SERVER COMPONENT id=ORDIM: status=VALID, version=12.1.0.1.0, timestamp=2013-07-13 13:41:18
SERVER COMPONENT id=SDO: status=VALID, version=12.1.0.1.0, timestamp=2013-07-13 13:45:00
SERVER COMPONENT id=APEX: status=VALID, version=4.2.0.00.27, timestamp=2013-07-13 14:02:35
SERVER COMPONENT id=XOQ: status=VALID, version=12.1.0.1.0, timestamp=2013-07-13 14:02:48
SERVER COMPONENT id=ACTIONS_BGN: timestamp=2013-07-13 14:02:48
SERVER COMPONENT id=CATREQ_BGN: timestamp=2013-07-13 14:04:35
SERVER COMPONENT id=CATREQ_END: timestamp=2013-07-13 14:04:49
SERVER ACTION=UPGRADE id=: Upgraded from 11.2.0.3.0
SERVER COMPONENT id=ACTIONS_END: timestamp=2013-07-13 14:04:51
SERVER COMPONENT id=UPGRD_END: timestamp=2013-07-13 14:04:51
SERVER COMPONENT id=POSTUP_BGN: timestamp=2013-07-13 14:05:33
SERVER COMPONENT id=CATREQ_BGN: timestamp=2013-07-13 14:05:33
SERVER COMPONENT id=CATREQ_END: timestamp=2013-07-13 14:05:33
SERVER COMPONENT id=POSTUP_END: timestamp=2013-07-13 14:08:31

6. Post upgrade steps

6.1 Postupgradeutility

[bash admin]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Sat Jul 13 14:11:47 2013

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1185853440 bytes
Fixed Size                  2287672 bytes
Variable Size             536872904 bytes
Database Buffers          637534208 bytes
Redo Buffers                9158656 bytes
Database mounted.
Database opened.
SQL> @?/rdbms/admin/utlu121s.sql
.
Oracle Database 12.1 Post-Upgrade Status Tool           07-13-2013 14:12:05
.
Component                               Current         Version  Elapsed Time
Name                                    Status          Number   HH:MM:SS
.
Oracle Server
.                                      UPGRADED      12.1.0.1.0  00:10:20
JServer JAVA Virtual Machine
.                                         VALID      12.1.0.1.0  00:02:02
Oracle Workspace Manager
.                                         VALID      12.1.0.1.0  00:00:45
OLAP Analytic Workspace
.                                         VALID      12.1.0.1.0  00:00:24
Oracle OLAP API
.                                         VALID      12.1.0.1.0  00:00:13
Oracle XDK
.                                         VALID      12.1.0.1.0  00:00:29
Oracle Text
.                                         VALID      12.1.0.1.0  00:00:31
Oracle XML Database
.                                         VALID      12.1.0.1.0  00:03:05
Oracle Database Java Packages
.                                         VALID      12.1.0.1.0  00:00:09
Oracle Multimedia
.                                         VALID      12.1.0.1.0  00:01:33
Spatial
.                                         VALID      12.1.0.1.0  00:03:42
Oracle Application Express
.                                         VALID     4.2.0.00.27  00:17:26
Final Actions
.                                                                00:02:02
Total Upgrade Time: 00:42:55

PL/SQL procedure successfully completed.

SQL>

There maybe some INVALID components. Complete all postupgrade steps and try again. If there are still components INVALID you have to check out support.oracle.com or you can write me.

6.2 Run mandatory catuppst.sql

SQL> @?/rdbms/admin/catuppst.sql

Session altered.

Session altered.

Session altered.

TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP POSTUP_BGN 2013-07-13 14:13:38

TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP CATREQ_BGN 2013-07-13 14:13:38

PL/SQL procedure successfully completed.

catrequtlmg: b_StatEvt     = TRUE
catrequtlmg: b_SelProps    = FALSE
catrequtlmg: b_UpgradeMode = FALSE
catrequtlmg: b_InUtlMig    = FALSE

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP CATREQ_END 2013-07-13 14:13:38

catuppst: Dropping library DBMS_DDL_INTERNAL_LIB

PL/SQL procedure successfully completed.

catuppst: Dropping view _CURRENT_EDITION_OBJ_MIG

PL/SQL procedure successfully completed.

catuppst: Dropping view _ACTUAL_EDITION_OBJ_MIG

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

This script will migrate the Baseline data on a pre-11g database
to the 11g database.

...                                       ...
... Completed Moving the Baseline Data    ...
...                                       ...
... If there are no Move BL Data messages ...
... above, then there are no renamed      ...
... baseline tables in the system.        ...
...                                       ...
...                                       ...
... Completed the Dropping of the         ...
... Renamed Baseline Tables               ...
...                                       ...
... If there are no Drop Table messages   ...
... above, then there are no renamed      ...
... baseline tables in the system.        ...
...                                       ...

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

0 rows created.

Commit complete.

Table created.

2 rows created.

1 row updated.

2 rows updated.

0 rows updated.

Table dropped.

Commit complete.

0 rows updated.

Commit complete.

0 rows updated.

Commit complete.

0 rows updated.

Commit complete.

0 rows created.

Commit complete.

0 rows created.

Commit complete.

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP POSTUP_END 2013-07-13 14:13:39

PL/SQL procedure successfully completed.

Session altered.

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

Generating apply and rollback scripts...
Check the following file for errors:
/opt/oracle/app/product/12.1.0/dbhome_1/cfgtoollogs/catbundle/catbundle_PSU_DBUPGRD_GENERATE_2013Jul13_14_13_40.log
Apply script: /opt/oracle/app/product/12.1.0/dbhome_1/rdbms/admin/catbundle_PSU_DBUPGRD_APPLY.sql
Rollback script: /opt/oracle/app/product/12.1.0/dbhome_1/rdbms/admin/catbundle_PSU_DBUPGRD_ROLLBACK.sql

PL/SQL procedure successfully completed.

Executing script file...

SQL> alter session set "_ORACLE_SCRIPT" = true;

Session altered.

SQL> COLUMN spool_file NEW_VALUE spool_file NOPRINT
SQL> SELECT '/opt/oracle/app/product/12.1.0/dbhome_1/cfgtoollogs/catbundle/' || 'catbundle_PSU_' || name || '_APPLY_' || TO_CHAR(SYSDATE, 'YYYYMonDD_hh24_mi_ss', 'NLS_DATE_LANGUAGE=''AMERICAN''') || '.log' AS spool_file FROM v$database;

SQL> SPOOL &spool_file
SQL> exec dbms_registry.set_session_namespace('SERVER')

PL/SQL procedure successfully completed.

SQL> ALTER SESSION SET current_schema = SYS;

Session altered.

SQL> PROMPT Updating registry...
Updating registry...
SQL> INSERT INTO registry$history
  2    (action_time, action,
  3     namespace, version, id,
  4     bundle_series, comments)
  5  VALUES
  6    (SYSTIMESTAMP, 'APPLY',
  7     SYS_CONTEXT('REGISTRY$CTX','NAMESPACE'),
  8     '12.1.0.1',
  9     0,
 10     'PSU',
 11     'Patchset 12.1.0.0.0');

1 row created.

SQL> COMMIT;

Commit complete.

SQL> SPOOL off
SQL> SET echo off
Check the following log file for errors:
/opt/oracle/app/product/12.1.0/dbhome_1/cfgtoollogs/catbundle/catbundle_PSU_DBUPGRD_APPLY_2013Jul13_14_13_41.log

Session altered.

Session altered.

SQL>

6.3 Gather statistics & recompile

SQL> execute dbms_stats.gather_fixed_objects_stats;

PL/SQL procedure successfully completed.

SQL> @?/rdbms/admin/utlrp.sql

TIMESTAMP
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_BGN  2013-07-13 14:19:47

DOC>   The following PL/SQL block invokes UTL_RECOMP to recompile invalid
DOC>   objects in the database. Recompilation time is proportional to the
DOC>   number of invalid objects in the database, so this command may take
DOC>   a long time to execute on a database with a large number of invalid
DOC>   objects.
DOC>
DOC>   Use the following queries to track recompilation progress:
DOC>
DOC>   1. Query returning the number of invalid objects remaining. This
DOC>      number should decrease with time.
DOC>         SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6);
DOC>
DOC>   2. Query returning the number of objects compiled so far. This number
DOC>      should increase with time.
DOC>         SELECT COUNT(*) FROM UTL_RECOMP_COMPILED;
DOC>
DOC>   This script automatically chooses serial or parallel recompilation
DOC>   based on the number of CPUs available (parameter cpu_count) multiplied
DOC>   by the number of threads per CPU (parameter parallel_threads_per_cpu).
DOC>   On RAC, this number is added across all RAC nodes.
DOC>
DOC>   UTL_RECOMP uses DBMS_SCHEDULER to create jobs for parallel
DOC>   recompilation. Jobs are created without instance affinity so that they
DOC>   can migrate across RAC nodes. Use the following queries to verify
DOC>   whether UTL_RECOMP jobs are being created and run correctly:
DOC>
DOC>   1. Query showing jobs created by UTL_RECOMP
DOC>         SELECT job_name FROM dba_scheduler_jobs
DOC>            WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>
DOC>   2. Query showing UTL_RECOMP jobs that are running
DOC>         SELECT job_name FROM dba_scheduler_running_jobs
DOC>            WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>#

PL/SQL procedure successfully completed.

TIMESTAMP
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_END  2013-07-13 14:23:13

DOC> The following query reports the number of objects that have compiled
DOC> with errors.
DOC>
DOC> If the number is higher than expected, please examine the error
DOC> messages reported with each object (using SHOW ERRORS) to see if they
DOC> point to system misconfiguration or resource constraints that must be
DOC> fixed before attempting to recompile these objects.
DOC>#

OBJECTS WITH ERRORS
-------------------
                  0

DOC> The following query reports the number of errors caught during
DOC> recompilation. If this number is non-zero, please query the error
DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors
DOC> are due to misconfiguration or resource constraints that must be
DOC> fixed before objects can compile successfully.
DOC>#

ERRORS DURING RECOMPILATION
---------------------------
                          0

Function created.

PL/SQL procedure successfully completed.

Function dropped.

...Database user "SYS", database schema "APEX_040200", user# "110" 14:23:23
...Compiled 0 out of 2998 objects considered, 0 failed compilation 14:23:23
...263 packages
...255 package bodies
...453 tables
...11 functions
...16 procedures
...3 sequences
...458 triggers
...1322 indexes
...207 views
...0 libraries
...6 types
...0 type bodies
...0 operators
...0 index types
...Begin key object existence check 14:23:23
...Completed key object existence check 14:23:24
...Setting DBMS Registry 14:23:24
...Setting DBMS Registry Complete 14:23:24
...Exiting validate 14:23:24

PL/SQL procedure successfully completed.

SQL> select count(1) from dba_objects where status='INVALID';

  COUNT(1)
----------
         0

SQL>

6.4 postupgrade_fixup.sql

All fixable tasks are in the “postupgrade_fixup.sql” script.

[bash]$ sqlplus / as sysdba @/opt/oracle/app/product/11.2.0.3/dbhome_2/cfgtoollogs/DBUPGRD/preupgrade/postupgrade_fixups.sql

SQL*Plus: Release 12.1.0.1.0 Production on Sat Jul 13 14:28:55 2013

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

Post Upgrade Fixup Script Generated on 2013-07-13 13:19:35  Version: 12.1.0.1 Build: 006
Beginning Post-Upgrade Fixups...

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

**********************************************************************
Check Tag:     OLD_TIME_ZONES_EXIST
Check Summary: Check for use of older timezone data file
Fix Summary:   Update the timezone using the DBMS_DST package after upgrade is complete.
**********************************************************************
Fixup Returned Information:
INFORMATION: --> Older Timezone in use

     Database is using a time zone file older than version 18.
     After the upgrade, it is recommended that DBMS_DST package
     be used to upgrade the 12.1.0.1.0 database time zone version
     to the latest version which comes with the new release.
     Please refer to My Oracle Support note number 977512.1 for details.
**********************************************************************

PL/SQL procedure successfully completed.

**********************************************************************
                     [Post-Upgrade Recommendations]
**********************************************************************

PL/SQL procedure successfully completed.

                        *****************************************
                        ******** Fixed Object Statistics ********
                        *****************************************

Please create stats on fixed objects two weeks
after the upgrade using the command:
   EXECUTE DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;

^^^ MANUAL ACTION SUGGESTED ^^^

PL/SQL procedure successfully completed.

           **************************************************
                ************* Fixup Summary ************

 1 fixup routine generated an INFORMATIONAL message that should be reviewed.

PL/SQL procedure successfully completed.

*************** Post Upgrade Fixup Script Complete ********************

PL/SQL procedure successfully completed.

SQL>

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s