Upgrade from Exadata X4-2 11g (11.2.0.4) to Exadata X7-2 12CR1 (12.1.0.2.0) : ASM to ASM
Oracle Database 11.2.0.3and 11.2.0.4 to Oracle 12.2.0.1 Direct upgrade is supported by Oracle. If you have Database lower than those version than you have to upgrade to 11.2.0.4 first and you can upgrade to 12cR2
In our Scenario We will Migrate and Upgrade from One Exadata machine (X4-2) to another Exadata machine (X7-2) from 11.2.0.4 to 12.1.0.2.0
Source Exadata Setup ---------------------- RAC 2-Nodes Hardware : X4-2 Image version: 12.1.2.3.5.170418 DB NAME : mob DATABASE HOME VERSION: 11.2.0.4 GRID HOME VERSION : 12.1.0.2.0 ASM Diskgroups : +DATAC1, +RECOC1 Target Exadata Setup ----------------- RAC 2-Nodes Hardware : X7-2 Image version: 18.1.4.0.0.180125.3 DB NAME: SWX DATABASE HOME VERSION : 12.1.0.2.0 GRID HOME VERSION : 12.2.0.1.0 ASM Diskgroups : +DATAC1, +RECOC1
Presumptions
————
* Oracle Home (12.1.0.2.0) is installed on the Target Server with latest patches
* Both Exadata Servers are reachable from the Network to Copy the backup files
1. Take RMAN Backup of Source Database on X4-2 hardware
rman target / nocatalog
run
{
allocate channel swx1 DEVICE TYPE DISK ;
allocate channel swx2 DEVICE TYPE DISK ;
allocate channel swx3 DEVICE TYPE DISK ;
allocate channel swx4 DEVICE TYPE DISK ;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/exabackups/rmanbkp/swx/autobackup_control_file_%F';
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
BACKUP DATABASE FORMAT '/exabackups/rmanbkp/swx/SWX_FULL_%s_%D_%M_%Y' tag 'SWX_DAILY_FULL_DB_BKP';
BACKUP ARCHIVELOG ALL FORMAT '/exabackups/rmanbkp/swx/ARCH_%d_ALL_%s_%t' tag 'SWX_ARCH_LOG_BKP';
}
SQL> create pfile=’/exabackups/rmanbkp/swx/swx_source.ora’ from spfile ;
2. Copy Backup from Source Server to Target Server
cd /exabackups/rmanbkp/swx
scp -r * oracle@qiibtstdbadm01.qiibonline.com:/u03/swx_today
3. Edit the Source pfile : swx_source.ora and change below parameters
Old pfile --------- swx1.__db_cache_size=9395240960 swx2.__db_cache_size=9395240960 swx1.__java_pool_size=33554432 swx2.__java_pool_size=33554432 swx1.__large_pool_size=67108864 swx2.__large_pool_size=67108864 swx2.__oracle_base='/u02/app/oracle'#ORACLE_BASE set from environment swx1.__oracle_base='/u02/app/oracle'#ORACLE_BASE set from environment swx1.__pga_aggregate_target=6006243328 swx2.__pga_aggregate_target=6006243328 swx1.__sga_target=11173625856 swx2.__sga_target=11173625856 swx1.__shared_io_pool_size=0 swx2.__shared_io_pool_size=0 swx1.__shared_pool_size=1577058304 swx2.__shared_pool_size=1577058304 swx1.__streams_pool_size=0 swx2.__streams_pool_size=0 *._client_enable_auto_unregister=TRUE *.archive_lag_target=0 *.audit_file_dest='/u02/app/oracle/admin/swx/adump' ####### Change to Target Directory and Create teh Directory on OS ########### *.audit_trail='db' *.cluster_database=TRUE ######## Set to FALSE ############ *.compatible='11.2.0.4.0' ######## Change to 12.1.0.2.0 ########## *.control_files='+datac1/swx/controlfile/current.346.853755085','+RECOC1/swx/controlfile/current.4208.853579009' ########## Hash this ######### *.cpu_count=2 *.db_block_size=8192 *.db_create_file_dest='+DATAC1' *.db_create_online_log_dest_1='+RECOC1' *.db_domain='' *.db_name='swx' *.db_recovery_file_dest='+RECOC1' *.db_recovery_file_dest_size=858993459200 *.diagnostic_dest='/u02/app/oracle' ########## Change to new target Oracle Base directory ############ *.dispatchers='(PROTOCOL=TCP) (SERVICE=swxXDB)' swx2.instance_number=2 swx1.instance_number=1 *.java_jit_enabled=TRUE *.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=SWX' *.log_archive_format='%t_%s_%r.arc' swx1.log_archive_format='%t_%s_%r.arc' swx2.log_archive_format='%t_%s_%r.arc' *.log_archive_max_processes=8 *.log_archive_min_succeed_dest=1 swx1.log_archive_trace=0 swx2.log_archive_trace=0 *.sga_max_size=17179869184 *.sga_target=17179869184 *.open_cursors=300 *.processes=1500 *.remote_listener='exaprod-scan:1521' ########## Change to SCAN listener of Target DB ######### *.remote_login_passwordfile='exclusive' *.resource_manager_cpu_allocation=48 *.resource_manager_plan='DEFAULT_PLAN' *.sessions=1655 *.standby_file_management='AUTO' swx2.thread=2 swx1.thread=1 swx1.undo_tablespace='UNDOTBS1' swx2.undo_tablespace='UNDOTBS2' *.instance_number=2
Save the parameters and save pfile as swx_target.ora
New pfile : swx_target.ora --------- swx1.__db_cache_size=9395240960 swx2.__db_cache_size=9395240960 swx1.__java_pool_size=33554432 swx2.__java_pool_size=33554432 swx1.__large_pool_size=67108864 swx2.__large_pool_size=67108864 swx2.__oracle_base='/u02/app/oracle'#ORACLE_BASE set from environment swx1.__oracle_base='/u02/app/oracle'#ORACLE_BASE set from environment swx1.__pga_aggregate_target=6006243328 swx2.__pga_aggregate_target=6006243328 swx1.__sga_target=11173625856 swx2.__sga_target=11173625856 swx1.__shared_io_pool_size=0 swx2.__shared_io_pool_size=0 swx1.__shared_pool_size=1577058304 swx2.__shared_pool_size=1577058304 swx1.__streams_pool_size=0 swx2.__streams_pool_size=0 *._client_enable_auto_unregister=TRUE *.archive_lag_target=0 *.audit_file_dest='/u03/app/oracle/admin/swx/adump' ####### Change to Target Directory and Create teh Directory on OS ########### *.audit_trail='db' *.cluster_database=FALSE ######## Set to FALSE ############ *.compatible='12.1.0.2.0' ######## Change to 12.1.0.2.0 ########## #*.control_files='+datac1/swx/controlfile/current.346.853755085','+RECOC1/swx/controlfile/current.4208.853579009' ########## Hash this ######### *.cpu_count=2 *.db_block_size=8192 *.db_create_file_dest='+DATAC1' *.db_create_online_log_dest_1='+RECOC1' *.db_domain='' *.db_name='swx' *.db_recovery_file_dest='+RECOC1' *.db_recovery_file_dest_size=858993459200 *.diagnostic_dest='/u03/app/oracle' ########## Change to new target Oracle Base directory ############ *.dispatchers='(PROTOCOL=TCP) (SERVICE=swxXDB)' swx2.instance_number=2 swx1.instance_number=1 *.java_jit_enabled=TRUE *.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=SWX' *.log_archive_format='%t_%s_%r.arc' swx1.log_archive_format='%t_%s_%r.arc' swx2.log_archive_format='%t_%s_%r.arc' *.log_archive_max_processes=8 *.log_archive_min_succeed_dest=1 swx1.log_archive_trace=0 swx2.log_archive_trace=0 *.sga_max_size=17179869184 *.sga_target=17179869184 *.open_cursors=300 *.processes=1500 *.remote_listener='qiibtst-scan:1521' ########## Change to SCAN listener of Target DB ######### *.remote_login_passwordfile='exclusive' *.resource_manager_cpu_allocation=48 *.resource_manager_plan='DEFAULT_PLAN' *.sessions=1655 *.standby_file_management='AUTO' swx2.thread=2 swx1.thread=1 swx1.undo_tablespace='UNDOTBS1' swx2.undo_tablespace='UNDOTBS2' *.instance_number=2
4. Start the Instance on Target Database using swx_target.ora pfile
Make sure you export ORACLE_HOME and ORACLE_SID environment variables properly before beginning
SQL> startup nomount pfile='/u03/swx_today/swx_source.ora'; rman target / RMAN> restore controlfile from '/u03/swx_today/control_file_SWX_853579011_20180215_4985_1'; Starting restore at 18-MAR-18 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=1140 instance=swx device type=DISK channel ORA_DISK_1: restoring control file channel ORA_DISK_1: restore complete, elapsed time: 00:00:07 output file name=+RECOC1/SWX/CONTROLFILE/current.654.971100501 Finished restore at 18-MAR-18 RMAN> alter database mount; RMAN> catalog start with '/u03/swx_today'; Starting implicit crosscheck backup at 18-MAR-18 allocated channel: ORA_DISK_1 allocated channel: ORA_DISK_2 allocated channel: ORA_DISK_3 allocated channel: ORA_DISK_4 Crosschecked 158 objects Finished implicit crosscheck backup at 18-MAR-18 Starting implicit crosscheck copy at 18-MAR-18 using channel ORA_DISK_1 using channel ORA_DISK_2 using channel ORA_DISK_3 using channel ORA_DISK_4 Crosschecked 4 objects Finished implicit crosscheck copy at 18-MAR-18 searching for all files in the recovery area cataloging files... no files cataloged searching for all files that match the pattern /u03/swx_today List of Files Unknown to the Database ===================================== File Name: /u03/swx_today/ARCH_SWX_ALL_4979_968178229 File Name: /u03/swx_today/control_file_SWX_853579011_20180215_4985_1 File Name: /u03/swx_today/SWX_FULL_4975_15_02_2018 File Name: /u03/swx_today/ARCH_SWX_ALL_4981_968178230 File Name: /u03/swx_today/ARCH_SWX_ALL_4978_968178229 File Name: /u03/swx_today/ARCH_SWX_ALL_4982_968178255 File Name: /u03/swx_today/autobackup_control_file_c-133836929-20180215-02 File Name: /u03/swx_today/autobackup_control_file_c-133836929-20180215-00 File Name: /u03/swx_today/SWX_FULL_4974_15_02_2018 File Name: /u03/swx_today/autobackup_control_file_c-133836929-20180215-01 File Name: /u03/swx_today/swx_source.ora File Name: /u03/swx_today/SWX_FULL_4976_15_02_2018 File Name: /u03/swx_today/ARCH_SWX_ALL_4980_968178230 File Name: /u03/swx_today/ARCH_SWX_ALL_4983_968178258 Do you really want to catalog the above files (enter YES or NO)? YES cataloging files... cataloging done List of Cataloged Files ======================= File Name: /u03/swx_today/ARCH_SWX_ALL_4979_968178229 File Name: /u03/swx_today/control_file_SWX_853579011_20180215_4985_1 File Name: /u03/swx_today/SWX_FULL_4975_15_02_2018 File Name: /u03/swx_today/ARCH_SWX_ALL_4981_968178230 File Name: /u03/swx_today/ARCH_SWX_ALL_4978_968178229 File Name: /u03/swx_today/ARCH_SWX_ALL_4982_968178255 File Name: /u03/swx_today/autobackup_control_file_c-133836929-20180215-02 File Name: /u03/swx_today/autobackup_control_file_c-133836929-20180215-00 File Name: /u03/swx_today/SWX_FULL_4974_15_02_2018 File Name: /u03/swx_today/autobackup_control_file_c-133836929-20180215-01 File Name: /u03/swx_today/SWX_FULL_4976_15_02_2018 File Name: /u03/swx_today/ARCH_SWX_ALL_4980_968178230 File Name: /u03/swx_today/ARCH_SWX_ALL_4983_968178258 List of Files Which Were Not Cataloged ======================================= File Name: /u03/swx_today/swx_source.ora RMAN-07517: Reason: The file header is corrupted RMAN> restore database; Starting restore at 18-MAR-18 using channel ORA_DISK_1 using channel ORA_DISK_2 using channel ORA_DISK_3 using channel ORA_DISK_4 allocated channel: ORA_SBT_TAPE_1 channel ORA_SBT_TAPE_1: SID=26 instance=swx device type=SBT_TAPE channel ORA_SBT_TAPE_1: Data Protection for Oracle: version 7.1.0.0 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 00003 to +DATAC1/swx/datafile/undotbs1.281.853578943 channel ORA_DISK_1: restoring datafile 00004 to +RECOC1/swx/datafile/audit_tbs.2213.871200459 channel ORA_DISK_1: reading from backup piece /u03/swx_today/SWX_FULL_4975_15_02_2018 channel ORA_DISK_2: starting datafile backup set restore channel ORA_DISK_2: specifying datafile(s) to restore from backup set channel ORA_DISK_2: restoring datafile 00001 to +DATAC1/swx/datafile/system.285.853578943 channel ORA_DISK_2: restoring datafile 00002 to +DATAC1/swx/datafile/sysaux.278.853578943 channel ORA_DISK_2: reading from backup piece /u03/swx_today/SWX_FULL_4976_15_02_2018 channel ORA_DISK_3: starting datafile backup set restore channel ORA_DISK_3: specifying datafile(s) to restore from backup set channel ORA_DISK_3: restoring datafile 00005 to +DATAC1/swx/datafile/undotbs2.351.853579027 channel ORA_DISK_3: restoring datafile 00006 to +DATAC1/swx/datafile/swx.345.853583217 channel ORA_DISK_3: reading from backup piece /u03/swx_today/SWX_FULL_4974_15_02_2018 channel ORA_DISK_1: piece handle=/u03/swx_today/SWX_FULL_4975_15_02_2018 tag=SWX_DAILY_FULL_DB_BKP channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:15 channel ORA_DISK_2: piece handle=/u03/swx_today/SWX_FULL_4976_15_02_2018 tag=SWX_DAILY_FULL_DB_BKP channel ORA_DISK_2: restored backup piece 1 channel ORA_DISK_2: restore complete, elapsed time: 00:00:15 channel ORA_DISK_3: piece handle=/u03/swx_today/SWX_FULL_4974_15_02_2018 tag=SWX_DAILY_FULL_DB_BKP channel ORA_DISK_3: restored backup piece 1 channel ORA_DISK_3: restore complete, elapsed time: 00:04:45 Finished restore at 18-MAR-18 RMAN> recover database; Starting recover at 18-MAR-18 using channel ORA_DISK_1 using channel ORA_DISK_2 using channel ORA_DISK_3 using channel ORA_DISK_4 using channel ORA_SBT_TAPE_1 starting media recovery channel ORA_DISK_1: starting archived log restore to default destination channel ORA_DISK_1: restoring archived log archived log thread=2 sequence=48891 channel ORA_DISK_1: restoring archived log archived log thread=1 sequence=43454 channel ORA_DISK_1: restoring archived log archived log thread=2 sequence=48892 channel ORA_DISK_1: restoring archived log archived log thread=1 sequence=43455 channel ORA_DISK_1: reading from backup piece /u03/swx_today/ARCH_SWX_ALL_4983_968178258 channel ORA_DISK_1: piece handle=/u03/swx_today/ARCH_SWX_ALL_4983_968178258 tag=SWX_ARCH_LOG_BKP channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 archived log file name=+RECOC1/SWX/ARCHIVELOG/2018_03_18/thread_1_seq_43454.645.971100923 thread=1 sequence=43454 archived log file name=+RECOC1/SWX/ARCHIVELOG/2018_03_18/thread_2_seq_48891.642.971100923 thread=2 sequence=48891 channel default: deleting archived log(s) archived log file name=+RECOC1/SWX/ARCHIVELOG/2018_03_18/thread_2_seq_48891.642.971100923 RECID=238985 STAMP=971100923 archived log file name=+RECOC1/SWX/ARCHIVELOG/2018_03_18/thread_2_seq_48892.639.971100923 thread=2 sequence=48892 channel default: deleting archived log(s) archived log file name=+RECOC1/SWX/ARCHIVELOG/2018_03_18/thread_1_seq_43454.645.971100923 RECID=238987 STAMP=971100923 archived log file name=+RECOC1/SWX/ARCHIVELOG/2018_03_18/thread_1_seq_43455.648.971100923 thread=1 sequence=43455 channel default: deleting archived log(s) archived log file name=+RECOC1/SWX/ARCHIVELOG/2018_03_18/thread_1_seq_43455.648.971100923 RECID=238988 STAMP=971100923 unable to find archived log archived log thread=1 sequence=43456 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 03/18/2018 14:15:25 RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 43456 and starting SCN of 21582106266 RMAN> alter database open resetlogs; RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00601: fatal error in recovery manager RMAN-03004: fatal error during execution of command ORA-03114: not connected to ORACLE RMAN-03002: failure of sql statement command at 03/18/2018 14:15:42 ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00704: bootstrap process failure ORA-00604: error occurred at recursive SQL level 2 ORA-00904: "I"."UNUSABLEBEGINNING#": invalid identifier Process ID: 136136 Session ID: 1137 Serial number: 14577 sqlplus "/as sysdba"
Change control file information with new location after restore in pfile and start database again +RECOC1/SWX/CONTROLFILE/current.654.971100501
Also change CLUSTER_DATABASE to false in pfile
If you get any error like below error then copy the file to the dbs folder as init.ora
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file ‘/u03/app/oracle/product/12.1.0.2/dbhome_1/dbs/initswx.ora’
$ cp -p /u03/swx_today/swx_source.ora /u03/app/oracle/product/12.1.0.2/dbhome_1/dbs/initswx.ora
sqlplus "/as sysdba"
SQL> startup upgrade;
$ cd $ORACLE_HOME/rdbms/admin
$ORACLE_HOME/perl/bin/perl catctl.pl -n 4 catupgrd.sql
Argument list for [catctl.pl]
SQL Process Count n = 4
SQL PDB Process Count N = 0
Input Directory d = 0
Phase Logging Table t = 0
Log Dir l = 0
Script s = 0
Serial Run S = 0
Upgrade Mode active M = 0
Start Phase p = 0
End Phase P = 0
Log Id i = 0
Run in c = 0
Do not run in C = 0
Echo OFF e = 1
No Post Upgrade x = 0
Reverse Order r = 0
Open Mode Normal o = 0
Debug catcon.pm z = 0
Debug catctl.pl Z = 0
Display Phases y = 0
Child Process I = 0
catctl.pl version: 12.1.0.2.0
Oracle Base = /u03/app/oracle
Analyzing file catupgrd.sql
Log files in /u03/app/oracle/product/12.1.0.2/dbhome_1/rdbms/admin
catcon: ALL catcon-related output will be written to catupgrd_catcon_227787.lst
catcon: See catupgrd*.log files for output generated by scripts
catcon: See catupgrd_*.lst files for spool files, if any
Number of Cpus = 2
SQL Process Count = 4
------------------------------------------------------
Phases [0-73] Start Time:[2018_03_18 14:39:13]
------------------------------------------------------
Serial Phase #: 0 Files: 1 Time: 105s
Serial Phase #: 1 Files: 5 Time: 22s
Restart Phase #: 2 Files: 1 Time: 0s
Parallel Phase #: 3 Files: 18 Time: 4s
Restart Phase #: 4 Files: 1 Time: 0s
Serial Phase #: 5 Files: 5 Time: 10s
Serial Phase #: 6 Files: 1 Time: 9s
Serial Phase #: 7 Files: 4 Time: 4s
Restart Phase #: 8 Files: 1 Time: 0s
Parallel Phase #: 9 Files: 62 Time: 12s
Restart Phase #:10 Files: 1 Time: 0s
Serial Phase #:11 Files: 1 Time: 8s
Restart Phase #:12 Files: 1 Time: 0s
Parallel Phase #:13 Files: 91 Time: 4s
Restart Phase #:14 Files: 1 Time: 0s
Parallel Phase #:15 Files: 111 Time: 8s
Restart Phase #:16 Files: 1 Time: 0s
Serial Phase #:17 Files: 3 Time: 0s
Restart Phase #:18 Files: 1 Time: 0s
Parallel Phase #:19 Files: 32 Time: 8s
Restart Phase #:20 Files: 1 Time: 0s
Serial Phase #:21 Files: 3 Time: 4s
Restart Phase #:22 Files: 1 Time: 0s
Parallel Phase #:23 Files: 23 Time: 43s
Restart Phase #:24 Files: 1 Time: 0s
Parallel Phase #:25 Files: 11 Time: 17s
Restart Phase #:26 Files: 1 Time: 0s
Serial Phase #:27 Files: 1 Time: 0s
Restart Phase #:28 Files: 1 Time: 0s
Serial Phase #:30 Files: 1 Time: 0s
Serial Phase #:31 Files: 257 Time: 12s
Serial Phase #:32 Files: 1 Time: 0s
Restart Phase #:33 Files: 1 Time: 0s
Serial Phase #:34 Files: 1 Time: 3s
Restart Phase #:35 Files: 1 Time: 0s
Restart Phase #:36 Files: 1 Time: 0s
Serial Phase #:37 Files: 4 Time: 31s
Restart Phase #:38 Files: 1 Time: 0s
Parallel Phase #:39 Files: 13 Time: 27s
Restart Phase #:40 Files: 1 Time: 0s
Parallel Phase #:41 Files: 10 Time: 3s
Restart Phase #:42 Files: 1 Time: 0s
Serial Phase #:43 Files: 1 Time: 4s
Restart Phase #:44 Files: 1 Time: 0s
Serial Phase #:45 Files: 1 Time: 3s
Serial Phase #:46 Files: 1 Time: 1s
Restart Phase #:47 Files: 1 Time: 0s
Serial Phase #:48 Files: 1 Time: 82s
Restart Phase #:49 Files: 1 Time: 0s
Serial Phase #:50 Files: 1 Time: 22s
Restart Phase #:51 Files: 1 Time: 0s
Serial Phase #:52 Files: 1 Time: 16s
Restart Phase #:53 Files: 1 Time: 0s
Serial Phase #:54 Files: 1 Time: 192s
Restart Phase #:55 Files: 1 Time: 0s
Serial Phase #:56 Files: 1 Time: 37s
Restart Phase #:57 Files: 1 Time: 0s
Serial Phase #:58 Files: 1 Time: 69s
Restart Phase #:59 Files: 1 Time: 0s
Serial Phase #:60 Files: 1 Time: 295s
Restart Phase #:61 Files: 1 Time: 0s
Serial Phase #:62 Files: 1 Time: 24s
Restart Phase #:63 Files: 1 Time: 0s
Serial Phase #:64 Files: 1 Time: 0s
Serial Phase #:65 Files: 1 Time: 11s
Serial Phase #:66 Files: 1 Time: 25s
Serial Phase #:67 Files: 1 Time: 1s
Serial Phase #:68 Files: 1 Time: 0s
Serial Phase #:69 Files: 1 Time: 27s
------------------------------------------------------
Phases [0-73] End Time:[2018_03_18 14:58:16]
------------------------------------------------------
Grand Total Time: 1145s
*** 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
and determine the proper action.
2. Execute the post upgrade script as described in Chapter 3
of the Database Upgrade Guide.
REASON:
catuppst.sql unable to run in Database: swx Id: 0
ERRORS FOUND: during upgrade CATCTL ERROR COUNT=5
------------------------------------------------------
Identifier XDB 18-03-18 02:47:25 Script = /u03/app/oracle/product/12.1.0.2/dbhome_
ERROR = [ORA-01917: user or role 'ANONYMOUS' does not exist ORA-06512: at line 7
ORA-06512: at line 15
]
STATEMENT = [declare
already_revoked exception;
pragma exception_init(already_revoked,-01927);
procedure revoke_inherit_privileges(user in varchar2) as
begin
execute immediate 'revoke inherit privileges on user '||
dbms_assert.enquote_name(user)||' from public';
exception
when already_revoked then null;
end;
begin
revoke_inherit_privileges('xdb');
revoke_inherit_privileges('anonymous');
end;]
------------------------------------------------------
------------------------------------------------------
Identifier XDB 18-03-18 02:47:25 Script = /u03/app/oracle/product/12.1.0.2/dbhome_
ERROR = [ORA-06512: at line 7 ORA-06512: at line 15
]
STATEMENT = [as above]
------------------------------------------------------
------------------------------------------------------
Identifier XDB 18-03-18 02:47:25 Script = /u03/app/oracle/product/12.1.0.2/dbhome_
ERROR = [ORA-06512: at line 15]
STATEMENT = [as above]
------------------------------------------------------
------------------------------------------------------
Identifier ORDIM 18-03-18 02:50:44 Script = /u03/app/oracle/product/12.1.0.2/dbhome_
ERROR = [ORA-20000: Oracle XML Database component not valid. Oracle XML Database must be installed and valid prior to Oracle Multimedia install, upgrade, downgrade, or patch.
ORA-06512: at line 3
]
STATEMENT = [begin
IF dbms_registry.is_valid('XDB',dbms_registry.release_version) != 1 THEN
raise_application_error(-20000,
'Oracle XML Database component not valid. '||
'Oracle XML Database must be installed and valid prior to Oracle Multimedia install, upgrade, downgrade, or patch.');
END IF;
end;]
------------------------------------------------------
------------------------------------------------------
Identifier ORDIM 18-03-18 02:50:44 Script = /u03/app/oracle/product/12.1.0.2/dbhome_
ERROR = [installed and valid prior to Oracle Multimedia install, upgrade, downgrade, or patch.
ORA-06512: at line 3
]
STATEMENT = [as above]
------------------------------------------------------
------------------------------------------------------
Identifier ORDIM 18-03-18 02:50:44 Script = /u03/app/oracle/product/12.1.0.2/dbhome_
ERROR = [patch. ORA-06512: at line 3
]
STATEMENT = [as above]
------------------------------------------------------
------------------------------------------------------
Identifier ORDIM 18-03-18 02:50:44 Script = /u03/app/oracle/product/12.1.0.2/dbhome_
ERROR = [ORA-06512: at line 3]
STATEMENT = [as above]
------------------------------------------------------
LOG FILES: (catupgrd*.log)
Upgrade Summary Report Located in:
/u03/app/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/swx/upgrade/upg_summary.log
Grand Total Upgrade Time: [0d:0h:19m:5s]
sqlplus "/as sysdba"
SQL> @utlrp.sql
SQL> select * from dba_registry;
Verify all components are valid
OWB OWB 11.2.0.4.0 VALID 18-MAR-2018 15:02:31 SERVER SYS OWBSYS DBMS_OWB.VALIDATE
EM Oracle Enterprise Manager 11.2.0.4.0 VALID 24-AUG-2013 11:58:27 SERVER SYS SYSMAN
AMD OLAP Catalog 11.2.0.4.0 OPTION OFF 18-MAR-2018 14:46:55 SERVER SYS OLAPSYS CWM2_OLAP_INSTALLER.VALIDATE_CWM2_INSTALL
SDO Spatial 12.1.0.2.0 VALID 18-MAR-2018 15:02:30 SERVER SYS MDSYS VALIDATE_SDO MDDATA,MDSYS,SPATIAL_CSW_ADMIN_USR,SPATIAL_WFS_ADMIN_USR
ORDIM Oracle Multimedia 12.1.0.2.0 VALID 18-MAR-2018 15:02:29 SERVER SYS ORDSYS VALIDATE_ORDIM ORDDATA,ORDPLUGINS,SI_INFORMTN_SCHEMA
XDB Oracle XML Database 12.1.0.2.0 VALID 18-MAR-2018 15:02:28 SERVER SYS XDB DBMS_REGXDB.VALIDATEXDB XS$NULL
CONTEXT Oracle Text 12.1.0.2.0 VALID 18-MAR-2018 15:02:27 SERVER SYS CTXSYS VALIDATE_CONTEXT
OWM Oracle Workspace Manager 12.1.0.2.0 VALID 18-MAR-2018 15:02:25 SERVER SYS WMSYS VALIDATE_OWM
CATALOG Oracle Database Catalog Views 12.1.0.2.0 VALID 18-MAR-2018 15:02:23 SERVER SYS SYS DBMS_REGISTRY_SYS.VALIDATE_CATALOG
CATPROC Oracle Database Packages and Types 12.1.0.2.0 VALID 18-MAR-2018 15:02:23 SERVER SYS SYS DBMS_REGISTRY_SYS.VALIDATE_CATPROC APPQOSSYS,DBSNMP,DIP,GSMADMIN_INTERNAL,ORACLE_OCM,OUTLN,SYSTEM
JAVAVM JServer JAVA Virtual Machine 12.1.0.2.0 VALID 18-MAR-2018 15:02:26 SERVER SYS SYS INITJVMAUX.VALIDATE_JAVAVM
COMP_ID COMP_NAME VERSION STATUS MODIFIED NAMESPACE CONTROL SCHEMA PROCEDURE STARTUP PARENT_ID OTHER_SCHEMAS
------------------------------ --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------ ----------- -------------------- ------------------------------ -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------- -------- ------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
XML Oracle XDK 12.1.0.2.0 VALID 18-MAR-2018 15:02:27 SERVER SYS SYS XMLVALIDATE
CATJAVA Oracle Database Java Packages 12.1.0.2.0 VALID 18-MAR-2018 15:02:27 SERVER SYS SYS DBMS_REGISTRY_SYS.VALIDATE_CATJAVA
APS OLAP Analytic Workspace 12.1.0.2.0 VALID 18-MAR-2018 15:02:29 SERVER SYS SYS APS_VALIDATE
XOQ Oracle OLAP API 12.1.0.2.0 VALID 18-MAR-2018 15:02:30 SERVER SYS SYS XOQ_VALIDATE
RAC Oracle Real Application Clusters 12.1.0.2.0 VALID 18-MAR-2018 15:02:31 SERVER SYS SYS DBMS_CLUSTDB.VALIDATE
16 rows selected.
SQL>
