Upgrading Oracle Database 11.2.0.3 to 12.1.0 (Oracle 12c)



Upgrading Oracle Database 11.2.0.3 to 12.1.0 (Oracle 12c)There are different ways of upgrading to the latest release of Oracle database and Oracle provides multiple methods to upgrade. Few are listed below:Database Upgrade Assistant (DBUA)Manual UpgradeTransportable TablespacesDatapump export/importOracle StreamsOracle GoldenGateOracle Database Version:???????????? Oracle Database 11gR2 (11.2.0.3) (64-bit)Operating System: ? ? ? ? ? ? ? ? ? ? ? ? Oracle Enterprise Linux 5 (64-bit) Manual upgrade stepsPre upgrade stepsBackup Oracle databaseStop the databaseStop listenerInstall Oracle 12c rdbms software create 12c ORACLE_HOME environment variable in the 12c.env of “oracle” userRun Preupgrade script in order to collect required information about database status Increase processes numberRemove Enterprise Manager Database Control repositoryGather dictionary statsIncrease Tablespaces sizerun preupgrade_fixups.sqlshut down database and copy needed files ( spfile and password file to 12c oracle home)UPDATE THE ORATAB ENTRY TO SET THE NEW ORACLE_HOMEstartup upgrade with 12c oracle homestart upgrade process run catctl scripts Post upgrade stepsstartup database and run utlu121s.sqlrun catuppst.sql scriptsGather statistics recompile invalid objectsrun postupgrade_fixup.sql scriptsmodify parameter filecopy listener.ora and tnsnames.ora from 11g home to 12c homeupgrade database timezonedeinstall 11g softwareoracle@pansoft ] rman target / nocatalogRMAN> run2> {3> backup database format '/u01/backup/%U TAG before_upgrade’;4> backup current controlfile format '/u01/backup/%U tag before_upgrade’;5> }oracle@pansoft ]sqlplus / as sysdbasql>shut immediateoracle@pansoft ] lsnrctl stop prodoracle@pansoft 12c]$ ./runInstaller [oracle@pansoft ~]$ vi 12c.envexport ORACLE_HOME=/u01/12capp/oracle/product/12.1.0/dbhome_1export PATH=$PATH:$ORACLE_HOME/bin:.[oracle@pansoft admin]$ cd /u01/12capp/oracle/product/12.1.0/dbhome_1/rdbms/admin[oracle@pansoft admin]$ ls preupgrd.sql [oracle@pansoft ~]$ . 11g.env [oracle@pansoft ~]$ export ORACLE_SID=prod[oracle@pansoft ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Tue Dec 9 19:17:28 2014Copyright (c) 1982, 2011, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSql>spool upgrade.logSQL> @/u01/12capp/oracle/product/12.1.0/dbhome_1/rdbms/admin/utlu121i.sqlDOC> Note that the new preupgrd.sql script replaces the utlu121i.sql scriptDOC> and earlier versions of the Pre-Upgrade Information Tool.DOC>DOC> The Pre-Upgrade Information Tool, which now consists of preupgrd.sqlDOC> and utluppkg.sql.DOC>DOC> 1. Make sure preupgrd.sql and utluppkg.sql (located in the adminDOC> directory of the new installation of Oracle Database 12.1) areDOC> accessible while connected to your source database, which is theDOC> database to be upgradedDOC>DOC> 2. Connect to your source database using an account with DBA privilegesDOC> and execute the preupgrd.sql script.DOC>DOC> For more information on the Pre-Upgrade Information Tool, see theDOC> Oracle Database Upgrade Guide.?Run Preupgrade script in order to collect required information about database status.SQL> @/u01/12capp/oracle/product/12.1.0/dbhome_1/rdbms/admin/preupgrd.sqlLoading Pre-Upgrade Package...Executing Pre-Upgrade Checks...Pre-Upgrade Checks Complete. ************************************************************Results of the checks are located at: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/prod/preupgrade/preupgrade.logPre-Upgrade Fixup Script (run in source database environment): /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/prod/preupgrade/preupgrade_fixups.sqlPost-Upgrade Fixup Script (run shortly after upgrade): /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/prod/preupgrade/postupgrade_fixups.sql$more /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/prod/preupgrade/preupgrade.logOracle Database Pre-Upgrade Information Tool 12-09-2014 19:18:31Script Version: 12.1.0.1.0 Build: 006********************************************************************** Database Name: PROD 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 Enterprise Manager Repository [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: 1216 MB--> SYSAUX tablespace is adequate for the upgrade. minimum required size: 1455 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--> EXAMPLE tablespace is adequate for the upgrade. minimum required size: 309 MB [No adjustments recommended]******************************************************************************************************************************************** [Pre-Upgrade Checks]**********************************************************************WARNING: --> Process Count may be too low Database has a maximum process count of 150 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.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: @emremove.sql Without the set echo and serveroutput commands you will not be able to follow the progress of the script.WARNING: --> Existing DBMS_LDAP dependent objectsDatabase 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 RMATION: --> 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 RMATION: --> 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 toupgrading the database.To gather dictionary statistics execute the following commandwhile 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 weeksafter the upgrade using the command: EXECUTE DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;^^^ MANUAL ACTION SUGGESTED ^^^********************************************************************** ************ Summary ************ 0 ERRORS exist in your database. 3 WARNINGS 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 ***********************************?Increase processes number SQL> ALTER SYSTEM SET PROCESSES=300 SCOPE=SPFILE;?Remove??Enterprise Manager??Database Control??repositoryoracle@pansoft$ emctl stop dbconsoleSQL> @/u01/12capp/oracle/product/12.1.0/dbhome_1/rdbms/admin/emremove.sqlGather dictionary statsSQL> EXECUTE dbms_stats.gather_dictionary_stats;?Increase Tablespaces size SQL> alter database datafile '/u01/prod/system01.dbf' resize 2000m; SQL> alter database datafile '/u01/prod/sysaux01.dbf' resize 2000m;SQL> alter database datafile '/u01/prod/undotbs01.dbf' resize 2000m;SQL> alter database datafile '/u01/prod/users01.dbf' resize 2000m;SQL> alter tablespace temp add tempfile '/u01/prod/temp02.dbf' size 500m;SQL> PURGE DBA_RECYCLEBIN;This tool lists post-upgrade invalid objects that were not invalid prior to upgrade (it ignores pre-existing pre-upgrade invalid objects).SQL> @/u01/12capp/oracle/product/12.1.0/dbhome_1/rdbms/admin/utluiobj.sqlSQL> select count(*) from dba_objects where status='INVALID';COUNT(*)---------- 18SQL> @/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/utlrp.sqlSQL> select count(*) from dba_objects where status='INVALID'; COUNT(*)---------- 0 SQL>@/u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/prod/preupgrade/preupgrade_fixups.sqlPre-Upgrade Fixup Script Generated on 2014-12-09 19:18:29 Version: 12.1.0.1 Build: 006Beginning Pre-Upgrade Fixups...**********************************************************************Check Tag: DEFAULT_PROCESS_COUNTCheck Summary: Verify min process count is not too lowFix 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 150 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.Check Tag: EM_PRESENTCheck Summary: Check if Enterprise Manager is presentFix 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.********************************************************************************************************************************************Check Tag: DBMS_LDAP_DEPENDENCIES_EXISTCheck Summary: Check for dependency on DBMS_LDAP packageFix 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.********************************************************************************************************************************************Check Tag: AMD_EXISTSCheck Summary: Check to see if AMD is present in the databaseFix 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.******************************************************************************************************************************************** [Pre-Upgrade Recommendations]********************************************************************** ***************************************** ********* Dictionary Statistics *********Please gather dictionary statistics 24 hours prior toupgrading the database.To gather dictionary statistics execute the following commandwhile connected as SYSDBA: EXECUTE dbms_stats.gather_dictionary_stats;^^^ MANUAL ACTION SUGGESTED ^^^ ************* Fixup Summary ************ 4 fixup routines generated INFORMATIONAL messages that should be reviewed.**************** Pre-Upgrade Fixup Script Complete *********************Sql>startup forceShutdown the database ,copy needed files spfile and password file to new oracle homeoracle@panosft ]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/dbsoracle@pansoft ]$ cp spfileprod.ora /u01/12capp/oracle/product/12.1.0/dbhome_1/dbsoracle@panosft ]$ cp orapwprod /u01/12capp/oracle/product/12.1.0/dbhome_1/dbs/orapwprod Update the oratab entry to set the new ORACLE_HOMEoracle@panosft ]$ Vi /etc/oratabprod:/u01/app/oracle/product/11.2.0/dbhome_1:N (replace)prod:/u01/12capp/oracle/product/12.1.0/dbhome_1:Noracle@panosoft ] $ more /etc/oratabprod:/u01/12capp/oracle/product/12.1.0/dbhome_1:N[oracle@pansoft ~]$ . 12c.env [oracle@pansoft ~]$ . oraenvORACLE_SID = [prod] ? The Oracle base has been set to /u01/12capp/oracle[oracle@pansoft ~]$ sqlplus / as sysdbaSQL*Plus: Release 12.1.0.1.0 Production on Wed Dec 10 11:37:02 2014Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to an idle instance.SQL> startup UPGRADE;[oracle@pansoft ~]$ cd /u01/12capp/oracle/product/12.1.0/dbhome_1/rdbms/admin/The new script catctl replace catupgrd script used until 11gR2, in parallel mode (6 is the number of parallel processes used during upgrade phase) [oracle@pansoft admin]$ $ORACLE_HOME/perl/bin/perl catctl.pl -n 6 -l $ORACLE_HOME/diagnostics catupgrd.sqlAnalyzing file catupgrd.sqlLog files in /u01/12capp/oracle/product/12.1.0/dbhome_1/diagnostics14 scripts found in file catupgrd.sqlNext path: catalog.sql32 scripts found in file catalog.sqlNext path: catproc.sql37 scripts found in file catproc.sqlNext path: catptabs.sql61 scripts found in file catptabs.sqlNext path: catpdbms.sql205 scripts found in file catpdbms.sqlNext path: catpdeps.sql77 scripts found in file catpdeps.sqlNext path: catpprvt.sql260 scripts found in file catpprvt.sqlNext path: catpexec.sql26 scripts found in file catpexec.sqlNext path: cmpupgrd.sql16 scripts found in file cmpupgrd.sql[Phase 0] type is 1 with 1 Filescatupstr.sql [Phase 1] type is 1 with 3 Filescdstrt.sql cdfixed.sql cdcore.sql [Phase 2] type is 1 with 1 Filesora_restart.sql [Phase 3] type is 2 with 18 Filescdplsql.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 Filesora_restart.sql [Phase 5] type is 1 with 5 Filescdoptim.sql catsum.sql catexp.sql cddst.sql cdend.sql [Phase 6] type is 1 with 1 Filescatpstrt.sql [Phase 7] type is 1 with 3 Filescatptyps.sql catpgrants.sql catgwm.sql [Phase 8] type is 1 with 1 Filesora_restart.sql [Phase 9] type is 2 with 60 Filescatnodpt.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 Filesora_restart.sql [Phase 11] type is 1 with 1 Filescatpspec.sql [Phase 12] type is 1 with 1 Filesora_restart.sql [Phase 13] type is 2 with 199 Filesutlinad.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 Filesora_restart.sql [Phase 15] type is 1 with 3 Filesdbmsmeti.sql dbmsmetu.sql dbmsqopi.sql [Phase 16] type is 1 with 1 Filesora_restart.sql [Phase 17] type is 2 with 33 Filescatmettypes.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 Filesora_restart.sql [Phase 19] type is 1 with 3 Filesprvtkupc.plb prvtaqiu.plb catlsby.sql [Phase 20] type is 1 with 1 Filesora_restart.sql [Phase 21] type is 2 with 23 Filescatmetviews.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 Filesora_restart.sql [Phase 23] type is 2 with 11 Filescatmetgrant1.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 Filesora_restart.sql [Phase 25] type is 1 with 1 Files\catcdbviews.sql [Phase 26] type is 1 with 1 Filesora_restart.sql [Phase 27] type is 2 with 0 Files[Phase 28] type is 1 with 1 Filesora_load_without_comp.sql [Phase 29] type is 2 with 130 Filesprvtfile.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 Filesora_load_with_comp.sql [Phase 31] type is 1 with 1 Filesora_restart.sql [Phase 32] type is 1 with 1 Filesora_load_without_comp.sql [Phase 33] type is 2 with 122 Filesprvtbpui.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 Filesora_load_with_comp.sql [Phase 35] type is 1 with 1 Filesora_restart.sql [Phase 36] type is 1 with 4 Filescatmetinsert.sql catpcnfg.sql utluppkg.sql catdph.sql [Phase 37] type is 1 with 1 Filesora_restart.sql [Phase 38] type is 2 with 13 Filescatmetgrant2.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 Filesora_restart.sql [Phase 40] type is 2 with 10 Filesexecstr.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 Filesora_restart.sql [Phase 42] type is 1 with 1 Filescatpend.sql [Phase 43] type is 1 with 1 Filesora_restart.sql [Phase 44] type is 1 with 1 Filescatupprc.sql [Phase 45] type is 1 with 1 Filescmpupstr.sql [Phase 46] type is 1 with 1 Filesora_restart.sql [Phase 47] type is 1 with 2 Filescmpupjav.sql cmpupnjv.sql [Phase 48] type is 1 with 1 Filesora_restart.sql [Phase 49] type is 1 with 2 Filescmpupxdb.sql cmpupnxb.sql [Phase 50] type is 1 with 1 Filesora_restart.sql [Phase 51] type is 1 with 2 Filescmpupord.sql cmpupmsc.sql [Phase 52] type is 1 with 1 Filesora_restart.sql [Phase 53] type is 1 with 1 Filescmpupend.sql [Phase 54] type is 1 with 1 Filescatupend.sql [Phase 55] type is 1 with 1 Filescatuppst.sql [Phase 56] type is 1 with 1 Filescatshutdown.sql Post upgrade stepsoracle@panosft ] $?sqlplus? / as?sysdbaSQL>?startupSQL> @/u01/12capp/oracle/product/12.1.0/dbhome_1/rdbms/admin/utlu121s.sql.Oracle Database 12.1 Post-Upgrade Status Tool 12-14-2014 11:57:ponent Current Version Elapsed TimeName Status Number HH:MM:SS.Oracle Server. VALID 12.1.0.1.0 00:15:21JServer JAVA Virtual Machine. VALID 12.1.0.1.0 00:06:30Oracle Workspace Manager. VALID 12.1.0.1.0 00:01:31OLAP Analytic Workspace. VALID 12.1.0.1.0 00:01:20Oracle OLAP API. VALID 12.1.0.1.0 00:01:04Oracle XDK. VALID 12.1.0.1.0 00:01:22Oracle Text. VALID 12.1.0.1.0 00:02:08Oracle XML Database. VALID 12.1.0.1.0 00:05:41Oracle Database Java Packages. VALID 12.1.0.1.0 00:00:41Oracle Multimedia. VALID 12.1.0.1.0 00:31:46Spatial. VALID 12.1.0.1.0 00:08:11Oracle Application Express. VALID 4.2.0.00.27 00:16:55Final Actions. 00:03:08Total Upgrade Time: 01:36:57PL/SQL procedure successfully completed.SQL> @/u01/12capp/oracle/product/12.1.0/dbhome_1/rdbms/admin/catuppst.sqlSession altered.Session altered.Session altered.TIMESTAMP--------------------------------------------------------------------------------COMP_TIMESTAMP POSTUP_BGN 2014-12-14 11:58:51TIMESTAMP--------------------------------------------------------------------------------COMP_TIMESTAMP CATREQ_BGN 2014-12-14 11:58:51PL/SQL procedure successfully completed.catrequtlmg: b_StatEvt = TRUEcatrequtlmg: b_SelProps = FALSEcatrequtlmg: b_UpgradeMode = FALSEcatrequtlmg: b_InUtlMig = FALSEPL/SQL procedure successfully completed.PL/SQL procedure successfully completed.TIMESTAMP--------------------------------------------------------------------------------COMP_TIMESTAMP CATREQ_END 2014-12-14 11:58:51catuppst: Dropping library DBMS_DDL_INTERNAL_LIBPL/SQL procedure successfully completed.catuppst: Dropping view _CURRENT_EDITION_OBJ_MIGPL/SQL procedure successfully completed.catuppst: Dropping view _ACTUAL_EDITION_OBJ_MIGPL/SQL procedure successfully completed.PL/SQL procedure successfully completed.This script will migrate the Baseline data on a pre-11g databaseto 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 mit complete.Table created.2 rows created.1 row updated.2 rows updated.0 rows updated.Table mit complete.0 rows mit complete.0 rows mit complete.0 rows mit complete.0 rows mit complete.0 rows mit 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 2014-12-14 11:58:53PL/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:/u01/12capp/oracle/product/12.1.0/dbhome_1/cfgtoollogs/catbundle/catbundle_PSU_PROD_GENERATE_2014Dec14_11_59_00.logApply script: /u01/12capp/oracle/product/12.1.0/dbhome_1/rdbms/admin/catbundle_PSU_PROD_APPLY.sqlRollback script: /u01/12capp/oracle/product/12.1.0/dbhome_1/rdbms/admin/catbundle_PSU_PROD_ROLLBACK.sqlPL/SQL procedure successfully completed.Executing script file...SQL> alter session set "_ORACLE_SCRIPT" = true;Session altered.SQL> COLUMN spool_file NEW_VALUE spool_file NOPRINTSQL> SELECT '/u01/12capp/oracle/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_fileSQL> 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 offSQL> SET echo offCheck the following log file for errors:/u01/12capp/oracle/product/12.1.0/dbhome_1/cfgtoollogs/catbundle/catbundle_PSU_PROD_APPLY_2014Dec14_11_59_03.logSession altered.Session altered.Gather statistics $ recompileSql>EXECUTE DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;SQL> @/u01/12capp/oracle/product/12.1.0/dbhome_1/rdbms/admin/utluiobj.sqlThis tool lists post-upgrade invalid objects that were not invalidprior to upgrade (it ignores pre-existing pre-upgrade invalid objects).Sql>select owner,object_name,object_type,status from dba_objects where status=’INVALID’;SQL> @/u01/12capp/oracle/product/12.1.0/dbhome_1/rdbms/admin/utlrp.sqlSQL>@/u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/prod/preupgrade/postupgrade_fixups.sqlPost Upgrade Fixup Script Generated on 2014-12-09 19:18:29 Version: 12.1.0.1 Build: 006Beginning Post-Upgrade Fixups...PL/SQL procedure successfully completed.PL/SQL procedure successfully completed.**********************************************************************Check Tag: OLD_TIME_ZONES_EXISTCheck Summary: Check for use of older timezone data fileFix 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 weeksafter 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> alter system set diagnostic_dest='/u01/12capp/oracle' scope=spfile;sql>alter system set compatible='12.1.0.1.0' scope=spfile;[oracle@pansoft ~]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/[oracle@pansoft admin]$ cp -rvf listener.ora tnsnames.ora /u01/12capp/oracle/product/12.1.0/dbhome_1/network/admin/Vi listener.oraPROD = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521)) )ADR_BASE_PROD = /u01/12capp/oracleSID_LIST_PROD = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = prod) (ORACLE_HOME = /u01/12capp/oracle/product/12.1.0/dbhome_1) (SID_NAME = prod) ) )[oracle@pansoft admin]$ lsnrctl start prodLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 10-DEC-2014 15:22:27Copyright (c) 1991, 2011, Oracle. All rights reserved.Starting /u01/12capp/oracle/product/12.1.0/dbhome_1/bin/tnslsnr: please wait...TNSLSNR for Linux: Version 12.1.0.1.0 - ProductionSystem parameter file is /u01/12capp/oracle/product/12.1.0/dbhome_1/network/admin/listener.oraLog messages written to /u01/12capp/oracle/diag/tnslsnr/pansoft/prod/alert/log.xmlListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)))Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521)))STATUS of the LISTENER------------------------Alias prodVersion TNSLSNR for Linux: Version 12.1.0.1.0 - ProductionStart Date 10-DEC-2014 15:22:28Uptime 0 days 0 hr. 0 min. 1 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /u01/12capp/oracle/product/12.1.0/dbhome_1/network/admin/listener.oraListener Log File /u01/12capp/oracle/diag/tnslsnr/pansoft/prod/alert/log.xmlListening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)))Services Summary...Service "prod" has 1 instance(s). Instance "prod", status UNKNOWN, has 1 handler(s) for this service...SQL> select instance_name,version,status from v$instance;INSTANCE_NAME VERSION STATUS---------------- ----------------- ------------prod 12.1.0.1.0 OPENUpgrade database TimezoneScripts to automatically update the RDBMS DST (timezone) version in an 11gR2 or 12cR1 database . (Doc ID 1585343.1)oracle@pansoft ] lsupg_tzv_check.sql countTSTZdata.sql upg_tzv_apply.sql SQL> @countTSTZdata.sqlEstimating amount of TSTZ data.This might take some time.....For SYS tables first...Note: empty tables are not listed.Owner.Tablename.Columnname - count star of that columnSYS.ALERT_QT.SYS_NC00029$ - Count * is : 19SYS.AQ$_ALERT_QT_S.CREATION_TIME - Count * is : 5SYS.AQ$_ALERT_QT_S.DELETION_TIME - Count * is : 5SYS.AQ$_ALERT_QT_S.MODIFICATION_TIME - Count * is : 5SYS.AQ$_AQ$_MEM_MC_S.CREATION_TIME - Count * is : 3SYS.AQ$_AQ$_MEM_MC_S.DELETION_TIME - Count * is : 3SYS.AQ$_AQ$_MEM_MC_S.MODIFICATION_TIME - Count * is : 3SYS.AQ$_AQ_PROP_TABLE_S.CREATION_TIME - Count * is : 1SYS.AQ$_AQ_PROP_TABLE_S.DELETION_TIME - Count * is : 1SYS.AQ$_AQ_PROP_TABLE_S.MODIFICATION_TIME - Count * is : 1SYS.AQ$_KUPC$DATAPUMP_QUETAB_S.CREATION_TIME - Count * is : 1SYS.AQ$_KUPC$DATAPUMP_QUETAB_S.DELETION_TIME - Count * is : 1SYS.AQ$_KUPC$DATAPUMP_QUETAB_S.MODIFICATION_TIME - Count * is : 1SYS.AQ$_SCHEDULER$_EVENT_QTAB_S.CREATION_TIME - Count * is : 3SYS.AQ$_SCHEDULER$_EVENT_QTAB_S.DELETION_TIME - Count * is : 3SYS.AQ$_SCHEDULER$_EVENT_QTAB_S.MODIFICATION_TIME - Count * is : 3SYS.AQ$_SCHEDULER$_REMDB_JOBQTAB_S.CREATION_TIME - Count * is : 1SYS.AQ$_SCHEDULER$_REMDB_JOBQTAB_S.DELETION_TIME - Count * is : 1SYS.AQ$_SCHEDULER$_REMDB_JOBQTAB_S.MODIFICATION_TIME - Count * is : 1SYS.AQ$_SCHEDULER_FILEWATCHER_QT_S.CREATION_TIME - Count * is : 1SYS.AQ$_SCHEDULER_FILEWATCHER_QT_S.DELETION_TIME - Count * is : 1SYS.AQ$_SCHEDULER_FILEWATCHER_QT_S.MODIFICATION_TIME - Count * is : 1SYS.AQ$_SUBSCRIBER_TABLE.CREATION_TIME - Count * is : 1SYS.AQ$_SUBSCRIBER_TABLE.DELETION_TIME - Count * is : 1SYS.AQ$_SUBSCRIBER_TABLE.MODIFICATION_TIME - Count * is : 1SYS.AQ$_SYS$SERVICE_METRICS_TAB_S.CREATION_TIME - Count * is : 3SYS.AQ$_SYS$SERVICE_METRICS_TAB_S.DELETION_TIME - Count * is : 3SYS.AQ$_SYS$SERVICE_METRICS_TAB_S.MODIFICATION_TIME - Count * is : 3SYS.KET$_AUTOTASK_STATUS.ABA_START_TIME - Count * is : 1SYS.KET$_AUTOTASK_STATUS.ABA_STATE_TIME - Count * is : 1SYS.KET$_AUTOTASK_STATUS.MW_RECORD_TIME - Count * is : 1SYS.KET$_AUTOTASK_STATUS.MW_START_TIME - Count * is : 1SYS.KET$_AUTOTASK_STATUS.RECONCILE_TIME - Count * is : 1SYS.KET$_CLIENT_CONFIG.FIELD_2 - Count * is : 7SYS.KET$_CLIENT_CONFIG.LAST_CHANGE - Count * is : 7SYS.OPTSTAT_HIST_CONTROL$.SPARE6 - Count * is : 30SYS.OPTSTAT_HIST_CONTROL$.SVAL2 - Count * is : 30SYS.RADM_FPTM$.TSWTZ_COL - Count * is : 1SYS.REG$.NTFN_GROUPING_START_TIME - Count * is : 1SYS.REG$.REG_TIME - Count * is : 1SYS.SCHEDULER$_EVENT_LOG.LOG_DATE - Count * is : 129SYS.SCHEDULER$_GLOBAL_ATTRIBUTE.ATTR_TSTAMP - Count * is : 11SYS.SCHEDULER$_JOB.END_DATE - Count * is : 24SYS.SCHEDULER$_JOB.LAST_ENABLED_TIME - Count * is : 24SYS.SCHEDULER$_JOB.LAST_END_DATE - Count * is : 24SYS.SCHEDULER$_JOB.LAST_START_DATE - Count * is : 24SYS.SCHEDULER$_JOB.NEXT_RUN_DATE - Count * is : 24SYS.SCHEDULER$_JOB.START_DATE - Count * is : 24SYS.SCHEDULER$_JOB_RUN_DETAILS.LOG_DATE - Count * is : 115SYS.SCHEDULER$_JOB_RUN_DETAILS.REQ_START_DATE - Count * is : 115SYS.SCHEDULER$_JOB_RUN_DETAILS.START_DATE - Count * is : 115SYS.SCHEDULER$_SCHEDULE.END_DATE - Count * is : 4SYS.SCHEDULER$_SCHEDULE.REFERENCE_DATE - Count * is : 4SYS.SCHEDULER$_WINDOW.ACTUAL_START_DATE - Count * is : 9SYS.SCHEDULER$_WINDOW.END_DATE - Count * is : 9SYS.SCHEDULER$_WINDOW.LAST_START_DATE - Count * is : 9SYS.SCHEDULER$_WINDOW.MANUAL_OPEN_TIME - Count * is : 9SYS.SCHEDULER$_WINDOW.NEXT_START_DATE - Count * is : 9SYS.SCHEDULER$_WINDOW.START_DATE - Count * is : 9SYS.WRI$_ALERT_HISTORY.CREATION_TIME - Count * is : 70SYS.WRI$_ALERT_HISTORY.TIME_SUGGESTED - Count * is : 70SYS.WRI$_ALERT_OUTSTANDING.CREATION_TIME - Count * is : 1SYS.WRI$_ALERT_OUTSTANDING.TIME_SUGGESTED - Count * is : 1SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SAVTIME - Count * is : 29380SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SPARE6 - Count * is : 29380SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY.SAVTIME - Count * is : 65264SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY.SPARE6 - Count * is : 65264SYS.WRI$_OPTSTAT_IND_HISTORY.SAVTIME - Count * is : 2123SYS.WRI$_OPTSTAT_IND_HISTORY.SPARE6 - Count * is : 2123SYS.WRI$_OPTSTAT_OPR.END_TIME - Count * is : 207SYS.WRI$_OPTSTAT_OPR.SPARE6 - Count * is : 207SYS.WRI$_OPTSTAT_OPR.START_TIME - Count * is : 207SYS.WRI$_OPTSTAT_OPR_TASKS.END_TIME - Count * is : 4829SYS.WRI$_OPTSTAT_OPR_TASKS.SPARE6 - Count * is : 4829SYS.WRI$_OPTSTAT_OPR_TASKS.START_TIME - Count * is : 4829SYS.WRI$_OPTSTAT_TAB_HISTORY.SAVTIME - Count * is : 3927SYS.WRI$_OPTSTAT_TAB_HISTORY.SPARE6 - Count * is : 3927SYS.XS$PRIN.END_DATE - Count * is : 14SYS.XS$PRIN.START_DATE - Count * is : 14Total count * of SYS TSTZ columns ROWS is : 217515There are in total 145 SYS TSTZ columns..For non-SYS tables ...Note: empty tables are not listed.Owner.Tablename.Columnname - count star of that columnGSMADMIN_INTERNAL.AQ$_CHANGE_LOG_QUEUE_TABLE_S.CREATION_TIME - Count * is : 1GSMADMIN_INTERNAL.AQ$_CHANGE_LOG_QUEUE_TABLE_S.DELETION_TIME - Count * is : 1GSMADMIN_INTERNAL.AQ$_CHANGE_LOG_QUEUE_TABLE_S.MODIFICATION_TIME - Count * is :1IX.AQ$_ORDERS_QUEUETABLE_S.CREATION_TIME - Count * is : 4IX.AQ$_ORDERS_QUEUETABLE_S.DELETION_TIME - Count * is : 4IX.AQ$_ORDERS_QUEUETABLE_S.MODIFICATION_TIME - Count * is : 4IX.AQ$_STREAMS_QUEUE_TABLE_S.CREATION_TIME - Count * is : 1IX.AQ$_STREAMS_QUEUE_TABLE_S.DELETION_TIME - Count * is : 1IX.AQ$_STREAMS_QUEUE_TABLE_S.MODIFICATION_TIME - Count * is : 1WMSYS.AQ$_WM$EVENT_QUEUE_TABLE_S.CREATION_TIME - Count * is : 1WMSYS.AQ$_WM$EVENT_QUEUE_TABLE_S.DELETION_TIME - Count * is : 1WMSYS.AQ$_WM$EVENT_QUEUE_TABLE_S.MODIFICATION_TIME - Count * is : 1WMSYS.WM$WORKSPACES_TABLE$.CREATETIME - Count * is : 1WMSYS.WM$WORKSPACES_TABLE$.LAST_CHANGE - Count * is : 1Total count * of non-SYS TSTZ columns ROWS is : 23There are in total 30 non-SYS TSTZ columns.Total Minutes elapsed : 0SQL> @upg_tzv_check.sqlINFO: Starting with RDBMS DST update : NO actual RDBMS DST update will be done by this : If an ERROR occurs the script will EXIT : Doing checks for known issues ...INFO: Database version is 12.1.0.1 .INFO: Database RDBMS DST version is DSTv14 .INFO: No known issues : Now detecting new RDBMS DST version.A prepare window has been successfully : Newest RDBMS DST version detected is DSTv18 .INFO: Next step is checking all TSTZ : It might take a while before any further output is seen ...A prepare window has been successfully : A newer RDBMS DST version than the one currently used is : Note that NO DST update was yet : Now run upg_tzv_apply.sql to do the actual RDBMS DST : Note that the upg_tzv_apply.sql script willINFO: restart the database 2 times WITHOUT any confirmation or prompt.SQL> @upg_tzv_apply.sqlINFO: If an ERROR occurs the script will EXIT : The database RDBMS DST version will be updated to DSTv18 .WARNING: This script will restart the database 2 timesWARNING: WITHOUT asking ANY confirmation.WARNING: Hit control-c NOW if this is not : Restarting the database in UPGRADE mode to start the DST upgrade.Database closed.Database dismounted.ORACLE instance shut down.ORACLE instance started.Total System Global Area 830930944 bytesFixed Size 2293832 bytesVariable Size 553652152 bytesDatabase Buffers 272629760 bytesRedo Buffers 2355200 bytesDatabase mounted.Database : Starting the RDBMS DST : Upgrading all SYS owned TSTZ : It might take time before any further output is seen ...An upgrade window has been successfully : Restarting the database in NORMAL mode to upgrade non-SYS TSTZ data.Database closed.Database dismounted.ORACLE instance shut down.ORACLE instance started.Total System Global Area 830930944 bytesFixed Size 2293832 bytesVariable Size 553652152 bytesDatabase Buffers 272629760 bytesRedo Buffers 2355200 bytesDatabase mounted.Database : Upgrading all non-SYS TSTZ : It might take time before any further output is seen ...INFO: Do NOT start any application yet that uses TSTZ data!INFO: Next is a list of all upgraded tables:Table list: "IX"."AQ$_STREAMS_QUEUE_TABLE_S"Number of failures: 0Table list: "IX"."AQ$_STREAMS_QUEUE_TABLE_L"Number of failures: 0Table list: "IX"."AQ$_ORDERS_QUEUETABLE_S"Number of failures: 0Table list: "IX"."AQ$_ORDERS_QUEUETABLE_L"Number of failures: 0Table list: "GSMADMIN_INTERNAL"."AQ$_CHANGE_LOG_QUEUE_TABLE_S"Number of failures: 0Table list: "GSMADMIN_INTERNAL"."AQ$_CHANGE_LOG_QUEUE_TABLE_L"Number of failures: 0Table list: "APEX_040200"."WWV_FLOW_WORKSHEET_NOTIFY"Number of failures: 0Table list: "APEX_040200"."WWV_FLOW_FEEDBACK_FOLLOWUP"Number of failures: 0Table list: "APEX_040200"."WWV_FLOW_FEEDBACK"Number of failures: 0Table list: "APEX_040200"."WWV_FLOW_DEBUG_MESSAGES2"Number of failures: 0Table list: "APEX_040200"."WWV_FLOW_DEBUG_MESSAGES"Number of failures: 0INFO: Total failures during update of TSTZ data: 0 .An upgrade window has been successfully : Your new Server RDBMS DST version is DSTv18 .INFO: The RDBMS DST update is successfully : Make sure to exit this sqlplus : Do not use it for timezone related selects.SQL> SELECT version FROM v$timezone_file; VERSION---------- 181 row selected.deinstall 11g softwareoracle@panosft ]?$ cd $ORACLE_HOME/deinstall [oracle@pansoft deinstall]$ ./deinstall ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download