1. Set the Oracle home to 12cR2 and oracle SID to the database to be restored.
echo $ORACLE_HOME /opt/app/oracle/product/12.2.0/sehome_1 export ORACLE_SID=std11g42. Restore and recover the database
RMAN> startup nomount; RMAN> create spfile from pfile; RMAN> startup force nomount; RMAN> restore controlfile from '/home/oracle/backup/control.bkp'; Starting restore at 13-JUN-17 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=191 device type=DISK channel ORA_DISK_1: restoring control file channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 output file name=/opt/app/oracle/oradata/STD11G4/controlfile/o1_mf_dmzw8m24_.ctl output file name=/opt/app/oracle/fast_recovery/STD11G4/controlfile/o1_mf_dmzw8m6g_.ctl Finished restore at 13-JUN-17 RMAN> alter database mount; Statement processed released channel: ORA_DISK_1 RMAN> crosscheck backupset; Starting implicit crosscheck backup at 13-JUN-17 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=156 device type=DISK Crosschecked 4 objects Finished implicit crosscheck backup at 13-JUN-17 Starting implicit crosscheck copy at 13-JUN-17 using channel ORA_DISK_1 Finished implicit crosscheck copy at 13-JUN-17 searching for all files in the recovery area cataloging files... no files cataloged using channel ORA_DISK_1 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=/usr/local/backups/db0rs6mrr3_1_1.bkp RECID=25 STAMP=946564963 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=/usr/local/backups/db0ss6mrto_1_1.bkp RECID=26 STAMP=946565048 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=/usr/local/backups/db0ts6mrtp_1_1.bkp RECID=27 STAMP=946565049 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=/data/flash_recovery/STD11G4/autobackup/2017_06_13/o1_mf_s_946564859_dmzv1c4q_.bkp RECID=28 STAMP=946565051 Crosschecked 4 objects RMAN> delete noprompt expired backup; using channel ORA_DISK_1 deleted backup piece backup piece handle=/usr/local/backups/db0rs6mrr3_1_1.bkp RECID=25 STAMP=946564963 deleted backup piece backup piece handle=/usr/local/backups/db0ss6mrto_1_1.bkp RECID=26 STAMP=946565048 deleted backup piece backup piece handle=/usr/local/backups/db0ts6mrtp_1_1.bkp RECID=27 STAMP=946565049 deleted backup piece backup piece handle=/data/flash_recovery/STD11G4/autobackup/2017_06_13/o1_mf_s_946564859_dmzv1c4q_.bkp RECID=28 STAMP=946565051 Deleted 4 EXPIRED objects RMAN> catalog start with '/home/oracle/backup/' noprompt; searching for all files that match the pattern /home/oracle/backup/ List of Files Unknown to the Database ===================================== File Name: /home/oracle/backup/res.rmn File Name: /home/oracle/backup/control.bkp File Name: /home/oracle/backup/db0rs6mrr3_1_1.bkp File Name: /home/oracle/backup/db0ss6mrto_1_1.bkp File Name: /home/oracle/backup/db0ts6mrtp_1_1.bkp File Name: /home/oracle/backup/pfile.ora cataloging files... cataloging done List of Cataloged Files ======================= File Name: /home/oracle/backup/control.bkp File Name: /home/oracle/backup/db0rs6mrr3_1_1.bkp File Name: /home/oracle/backup/db0ss6mrto_1_1.bkp File Name: /home/oracle/backup/db0ts6mrtp_1_1.bkp List of Files Which Were Not Cataloged ======================================= File Name: /home/oracle/backup/res.rmn RMAN-07517: Reason: The file header is corrupted File Name: /home/oracle/backup/pfile.ora RMAN-07517: Reason: The file header is corrupted RMAN> run { 2> restore database; 3> recover database; 4> } Starting restore at 13-JUN-17 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00001 to /data/oradata/STD11G4/datafile/o1_mf_system_c783t3v8_.dbf channel ORA_DISK_1: restoring datafile 00002 to /data/oradata/STD11G4/datafile/o1_mf_sysaux_c783t3vy_.dbf channel ORA_DISK_1: restoring datafile 00003 to /data/oradata/STD11G4/datafile/o1_mf_undotbs1_c783t3x3_.dbf channel ORA_DISK_1: restoring datafile 00004 to /data/oradata/STD11G4/datafile/o1_mf_users_c783t3ss_.dbf channel ORA_DISK_1: restoring datafile 00005 to /data/oradata/STD11G4/datafile/o1_mf_tools_c783t3rr_.dbf channel ORA_DISK_1: restoring datafile 00006 to /data/oradata/STD11G4/datafile/o1_mf_abc_c783t3yz_.dbf channel ORA_DISK_1: restoring datafile 00009 to /data/oradata/STD11G4/datafile/o1_mf_abc_crdch1bd_.dbf channel ORA_DISK_1: reading from backup piece /home/oracle/backup/db0rs6mrr3_1_1.bkp channel ORA_DISK_1: piece handle=/home/oracle/backup/db0rs6mrr3_1_1.bkp tag=TAG20170613T144243 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:02:16 channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00007 to /data/oradata/STD11G4/datafile/o1_mf_tbs2k_cwto1wx1_.dbf channel ORA_DISK_1: reading from backup piece /home/oracle/backup/db0ss6mrto_1_1.bkp channel ORA_DISK_1: piece handle=/home/oracle/backup/db0ss6mrto_1_1.bkp tag=TAG20170613T144243 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00008 to /data/oradata/STD11G4/datafile/o1_mf_tbs32k_cwto2cr8_.dbf channel ORA_DISK_1: reading from backup piece /home/oracle/backup/db0ts6mrtp_1_1.bkp channel ORA_DISK_1: piece handle=/home/oracle/backup/db0ts6mrtp_1_1.bkp tag=TAG20170613T144243 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 Finished restore at 13-JUN-17 Starting recover at 13-JUN-17 using channel ORA_DISK_1 starting media recovery RMAN-08187: warning: media recovery until SCN 13940762 complete Finished recover at 13-JUN-173. Instead of the "open resetlogs" open the database using "open resetlogs upgrade". The errors are ignorable.
RMAN> alter database open resetlogs upgrade; Statement processed RMAN-06900: warning: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT row RMAN-06901: warning: disabling update of the V$RMAN_STATUS and V$RMAN_OUTPUT rows ORACLE error from target database: ORA-04023: Object SYS.STANDARD could not be validated or authorized4. Check the database status, it should be in open migrate status.
SQL> select status from v$instance; STATUS ------------ OPEN MIGRATE5. Run the dbupgrade to commence the DB upgrade to 12.2
$ dbupgrade Argument list for [/opt/app/oracle/product/12.2.0/sehome_1/rdbms/admin/catctl.pl] Run in c = 0 Do not run in C = 0 Input Directory d = 0 Echo OFF e = 1 Simulate E = 0 Forced cleanup F = 0 Log Id i = 0 Child Process I = 0 Log Dir l = 0 Priority List Name L = 0 Upgrade Mode active M = 0 SQL Process Count n = 0 SQL PDB Process Count N = 0 Open Mode Normal o = 0 Start Phase p = 0 End Phase P = 0 Reverse Order r = 0 AutoUpgrade Resume R = 0 Script s = 0 Serial Run S = 0 RO User Tablespaces T = 0 Display Phases y = 0 Debug catcon.pm z = 0 Debug catctl.pl Z = 0 catctl.pl VERSION: [12.2.0.1.0] STATUS: [production] BUILD: [RDBMS_12.2.0.1.0_LINUX.X64_170125] /opt/app/oracle/product/12.2.0/sehome_1/rdbms/admin/orahome = [/opt/app/oracle/product/12.2.0/sehome_1] /opt/app/oracle/product/12.2.0/sehome_1/bin/orabasehome = [/opt/app/oracle/product/12.2.0/sehome_1] catctlGetOrabase = [/opt/app/oracle/product/12.2.0/sehome_1] Analyzing file /opt/app/oracle/product/12.2.0/sehome_1/rdbms/admin/catupgrd.sql Log file directory = [/tmp/cfgtoollogs/upgrade20170613150844] catcon: ALL catcon-related output will be written to [/tmp/cfgtoollogs/upgrade20170613150844/catupgrd_catcon_14703.lst] catcon: See [/tmp/cfgtoollogs/upgrade20170613150844/catupgrd*.log] files for output generated by scripts catcon: See [/tmp/cfgtoollogs/upgrade20170613150844/catupgrd_*.lst] files for spool files, if any Number of Cpus = 8 Database Name = STD11G4 DataBase Version = 11.2.0.4.0 catcon: ALL catcon-related output will be written to [/opt/app/oracle/product/12.2.0/sehome_1/cfgtoollogs/STD11G4/upgrade20170613150846/catupgrd_catcon_14703.lst] catcon: See [/opt/app/oracle/product/12.2.0/sehome_1/cfgtoollogs/STD11G4/upgrade20170613150846/catupgrd*.log] files for output generated by scripts catcon: See [/opt/app/oracle/product/12.2.0/sehome_1/cfgtoollogs/STD11G4/upgrade20170613150846/catupgrd_*.lst] files for spool files, if any Log file directory = [/opt/app/oracle/product/12.2.0/sehome_1/cfgtoollogs/STD11G4/upgrade20170613150846] Parallel SQL Process Count = 4 Components in [STD11G4] Installed [APS CATALOG CATJAVA CATPROC CONTEXT EM JAVAVM OWM XDB XML XOQ] Not Installed [APEX DV MGW ODM OLS ORDIM RAC SDO WK] ------------------------------------------------------ Phases [0-115] Start Time:[2017_06_13 15:08:46] ------------------------------------------------------ *********** Executing Change Scripts *********** Serial Phase #:0 [STD11G4] Files:1 Time: 177s *************** Catalog Core SQL *************** Serial Phase #:1 [STD11G4] Files:5 Time: 126s Restart Phase #:2 [STD11G4] Files:1 Time: 1s *********** Catalog Tables and Views *********** Parallel Phase #:3 [STD11G4] Files:19 Time: 48s Restart Phase #:4 [STD11G4] Files:1 Time: 0s ************* Catalog Final Scripts ************ Serial Phase #:5 [STD11G4] Files:6 Time: 43s ***************** Catproc Start **************** Serial Phase #:6 [STD11G4] Files:1 Time: 28s ***************** Catproc Types **************** Serial Phase #:7 [STD11G4] Files:2 Time: 25s Restart Phase #:8 [STD11G4] Files:1 Time: 0s **************** Catproc Tables **************** Parallel Phase #:9 [STD11G4] Files:69 Time: 59s Restart Phase #:10 [STD11G4] Files:1 Time: 1s ************* Catproc Package Specs ************ Serial Phase #:11 [STD11G4] Files:1 Time: 97s Restart Phase #:12 [STD11G4] Files:1 Time: 0s ************** Catproc Procedures ************** Parallel Phase #:13 [STD11G4] Files:97 Time: 16s Restart Phase #:14 [STD11G4] Files:1 Time: 0s Parallel Phase #:15 [STD11G4] Files:118 Time: 25s Restart Phase #:16 [STD11G4] Files:1 Time: 1s Serial Phase #:17 [STD11G4] Files:13 Time: 5s Restart Phase #:18 [STD11G4] Files:1 Time: 0s ***************** Catproc Views **************** Parallel Phase #:19 [STD11G4] Files:33 Time: 41s Restart Phase #:20 [STD11G4] Files:1 Time: 0s Serial Phase #:21 [STD11G4] Files:3 Time: 15s Restart Phase #:22 [STD11G4] Files:1 Time: 0s Parallel Phase #:23 [STD11G4] Files:24 Time: 106s Restart Phase #:24 [STD11G4] Files:1 Time: 0s Parallel Phase #:25 [STD11G4] Files:11 Time: 63s Restart Phase #:26 [STD11G4] Files:1 Time: 0s Serial Phase #:27 [STD11G4] Files:1 Time: 0s Serial Phase #:28 [STD11G4] Files:3 Time: 6s Serial Phase #:29 [STD11G4] Files:1 Time: 0s Restart Phase #:30 [STD11G4] Files:1 Time: 0s *************** Catproc CDB Views ************** Serial Phase #:31 [STD11G4] Files:1 Time: 0s Restart Phase #:32 [STD11G4] Files:1 Time: 1s Serial Phase #:34 [STD11G4] Files:1 Time: 0s ***************** Catproc PLBs ***************** Serial Phase #:35 [STD11G4] Files:283 Time: 35s Serial Phase #:36 [STD11G4] Files:1 Time: 0s Restart Phase #:37 [STD11G4] Files:1 Time: 0s Serial Phase #:38 [STD11G4] Files:1 Time: 7s Restart Phase #:39 [STD11G4] Files:1 Time: 0s *************** Catproc DataPump *************** Serial Phase #:40 [STD11G4] Files:3 Time: 70s Restart Phase #:41 [STD11G4] Files:1 Time: 0s ****************** Catproc SQL ***************** Parallel Phase #:42 [STD11G4] Files:13 Time: 63s Restart Phase #:43 [STD11G4] Files:1 Time: 1s Parallel Phase #:44 [STD11G4] Files:12 Time: 14s Restart Phase #:45 [STD11G4] Files:1 Time: 0s Parallel Phase #:46 [STD11G4] Files:2 Time: 1s Restart Phase #:47 [STD11G4] Files:1 Time: 0s ************* Final Catproc scripts ************ Serial Phase #:48 [STD11G4] Files:1 Time: 13s Restart Phase #:49 [STD11G4] Files:1 Time: 0s ************** Final RDBMS scripts ************* Serial Phase #:50 [STD11G4] Files:1 Time: 39s ************ Upgrade Component Start *********** Serial Phase #:51 [STD11G4] Files:1 Time: 0s Restart Phase #:52 [STD11G4] Files:1 Time: 1s **************** Upgrading Java **************** Serial Phase #:53 [STD11G4] Files:1 Time: 0s Restart Phase #:54 [STD11G4] Files:1 Time: 0s ***************** Upgrading XDK **************** Serial Phase #:55 [STD11G4] Files:1 Time: 0s Restart Phase #:56 [STD11G4] Files:1 Time: 0s ********* Upgrading APS,OLS,DV,CONTEXT ********* Serial Phase #:57 [STD11G4] Files:1 Time: 77s ***************** Upgrading XDB **************** Restart Phase #:58 [STD11G4] Files:1 Time: 0s Serial Phase #:60 [STD11G4] Files:3 Time: 21s Serial Phase #:61 [STD11G4] Files:3 Time: 9s Parallel Phase #:62 [STD11G4] Files:9 Time: 4s Parallel Phase #:63 [STD11G4] Files:24 Time: 4s Serial Phase #:64 [STD11G4] Files:4 Time: 13s Serial Phase #:65 [STD11G4] Files:1 Time: 0s Serial Phase #:66 [STD11G4] Files:30 Time: 5s Serial Phase #:67 [STD11G4] Files:1 Time: 0s Parallel Phase #:68 [STD11G4] Files:6 Time: 3s Serial Phase #:69 [STD11G4] Files:2 Time: 22s Serial Phase #:70 [STD11G4] Files:3 Time: 68s Restart Phase #:71 [STD11G4] Files:1 Time: 0s ********* Upgrading CATJAVA,OWM,MGW,RAC ******** Serial Phase #:72 [STD11G4] Files:1 Time: 80s **************** Upgrading ORDIM *************** Restart Phase #:73 [STD11G4] Files:1 Time: 0s Serial Phase #:75 [STD11G4] Files:1 Time: 0s Parallel Phase #:76 [STD11G4] Files:2 Time: 0s Serial Phase #:77 [STD11G4] Files:1 Time: 1s Restart Phase #:78 [STD11G4] Files:1 Time: 0s Parallel Phase #:79 [STD11G4] Files:2 Time: 0s Serial Phase #:80 [STD11G4] Files:2 Time: 0s ***************** Upgrading SDO **************** Restart Phase #:81 [STD11G4] Files:1 Time: 1s Serial Phase #:83 [STD11G4] Files:1 Time: 0s Serial Phase #:84 [STD11G4] Files:1 Time: 0s Restart Phase #:85 [STD11G4] Files:1 Time: 0s Serial Phase #:86 [STD11G4] Files:1 Time: 1s Restart Phase #:87 [STD11G4] Files:1 Time: 0s Parallel Phase #:88 [STD11G4] Files:3 Time: 0s Restart Phase #:89 [STD11G4] Files:1 Time: 0s Serial Phase #:90 [STD11G4] Files:1 Time: 0s Restart Phase #:91 [STD11G4] Files:1 Time: 1s Serial Phase #:92 [STD11G4] Files:1 Time: 0s Restart Phase #:93 [STD11G4] Files:1 Time: 0s Parallel Phase #:94 [STD11G4] Files:4 Time: 0s Restart Phase #:95 [STD11G4] Files:1 Time: 0s Serial Phase #:96 [STD11G4] Files:1 Time: 1s Restart Phase #:97 [STD11G4] Files:1 Time: 0s Serial Phase #:98 [STD11G4] Files:2 Time: 0s Restart Phase #:99 [STD11G4] Files:1 Time: 0s Serial Phase #:100 [STD11G4] Files:1 Time: 1s Restart Phase #:101 [STD11G4] Files:1 Time: 0s *********** Upgrading Misc. ODM, OLAP ********** Serial Phase #:102 [STD11G4] Files:1 Time: 0s **************** Upgrading APEX **************** Restart Phase #:103 [STD11G4] Files:1 Time: 0s Serial Phase #:104 [STD11G4] Files:1 Time: 0s Restart Phase #:105 [STD11G4] Files:1 Time: 1s *********** Final Component scripts *********** Serial Phase #:106 [STD11G4] Files:1 Time: 0s ************* Final Upgrade scripts ************ Serial Phase #:107 [STD11G4] Files:1 Time: 81s ********** End PDB Application Upgrade ********* Serial Phase #:108 [STD11G4] Files:1 Time: 0s ******************* Migration ****************** Serial Phase #:109 [STD11G4] Files:1 Time: 46s Serial Phase #:110 [STD11G4] Files:1 Time: 0s Serial Phase #:111 [STD11G4] Files:1 Time: 48s ***************** Post Upgrade ***************** Serial Phase #:112 [STD11G4] Files:1 Time: 252s **************** Summary report **************** Serial Phase #:113 [STD11G4] Files:1 Time: 0s Serial Phase #:114 [STD11G4] Files:1 Time: 0s Serial Phase #:115 [STD11G4] Files:1 Time: 29s ------------------------------------------------------ Phases [0-115] End Time:[2017_06_13 15:40:23] ------------------------------------------------------ Grand Total Time: 1899s LOG FILES: (/opt/app/oracle/product/12.2.0/sehome_1/cfgtoollogs/STD11G4/upgrade20170613150846/catupgrd*.log) Upgrade Summary Report Located in: /opt/app/oracle/product/12.2.0/sehome_1/cfgtoollogs/STD11G4/upgrade20170613150846/upg_summary.log Grand Total Upgrade Time: [0d:0h:31m:39s]
6. View the upgrade summary. This shows that time-zone file need upgrading to latest version.
$ cat /opt/app/oracle/product/12.2.0/sehome_1/cfgtoollogs/STD11G4/upgrade20170613150846/upg_summary.log Oracle Database 12.2 Post-Upgrade Status Tool 06-13-2017 15:39:54 Component Current Version Elapsed Time Name Status Number HH:MM:SS Oracle Server UPGRADED 12.2.0.1.0 00:18:41 Oracle Workspace Manager UPGRADED 12.2.0.1.0 00:01:19 OLAP Analytic Workspace OPTION OFF 11.2.0.2.0 00:00:00 Oracle OLAP API OPTION OFF 11.2.0.2.0 00:00:00 Oracle Text UPGRADED 12.2.0.1.0 00:01:15 Oracle XML Database UPGRADED 12.2.0.1.0 00:02:28 Final Actions 00:02:06 Post Upgrade 00:04:11 Total Upgrade Time: 00:30:13 Database time zone version is 14. It is older than current release time zone version 26. Time zone upgrade is needed using the DBMS_DST package. Grand Total Upgrade Time: [0d:0h:31m:39s]7. Before the timezone upgrade run the utlrp to compile packages.
$ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -e -b utlrp -d '''.''' utlrp.sql catcon: ALL catcon-related output will be written to [/opt/app/oracle/product/12.2.0/sehome_1/rdbms/admin/utlrp_catcon_24388.lst] catcon: See [/opt/app/oracle/product/12.2.0/sehome_1/rdbms/admin/utlrp*.log] files for output generated by scripts catcon: See [/opt/app/oracle/product/12.2.0/sehome_1/rdbms/admin/utlrp_*.lst] files for spool files, if any catcon.pl: completed successfully8. Check the timezone upgrade state on the database. Initially the upgrade state will be 0 and secondary timezone will be 0. Refer here for further information on timezone upgrade.
SQL> SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value FROM DATABASE_PROPERTIES WHERE PROPERTY_NAME LIKE 'DST_%' ORDER BY PROPERTY_NAME; PROPERTY_NAME VALUE ------------------------- ---------- DST_PRIMARY_TT_VERSION 14 DST_SECONDARY_TT_VERSION 0 DST_UPGRADE_STATE NONE9. Start the database in upgrade mode and being the timezone upgrade.
SQL> shutdown immediate; SQL> startup upgrade; exec DBMS_DST.BEGIN_UPGRADE(26); SQL> SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value FROM DATABASE_PROPERTIES WHERE PROPERTY_NAME LIKE 'DST_%' ORDER BY PROPERTY_NAME; PROPERTY_NAME VALUE ------------------------- ---------- DST_PRIMARY_TT_VERSION 26 DST_SECONDARY_TT_VERSION 14 DST_UPGRADE_STATE UPGRADE10. Restar the database in normal mode and complete the timezone upgrade.
shutdown immedaite; startup; truncate table sys.dst$error_table; truncate table sys.dst$trigger_table; VAR numfail number BEGIN DBMS_DST.UPGRADE_DATABASE(:numfail, parallel => TRUE, log_errors => TRUE, log_errors_table => 'SYS.DST$ERROR_TABLE', log_triggers_table => 'SYS.DST$TRIGGER_TABLE', error_on_overlap_time => TRUE, error_on_nonexisting_time => TRUE); DBMS_OUTPUT.PUT_LINE('Failures:'|| :numfail); END; / exec DBMS_DST.END_UPGRADE(:numfail);11. Verify timezone has been upgraded to 26.
SQL> select * from v$timezone_file; FILENAME VERSION CON_ID -------------------- ---------- ---------- timezlrg_26.dat 26 0 SQL> SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value FROM DATABASE_PROPERTIES WHERE PROPERTY_NAME LIKE 'DST_%' ORDER BY PROPERTY_NAME; PROPERTY_NAME VALUE ------------------------- ---------- DST_PRIMARY_TT_VERSION 26 DST_SECONDARY_TT_VERSION 0 DST_UPGRADE_STATE NONE SQL> @?/rdbms/admin/utlu122s.sql Oracle Database 12.2 Post-Upgrade Status Tool 06-13-2017 15:50:24 Component Current Version Elapsed Time Name Status Number HH:MM:SS Oracle Server VALID 12.2.0.1.0 00:18:41 Oracle Workspace Manager VALID 12.2.0.1.0 00:01:19 OLAP Analytic Workspace OPTION OFF 11.2.0.2.0 00:00:00 Oracle OLAP API OPTION OFF 11.2.0.2.0 00:00:00 Oracle Text VALID 12.2.0.1.0 00:01:15 Oracle XML Database VALID 12.2.0.1.0 00:02:28 Final Actions 00:02:06 Post Upgrade 00:04:11 Post Compile 00:01:52 Total Upgrade Time: 00:32:05 Database time zone version is 26. It meets current release needs. Summary Report File = /opt/app/oracle/product/12.2.0/sehome_1/cfgtoollogs/STD11G4/upgrade20170613150846/upg_summary.log12. As part of the upgrade statspack was upgraded to 12.2 (refer 394937.1).
SQL> @?/rdbms/admin/spup112 Statspack Upgrade script ~~~~~~~~~~~~~~~~~~~~~~~~ Warning ~~~~~~~ Converting existing Statspack data to 12.1 format may result in irregularities when reporting on pre-12.1 snapshot data. This script is provided for convenience, and is not guaranteed to work on all installations. To ensure you will not lose any existing Statspack data, export the schema before upgrading. A downgrade script is not provided. Please see spdoc.txt for more details. Press return before continuing Usage ~~~~~ -> Disable any programs which run Statspack (including any dbms_jobs), before continuing, or this upgrade will fail. -> You MUST be connected as a user with SYSDBA privilege to successfully run this script. -> You will be prompted for the PERFSTAT password, and for the tablespace to create any new PERFSTAT tables/indexes. Press return before continuing Please specify the PERFSTAT password Enter value for perfstat_password: test test Note: Please check remainder of upgrade log file, which is continued in the file spup112b.lis Grant succeeded. Connected. USER is "PERFSTAT" insert into STATS$IDLE_EVENT (event) values ('GCR sleep') * ERROR at line 1: ORA-00001: unique constraint (PERFSTAT.STATS$IDLE_EVENT_PK) violated insert into STATS$IDLE_EVENT (event) values ('LogMiner builder: branch') * ERROR at line 1: ORA-00001: unique constraint (PERFSTAT.STATS$IDLE_EVENT_PK) violated insert into STATS$IDLE_EVENT (event) values ('LogMiner builder: idle') * ERROR at line 1: ORA-00001: unique constraint (PERFSTAT.STATS$IDLE_EVENT_PK) violated insert into STATS$IDLE_EVENT (event) values ('LogMiner client: transaction') * ERROR at line 1: ORA-00001: unique constraint (PERFSTAT.STATS$IDLE_EVENT_PK) violated insert into STATS$IDLE_EVENT (event) values ('LogMiner preparer: idle') * ERROR at line 1: ORA-00001: unique constraint (PERFSTAT.STATS$IDLE_EVENT_PK) violated insert into STATS$IDLE_EVENT (event) values ('parallel recovery control message reply') * ERROR at line 1: ORA-00001: unique constraint (PERFSTAT.STATS$IDLE_EVENT_PK) violated 1 row created. ... 1 row created. Commit complete. Table altered. Commit complete. Table created. Synonym created. Commit complete. Note: Please check the log file of the package recreation, which is in the file spcpkg.lis Creating Package STATSPACK... Package created. No errors. Creating Package Body STATSPACK... Warning: Package Body created with compilation errors. Errors for PACKAGE BODY STATSPACK: LINE/COL ERROR -------- ----------------------------------------------------------------- 3219/8 PL/SQL: SQL Statement ignored 3223/15 PL/SQL: ORA-00904: "REMASTER_TYPE": invalid identifier NOTE: SPCPKG complete. Please check spcpkg.lis for any errors. SQL> SQL> -- End of Upgrade script conn / as sysdba SQL> @?/rdbms/admin/spup12200.sql13. Finally update the compatibility parameter to 12.2
SQL> alter system set compatible='12.2.0.1.0' scope=spfile;14. This concludes the upgrade to 12.2.
SQL> select * from dba_registry_history order by 1; ACTION_TIME ACTION NAMESPACE VERSION ID COMMENTS ------------------------------ --------------- ------------------------------ ------------------------------ ---------- ---------------------------------------- 05-SEP-10 06.22.14.370943 AM APPLY SERVER 11.2.0.2 0 Patchset 11.2.0.2.0 28-JAN-11 02.04.20.929972 PM APPLY SERVER 11.2.0.2 1 PSU 11.2.0.2.1 28-JAN-11 02.08.47.891548 PM APPLY SERVER 11.2.0.2 1 PSU 11.2.0.2.1 24-MAY-11 01.32.49.622817 PM APPLY SERVER 11.2.0.2 2 PSU 11.2.0.2.2 20-JUL-11 11.46.58.623557 AM APPLY SERVER 11.2.0.2 3 PSU 11.2.0.2.3 19-OCT-11 11.56.37.705897 AM APPLY SERVER 11.2.0.2 4 PSU 11.2.0.2.4 18-JAN-12 03.25.41.512830 PM APPLY SERVER 11.2.0.2 5 PSU 11.2.0.2.5 13-FEB-12 03.27.42.343779 PM VIEW INVALIDATE 8289601 view invalidation 13-FEB-12 03.27.42.835430 PM UPGRADE SERVER 11.2.0.3.0 Upgraded from 11.2.0.2.0 13-FEB-12 03.28.03.564686 PM APPLY SERVER 11.2.0.3 0 Patchset 11.2.0.2.0 30-APR-12 12.23.17.690100 PM APPLY SERVER 11.2.0.3 2 PSU 11.2.0.3.2 18-JUL-12 10.48.29.139682 AM APPLY SERVER 11.2.0.3 3 PSU 11.2.0.3.3 06-NOV-12 02.33.09.598897 PM APPLY SERVER 11.2.0.3 4 PSU 11.2.0.3.4 21-JAN-13 10.59.24.458354 AM APPLY SERVER 11.2.0.3 5 PSU 11.2.0.3.5 19-APR-13 04.27.41.823099 PM APPLY SERVER 11.2.0.3 6 PSU 11.2.0.3.6 29-JUL-13 02.28.13.060031 PM APPLY SERVER 11.2.0.3 7 PSU 11.2.0.3.7 22-OCT-13 05.17.58.670146 PM APPLY SERVER 11.2.0.3 8 PSU 11.2.0.3.8 21-JAN-14 10.40.22.294040 AM APPLY SERVER 11.2.0.3 9 PSU 11.2.0.3.9 30-APR-14 03.58.10.311583 PM APPLY SERVER 11.2.0.3 10 PSU 11.2.0.3.10 16-JUL-14 01.25.56.344898 PM APPLY SERVER 11.2.0.3 11 PSU 11.2.0.3.11 11-NOV-14 02.59.11.471061 PM APPLY SERVER 11.2.0.3 12 PSU 11.2.0.3.12 21-JAN-15 11.47.41.906220 AM jvmpsu.sql SERVER 11.2.0.3.2OJVMBP 0 RAN jvmpsu.sql 21-JAN-15 11.47.41.926803 AM APPLY SERVER 11.2.0.3.2OJVMBP 0 OJVM PSU post-install 21-JAN-15 11.50.26.504554 AM APPLY SERVER 11.2.0.3 13 PSU 11.2.0.3.13 18-DEC-15 02.29.09.949010 PM VIEW INVALIDATE 8289601 view invalidation 18-DEC-15 02.29.09.994073 PM UPGRADE SERVER 11.2.0.4.0 Upgraded from 11.2.0.3.0 18-DEC-15 02.29.31.582833 PM APPLY SERVER 11.2.0.4 0 Patchset 11.2.0.2.0 18-DEC-15 02.47.17.164443 PM APPLY SERVER 11.2.0.4 8 PSU 11.2.0.4.8 20-APR-16 01.39.00.784851 PM APPLY SERVER 11.2.0.4 160419 PSU 11.2.0.4.160419 13-JUN-17 03.33.00.073857 PM VIEW INVALIDATE 8289601 view invalidation 13-JUN-17 03.34.54.163714 PM UPGRADE SERVER 12.2.0.1.0 Upgraded from 11.2.0.4.0 BOOTSTRAP DATAPATCH 12.2.0.1 RDBMS_12.2.0.1.0_LINUX.X64_170125 SQL> select comp_id,status,version from dba_registry order by 2,3; COMP_ID STATUS VERSION ------------------------------ -------------------------------------------- ----------- APS OPTION OFF 11.2.0.2.0 XOQ OPTION OFF 11.2.0.2.0 XML REMOVED 11.2.0.3.0 JAVAVM REMOVED 11.2.0.3.0 CATJAVA REMOVED 11.2.0.3.0 CATPROC VALID 12.2.0.1.0 CATALOG VALID 12.2.0.1.0 OWM VALID 12.2.0.1.0 CONTEXT VALID 12.2.0.1.0 XDB VALID 12.2.0.1.0Related Posts
Upgrading to 12.1.0.2 Using 11.2.0.4 Backups
Upgrading to 12.2.0.1 Using 12.1.0.2 Backups