This article provides an overview of manual
upgrade of existing databases to Oracle 12c Release 1. Upgrades can be
complicated and risky, it is always suggested to evaluate the environment and
upgrade must be tested before moving to production environment and you must
always read the upgrade manual.
Moreover this article does not include
any references to CDB or PDB databases.
1. Supported Upgrade Paths
Direct upgrades to 12c are possible
from existing databases with versions 10.2.0.5+, 11.1.0.7+, or release
11.2.0.2+. Upgrades from other versions are supported only via intermediate
upgrades to a supported upgrade version.
NOTE:- Before starting the database upgrade
activity make sure we have good consistent backup to recover the database in
case of any mishappening. Or if in any case we have to roll back the things.
3. Running Pre-Upgrade Information Tool
>> Oracle has introduced two new scripts for pre-upgrade check i.e. "preupgrd.sql" and "utluppkg.sql"
>> Copy the "preupgrd.sql" and "utluppkg.sql" scripts from the oracle12c home to any location accessible to database that needs upgrading. We used a directory under "/tmp/preupgradechk".
$ mkdir -p /tmp/preupgradechk
$ cp /u01/app/oracle/product/12.1.0.1/db_1/rdbms/admin/preupgrd.sql /tmp/preupgradechk
$ cp /u01/app/oracle/product/12.1.0.1/db_1/rdbms/admin/utluppkg.sql /tmp/preupgradechk
4. Run Preupgrade Scripts
If already not set then set the environment for the pre-upgrade scripts for the database that needs upgrade and run script from SQL*Plus.
$ export ORACLE_SID=oradb
$ cd /tmp/preupgradechk
$ sqlplus / as sysdba
SQL> @preupgrd.sql
Loading Pre-Upgrade Package...
Executing Pre-Upgrade Checks...
Pre-Upgrade Checks Complete.
************************************************************
Results of the checks are located at:
/u01/app/oracle/cfgtoollogs/orcl/preupgrade/preupgrade.log
Pre-Upgrade Fixup Script (run in source database environment):
/u01/app/oracle/cfgtoollogs/orcl/preupgrade/preupgrade_fixups.sql
Post-Upgrade Fixup Script (run shortly after upgrade):
/u01/app/oracle/cfgtoollogs/orcl/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>
5. Pre-Upgrade Information Tool
The Pre-Upgrade Information Tool produces 3 scripts.
• preupgrade.log : it shows the results of all the checks performed. Check if it is safe to continue with the upgrade.
• preupgrade_fixups.sql : A fixup script that should be run before the upgrade.
• postupgrade_fixups.sql : A fixup script that should be run after the upgrade.
6. Run preupgrade_fixups.sql
If there are no constraints shown in the "preupgrade.log" file, run the "preupgrade_fixups.sql" script. Any changes scripts cannot perform are flagged as "MANUAL ACTION SUGGESTED".
Pre-Upgrade Information Tool displays recommendations but does not execute the recommendations automatically in order to ensure that you have control over how and when the fix-up scripts are run
SQL> @/u01/app/oracle/cfgtoollogs/orcl/preupgrade/preupgrade_fixups.sql
Pre-Upgrade Fixup Script Generated on 2013-07-24 15:00:32 Version: 12.1.0.1 Build: 006
Beginning Pre-Upgrade Fixups...
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
**********************************************************************
Check Tag: DEFAULT_PROCESS_COUNT
Check Summary: Verify min process count is not too low
Fix Summary: Review and increase if needed, your PROCESSES value.
**********************************************************************
Fixup Returned Information:
WARNING: --> Process Count may be too low
Database has a maximum process count of 250 which is lower than the default value of
300 for this release.
You should update your processes value prior to the upgrade to a value of at least 300.
For example:
ALTER SYSTEM SET PROCESSES=300 SCOPE=SPFILE or update your init.ora file.
**********************************************************************
PL/SQL procedure successfully completed.
**********************************************************************
Check Tag: EM_PRESENT
Check Summary: Check if Enterprise Manager is present
Fix Summary: Execute emremove.sql prior to upgrade.
**********************************************************************
Fixup Returned Information:
WARNING: --> Enterprise Manager Database Control repository found in the database
In Oracle Database 12c, Database Control is removed during
the upgrade. To save time during the Upgrade, this action
can be done prior to upgrading using the following steps after
copying rdbms/admin/emremove.sql from the new Oracle home
- Stop EM Database Control:
$> emctl stop dbconsole
- Connect to the Database using the SYS account AS SYSDBA:
SET ECHO ON;
SET SERVEROUTPUT ON;
@emremove.sql
Without the set echo and serveroutput commands you will not
be able to follow the progress of the script.
**********************************************************************
PL/SQL procedure successfully completed.
**********************************************************************
Check Tag: DBMS_LDAP_DEPENDENCIES_EXIST
Check Summary: Check for dependency on DBMS_LDAP package
Fix Summary: Network Objects must be reviewed manually.
**********************************************************************
Fixup Returned Information:
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.
**********************************************************************
PL/SQL procedure successfully completed.
**********************************************************************
Check Tag: AMD_EXISTS
Check Summary: Check to see if AMD is present in the database
Fix Summary: Manually execute ORACLE_HOME/oraolap/admin/catnoamd.sql script to remove OLAP.
**********************************************************************
Fixup Returned Information:
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.
**********************************************************************
PL/SQL procedure successfully completed.
**********************************************************************
[Pre-Upgrade Recommendations]
**********************************************************************
PL/SQL procedure successfully completed.
*****************************************
********* 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 ^^^
PL/SQL procedure successfully completed.
**************************************************
************* Fixup Summary ************
4 fixup routines generated INFORMATIONAL messages that should be reviewed.
PL/SQL procedure successfully completed.
**************** Pre-Upgrade Fixup Script Complete *********************
PL/SQL procedure successfully completed.
SQL>
7. Execute Changes as recommended Preupgrade_fixups.sql script
Make suggested changes as per your environment.
ALTER SYSTEM SET PROCESSES=300 SCOPE=SPFILE;
SET ECHO ON;
SET SERVEROUTPUT ON;
-- emremove.sql scrip located in the 12c home.
@/u01/app/oracle/product/12.1.0.1/db_1/rdbms/admin/emremove.sql
-- Removing this before the upgrade will result in the errors shown below.
-- These errors are not show-stoppers, but if you want a cleaner run through,
-- remove this feature after the upgrade.
@?/olap/admin/catnoamd.sql
EXECUTE dbms_stats.gather_dictionary_stats;
-- Shutdown the database.
SHUTDOWN IMMEDIATE;
8. Copy Password and Parameter file
Copy the parameter and password files from the old home to the 12c home.
$ cp /u01/app/oracle/product/11.2.0.3/db_1/dbs/spfileorcl.ora -/u01/app/oracle/product/12.1.0.1/db_1/dbs
$ cp /u01/app/oracle/product/11.2.0.3/db_1/dbs/orapworcl /u01/app/oracle/product/12.1.0.1/db_1/dbs
9. Deprecated Parameters
If the "preupgrade.log" file points to deprecated parameters, make the suggested changes to the parameters now before continuing.
10. Setting New Home
Edit the "/etc/oratab" file, setting the new ORACLE_HOME value.
oradb:/u01/app/oracle/product/12.1.0.1/db_1:Y
11. Upgrading the database
Before starting upgrade make sure the environment is set to the 12c home. And start the database in upgrade mode.
$ export ORACLE_SID=oradb
$ sqlplus / as sysdba
SQL> STARTUP UPGRADE;
SQL> EXIT;
12. Parallel Upgrade Utility
Upgrade parallelism is a new feature introduced in Oracle database 12cR1 where upgrade scripts and processes can run in parallel.Parallelism is designed to take full advantage of the CPU capacity resulting in reduced time to upgrade.Parallelism will break down each SQL file into stand-alone (independent) components.If the SQL file is stand-alone then it can be run in parallel with another SQL file.This is not always the case for all SQL scripts as some SQL scripts depend on each other and can call other utilities.In this case, Oracle ensures those dependencies are satisfied before calling the next script or reference to them. The purpose of dividing the upgrade into phases is due to the upgrade parallelism.Phases are how Oracle upgrade will load sql files in parallel. One phase has to complete before moving onto the next phase.By default, the upgrade runs with a parallelism of 4.Improvements have been observed even with a single CPU by setting the count to 4.The upgrade can get more CPU cycles to do the work even though there is only a single process/CPU.
The Upgrade Utility (catctl.pl), has been introduced in Oracle Database 12cR1.It loads the data dictionary and components in parallel thus reducing the overall upgrade time.It enables components that do not have to be upgraded in a specific order to be upgraded at the same time e.g. In parallel
13. Run catctl.pl
Running upgrade utility with a parallel level of 8.
$ cd $ORACLE_HOME/rdbms/admin
$ @ORACLE_HOME/perl/bin/perl catctl.pl -n 8 catupgrd.sql
We have added the output from this
utility in appendix 1.
14. Start Upgraded database
Startup the upgraded database and run the "utlu121s.sql" script to check the summary of the upgrade results.
$ sqlplus / as sysdba
SQL> STARTUP;
SQL> @utlu121s.sql
.
Oracle Database 12.1 Post-Upgrade Status Tool 07-24-2013 17:24:18
.
Component Current Version Elapsed Time
Name Status Number HH:MM:SS
.
Oracle Server. UPGRADED 12.1.0.1.0 00:16:48
JServer JAVA Virtual Machine . VALID 12.1.0.1.0 00:04:47
Oracle Workspace Manager. VALID 12.1.0.1.0 00:01:17
OLAP Analytic Workspace. VALID 12.1.0.1.0 00:00:53
Oracle XDK. VALID 12.1.0.1.0 00:00:48
Oracle Text. VALID 12.1.0.1.0 00:01:07
Oracle XML Database. VALID 12.1.0.1.0 00:04:35
Oracle Database Java Packages VALID 12.1.0.1.0 00:00:22
Oracle Multimedia VALID 12.1.0.1.0 00:02:42
Spatial VALID 12.1.0.1.0 00:06:21
Oracle Application Express VALID 4.2.0.00.27 00:25:28
Final Actions. 00:02:47
Total Upgrade Time: 01:00:02
PL/SQL procedure successfully completed.
SQL>
15. Running catuppst.sql
If there is no error, the "catuppst.sql" script would have been run as part of the upgrade. As we do not found any errors, we can run it manually.
SQL> @catuppst.sql
16. Run postupgrade_fixups.sql
If the "postupgrade_fixups.sql" file contained any recommendations, you can run it now.
SQL> @/u01/app/oracle/cfgtoollogs/orcl/preupgrade/postupgrade_fixups.sql
As a best practice for manual upgrade suggests it is recommended to run below scripts.
-- The following item is probably included in your postupgrade_fixups.sql script.
EXECUTE DBMS_STATS.gather_fixed_objects_stats;
-- Recompile invalid objects.
@utlrp.sql
-- Check for newly invalid objects.
@utluiobj.sql
-- Run again to check the final outcome of the upgrade.
@utlu121s.sql
17. Validate Upgraded Database
The upgraded database is now available.
$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Wed Jul 24 18:17:03 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
SQL> SELECT name, open_mode FROM v$database;
NAME OPEN_MODE
--------- --------------------
ORADB READ WRITE
SQL>
Remember to alter any script or profile files that contain references to the ORACLE_HOME environment variable.
18. Appendix 1
$ $ORACLE_HOME/perl/bin/perl catctl.pl 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: 207s
Serial Phase #: 1 Files: 3 Time: 69s
Restart Phase #: 2 Files: 1 Time: 0s
Parallel Phase #: 3 Files: 18 Time: 22s
Restart Phase #: 4 Files: 1 Time: 0s
Serial Phase #: 5 Files: 5 Time: 29s
Serial Phase #: 6 Files: 1 Time: 16s
Serial Phase #: 7 Files: 3 Time: 10s
Restart Phase #: 8 Files: 1 Time: 0s
Parallel Phase #: 9 Files: 60 Time: 76s
Restart Phase #:10 Files: 1 Time: 0s
Serial Phase #:11 Files: 1 Time: 31s
Restart Phase #:12 Files: 1 Time: 1s
Parallel Phase #:13 Files: 199 Time: 56s
Restart Phase #:14 Files: 1 Time: 0s
Serial Phase #:15 Files: 3 Time: 2s
Restart Phase #:16 Files: 1 Time: 0s
Parallel Phase #:17 Files: 33 Time: 49s
Restart Phase #:18 Files: 1 Time: 0s
Serial Phase #:19 Files: 3 Time: 11s
Restart Phase #:20 Files: 1 Time: 0s
Parallel Phase #:21 Files: 23 Time: 124s
Restart Phase #:22 Files: 1 Time: 0s
Parallel Phase #:23 Files: 11 Time: 73s
Restart Phase #:24 Files: 1 Time: 0s
Serial Phase #:25 Files: 1 Time: 42s
Restart Phase #:26 Files: 1 Time: 0s
Parallel Phase #:27 Files: 0 Time: 1s
Serial Phase #:28 Files: 1 Time: 0s
Parallel Phase #:29 Files: 130 Time: 12s
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: 17s
Serial Phase #:34 Files: 1 Time: 0s
Restart Phase #:35 Files: 1 Time: 0s
Serial Phase #:36 Files: 4 Time: 66s
Restart Phase #:37 Files: 1 Time: 0s
Parallel Phase #:38 Files: 13 Time: 66s
Restart Phase #:39 Files: 1 Time: 0s
Parallel Phase #:40 Files: 10 Time: 15s
Restart Phase #:41 Files: 1 Time: 0s
Serial Phase #:42 Files: 1 Time: 8s
Restart Phase #:43 Files: 1 Time: 0s
Serial Phase #:44 Files: 1 Time: 6s
Serial Phase #:45 Files: 1 Time: 1s
Restart Phase #:46 Files: 1 Time: 0s
Serial Phase #:47 Files: 2 Time: 390s
Restart Phase #:48 Files: 1 Time: 2s
Serial Phase #:49 Files: 2 Time: 443s
Restart Phase #:50 Files: 1 Time: 1s
Serial Phase #:51 Files: 2 Time: 2145s
Restart Phase #:52 Files: 1 Time: 7s
Serial Phase #:53 Files: 1 Time: 4s
Serial Phase #:54 Files: 1
*** WARNING: ERRORS FOUND DURING UPGRADE ***
Due to errors found during the upgrade process, the post
upgrade actions in catuppst.sql have not been automatically run.
*** THEREFORE THE DATABASE UPGRADE IS NOT YET COMPLETE ***
1. Evaluate the errors found in the upgrade logs (*.log) and determine the proper action.
2. Execute the post upgrade script as described in Chapter 3 of the Database Upgrade Guide.
Time: 199s
Grand Total Time: 4201s
$
No comments:
Post a Comment