Site icon EasyOraDBA

Restore and Upgrade Oracle Database from 11gR2 to 12c from Exadata X4-2 to X7-2

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>

 

Exit mobile version