Through this blog, I would like to show, with a real customer case, how I have been migrating databases in High Availability environment on an ODA. High Availability using Data Guard for Oracle Enterprise Edition or dbvisit for Oracle Standard Edition 2. One of the advantage here would be to use the Standby Database as fallback in case there would be some application issue with new database version. Although, I would expect that for any productive database, customer would have a similar test database on which he would perform a good testing.<\/p>\n
In this procedure I have been upgrading database named DB1 from 11.2.0.4 to 12.1.0.2 version. The primary server is named ODA-PRI (running DB1_RZA database) and the standby server is named ODA-STD (running DB1_RZB database).<\/p>\n
<\/p>\n
To perform an upgrade in High Availability environment, there would be 16 steps :<\/p>\n
Note :<\/em><\/strong><\/p>\n On our customer environment we are using our DMK Management Kit<\/a> which is very easy to use and powerfully to administrate the database. This steps might be similar for the primary and standby ODA. Make sure to use the same version of PSU on both your ODA.<\/p>\n I have been creating a new Oracle Home version 12.1.0.2.<\/p>\n Checking dbhomes, I do not have any 12.1 running on my ODAs : I’m running ODA version 19.7 : I have downloaded Patch p23494992 from My Oracle Support and extracted it locally : I updated the ODA repository with new DB clone : I have then created new needed dbhome (on this customer we are using Standard Edition database with dbvisit software) : Following steps is mandatory if using our DMK Management Kit. We need to create a dummy for the new database home : Just a tips :<\/em><\/strong> if you are using passwordless SSH authentication for the oracle user, you will have to create the keys again as any odacli create or delete command will remove them.<\/p>\n Check new Oracle database home : Before performing next upgrade steps, it is now time to have the customer stopping the application. You might have your own script to check running session, if not you can use below queries : To kill inactive old sessions, you can use below PL\/SQL commands : The High Availability solution will depend if you are running Enterprise Edition or Standard Edition. To make sure the standby is synchronized, use show database command on the standby database : What is mandatory is to have no transport lag and no apply lag : Use dbvctl command with option -i to ensure there is no gap. DB1 would be the name of my DDC configuration file : Mandatory is to have no gap : If there is any gap, same command can be run on the primary to ship the archive log and on the standby to apply them : You will need to stop the synchronization of the databases to isolate the standby from any new change.<\/p>\n In case FSFO is used, you will need to disable it : You will need to set the protection mode to maxperformance : You will need to stop applying the change vector on the standby : You will need to stop shipping the change vector on the primary : Archive log shippment and apply is done through the linux crontab. Purpose is then to deactivate it on both the primary and the standby database using crontab -e command.<\/p>\n On the primary : On the standby : I first checked if the existing database had any invalid object : I executed preupgrd.sql script : I checked preupgrade log : I executed the preupgrade_fixup.sql script : The hidden parameters are ODA specific and can be ignored.<\/p>\n\n
1- Check database backup<\/h3>\n
\nI have then checked dmk_dbbackup logs to ensure I have a good backup.<\/p>\noracle@ODA-PRI:\/home\/oracle\/ [DB1] cda<\/strong>
\n
\noracle@ODA-PRI:\/u01\/app\/oracle\/admin\/DB1\/ [DB1] cd log<\/strong>
\n
\noracle@ODA-PRI:\/u01\/app\/oracle\/admin\/DB1\/log\/ [DB1] ls -ltrh *inc0*<\/strong>
\n-rw-r--r-- 1 oracle oinstall 34K Jun 21 21:05 DB1_bck_inc0_no_arc_del_20200621_200002.log
\n-rw-r--r-- 1 oracle oinstall 33K Jul 1 21:03 DB1_bck_inc0_no_arc_del_20200701_200002.log
\n-rw-r--r-- 1 oracle oinstall 34K Aug 1 21:06 DB1_bck_inc0_no_arc_del_20200801_200002.log
\n-rw-r--r-- 1 oracle oinstall 35K Aug 10 08:43 DB1_bck_inc0_no_arc_del_20200810_075712.log
\n
\noracle@ODA-PRI:\/u01\/app\/oracle\/admin\/DB1\/log\/ [DB1] tail DB1_bck_inc0_no_arc_del_20200810_075712.log<\/strong>
\n
\nRecovery Manager complete.
\n
\nRMAN return Code: 0
\n
\n#**************************************************************************************************#
\n# END OF: DB1_bck_inc0_no_arc_del_20200810_075712.log #
\n#--------------------------------------------------------------------------------------------------#
\n# timestamp: 2020-08-10_08:43:52 #
\n#**************************************************************************************************#
\noracle@ODA-PRI:\/u01\/app\/oracle\/admin\/DB1\/log\/ [DB1]<\/code><\/p>\n2- Create new 12.1.0.2 dbhomes (or use existing one) on the primary and the standby ODA<\/h3>\n
\n[root@ODA-PRI ~]# odacli list-dbhomes<\/strong>
\n
\nID Name DB Version Home Location Status
\n---------------------------------------- -------------------- ---------------------------------------- --------------------------------------------- ----------
\nd6df9457-e4cd-4c39-b3cb-8d03be3c4598 OraDB11204_home1 11.2.0.4.190115 \/u01\/app\/oracle\/product\/11.2.0.4\/dbhome_1 Configured
\n3d92c8ea-2ad5-4565-acd5-1d931cf22b15 OraDB11204_home3 11.2.0.4.190115 \/u01\/app\/oracle\/product\/11.2.0.4\/dbhome_3 Configured
\n9d2d92d0-3b98-42ac-9f39-9bd6deeb2e16 OraDB19000_home1 19.7.0.0.200414 \/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1 Configured<\/code><\/p>\n
\n[root@ODA-PRI ~]# odacli describe-component<\/strong>
\nSystem Version
\n---------------
\n19.7.0.0.0
\n
\nComponent Installed Version Available Version
\n---------------------------------------- -------------------- --------------------
\nOAK 19.7.0.0.0 up-to-date
\nGI 19.7.0.0.200414 up-to-date
\nDB {
\n[ OraDB11204_home1,OraDB11204_home3 ] 11.2.0.4.190115 11.2.0.4.200414
\n[ OraDB19000_home1 ] 19.7.0.0.200414 up-to-date
\n}
\nDCSAGENT 19.7.0.0.0 up-to-date
\nILOM 4.0.4.52.r133103 up-to-date
\nBIOS 41060700 up-to-date
\nOS 7.8 up-to-date
\nFIRMWARECONTROLLER QDV1RF30 up-to-date
\nFIRMWAREDISK 0121 up-to-date
\nHMP 2.4.5.0.1 up-to-date<\/code><\/p>\n
\n[root@ODA-PRI patchs]# ls -ltrh<\/strong>
\ntotal 5.8G
\n-rw-r--r-- 1 root root 5.8G Jun 19 09:54 12.1.0.2_p23494992_197000_Linux-x86-64.zip
\n
\n[root@ODA-PRI patchs]# unzip 12.1.0.2_p23494992_197000_Linux-x86-64.zip<\/strong>
\nArchive: 12.1.0.2_p23494992_197000_Linux-x86-64.zip
\n extracting: odacli-dcs-19.7.0.0.0-200423-DB-12.1.0.2.zip
\n inflating: README.txt
\n
\n[root@ODA-PRI patchs]# ls -ltrh<\/strong>
\ntotal 12G
\n-rw-r--r-- 1 root root 5.8G Apr 23 20:10 odacli-dcs-19.7.0.0.0-200423-DB-12.1.0.2.zip
\n-rw-r--r-- 1 root root 252 May 23 20:55 README.txt
\n-rw-r--r-- 1 root root 5.8G Jun 19 09:54 12.1.0.2_p23494992_197000_Linux-x86-64.zip<\/code><\/p>\n
\n[root@ODA-PRI patchs]# odacli update-repository -f \/tmp\/patchs\/odacli-dcs-19.7.0.0.0-200423-DB-12.1.0.2.zip<\/strong>
\n{
\n \"jobId\" : \"a9677ae9-93af-43eb-b738-4a74f9686573\",
\n \"status\" : \"Created\",
\n \"message\" : \"\/tmp\/patchs\/odacli-dcs-19.7.0.0.0-200423-DB-12.1.0.2.zip\",
\n \"reports\" : [ ],
\n \"createTimestamp\" : \"August 10, 2020 09:51:41 AM CEST\",
\n \"resourceList\" : [ ],
\n \"description\" : \"Repository Update\",
\n \"updatedTime\" : \"August 10, 2020 09:51:41 AM CEST\"
\n}
\n
\n[root@ODA-PRI patchs]# odacli describe-job -i \"a9677ae9-93af-43eb-b738-4a74f9686573\"<\/strong>
\n
\nJob details
\n----------------------------------------------------------------
\n ID: a9677ae9-93af-43eb-b738-4a74f9686573
\n Description: Repository Update
\n Status: Success
\n Created: August 10, 2020 9:51:41 AM CEST
\n Message: \/tmp\/patchs\/odacli-dcs-19.7.0.0.0-200423-DB-12.1.0.2.zip
\n
\nTask Name Start Time End Time Status
\n---------------------------------------- ----------------------------------- ----------------------------------- ----------<\/code><\/p>\n
\n[root@ODA-PRI ~]# odacli create-dbhome -de SE -v 12.1.0.2.200414<\/strong>
\n
\nJob details
\n----------------------------------------------------------------
\n ID: cb35718a-3aeb-4979-acc3-d352b1f541e4
\n Description: Database Home OraDB12102_home1 creation with version :12.1.0.2.200414
\n Status: Created
\n Created: August 10, 2020 9:57:22 AM CEST
\n Message: Create Database Home
\n
\nTask Name Start Time End Time Status
\n---------------------------------------- ----------------------------------- ----------------------------------- ----------
\n
\n[root@ODA-PRI ~]# odacli describe-job -i cb35718a-3aeb-4979-acc3-d352b1f541e4<\/strong>
\n
\nJob details
\n----------------------------------------------------------------
\n ID: cb35718a-3aeb-4979-acc3-d352b1f541e4
\n Description: Database Home OraDB12102_home1 creation with version :12.1.0.2.200414
\n Status: Success
\n Created: August 10, 2020 9:57:22 AM CEST
\n Message: Create Database Home
\n
\nTask Name Start Time End Time Status
\n---------------------------------------- ----------------------------------- ----------------------------------- ----------
\nSetting up ssh equivalance August 10, 2020 9:57:23 AM CEST August 10, 2020 9:57:23 AM CEST Success
\nValidating dbHome available space August 10, 2020 9:57:23 AM CEST August 10, 2020 9:57:23 AM CEST Success
\nCreating DbHome Directory August 10, 2020 9:57:23 AM CEST August 10, 2020 9:57:23 AM CEST Success
\nExtract DB clones August 10, 2020 9:57:23 AM CEST August 10, 2020 9:59:25 AM CEST Success
\nClone Db home August 10, 2020 9:59:25 AM CEST August 10, 2020 10:01:19 AM CEST Success
\nEnable DB options August 10, 2020 10:01:19 AM CEST August 10, 2020 10:01:30 AM CEST Success
\nRun Root DB scripts August 10, 2020 10:01:30 AM CEST August 10, 2020 10:01:30 AM CEST Success
\nRemoving ssh keys August 10, 2020 10:01:39 AM CEST August 10, 2020 10:01:39 AM CEST Success<\/code><\/p>\n
\noracle@ODA-PRI:\/home\/oracle\/ [rdbms11204_1] cdd<\/strong>
\noracle@ODA-PRI:\/u01\/app\/oracle\/local\/dmk\/ [rdbms11204_1] cd etc<\/strong>
\noracle@ODA-PRI:\/u01\/app\/oracle\/local\/dmk\/etc\/ [rdbms11204_1] cp -p dmk.oratab dmk.oratab.20200810_1003<\/strong>
\noracle@ODA-PRI:\/u01\/app\/oracle\/local\/dmk\/etc\/ [rdbms11204_1] vi dmk.oratab<\/strong>
\noracle@ODA-PRI:\/u01\/app\/oracle\/local\/dmk\/etc\/ [rdbms11204_1] diff dmk.oratab dmk.oratab.20200810_1003<\/strong>
\n4d3
\n---rdbms12102_1:\/u01\/app\/oracle\/product\/12.1.0.2\/dbhome_1:D
\noracle@ODA-PRI:\/u01\/app\/oracle\/local\/dmk\/etc\/ [rdbms11204_1]<\/code><\/p>\n
\n[root@ODA-PRI ~]# odacli list-dbhomes<\/strong>
\n
\nID Name DB Version Home Location Status
\n---------------------------------------- -------------------- ---------------------------------------- --------------------------------------------- ----------
\nd6df9457-e4cd-4c39-b3cb-8d03be3c4598 OraDB11204_home1 11.2.0.4.190115 \/u01\/app\/oracle\/product\/11.2.0.4\/dbhome_1 Configured
\n9d2d92d0-3b98-42ac-9f39-9bd6deeb2e16 OraDB19000_home1 19.7.0.0.200414 \/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1 Configured
\n73847823-ae83-4bf0-a630-f8884cf4387a OraDB12102_home1 12.1.0.2.200414 \/u01\/app\/oracle\/product\/12.1.0.2\/dbhome_1 Configured<\/code><\/p>\n3- Stop the application<\/h3>\n
\nSQL> set linesize 300
\nSQL> set pagesize 500
\nSQL> col machine format a20
\nSQL> col service_name format a20
\nSQL> select SID, serial#, username, machine, process, program, status, service_name, logon_time from v$session where username not in ('SYS', 'PUBLIC') and username is not null order by status, username;<\/code><\/p>\n
\nBEGIN
\n\tfor s in (select SID, serial#, username, machine, process, program, status, service_name, logon_time from v$session where username not in ('SYS', 'PUBLIC') and username is not null and status='INACTIVE' order by status, username)
\n\tloop
\n\t\tdbms_output.put_line ('Session : ' || s.sid || ',' ||s.serial#);
\n\t\tdbms_output.put_line ('');
\n\t\texecute immediate 'alter system kill session ''' || s.sid || ',' ||s.serial# || ''' immediate';
\n\tend loop;
\nend;
\n\/<\/code><\/p>\n4- Make sure the standby database is synchronized with the primary database<\/h3>\n
\nI will consider that you are using Data Guard for Enterprise Edition and dbvisit solution for Standard Edition.<\/p>\nHigh availability with Data Guard<\/h4>\n
\nDGMGRL> show configuration<\/strong>
\n
\nConfiguration - DB1
\n
\n Protection Mode: MaxAvailability
\n Members:
\n DB1_RZA - Primary database
\n DB1_RZB - Physical standby database
\n
\nFast-Start Failover: DISABLED
\n
\nConfiguration Status:
\nSUCCESS (status updated 19 seconds ago)
\n
\n
\nDGMGRL> show database DB1_RZB<\/strong>
\n
\nDatabase - DB1_RZB
\n
\n Role: PHYSICAL STANDBY
\n Intended State: APPLY-ON
\n Transport Lag: 0 seconds (computed 1 second ago)
\n Apply Lag: 0 seconds (computed 1 second ago)
\n Average Apply Rate: 4.00 KByte\/s
\n Real Time Query: OFF
\n Instance(s):
\n DB1
\n
\nDatabase Status:
\nSUCCESS<\/code><\/p>\n
\nTransport Lag: 0 seconds (computed 1 second ago)
\nApply Lag: 0 seconds (computed 1 second ago)<\/code><\/p>\nHigh availability with dbvisit<\/h4>\n
\noracle@ODA-PRI:\/home\/oracle\/ [DB1] \/u01\/app\/dbvisit\/standby\/dbvctl -d DB1 -i<\/strong>
\n=============================================================
\nDbvisit Standby Database Technology (9.0.02_0_gbd40c486) (pid 91009)
\ndbvctl started on ODA-PRI: Mon Aug 10 09:29:17 2020
\n=============================================================
\n
\nDbvisit Standby log gap report for DB1_RZA at 202008100929:
\n-------------------------------------------------------------
\nDescription | SCN | Timestamp
\n-------------------------------------------------------------
\nSource 13139995191 2020-08-10:09:29:20 +02:00
\nDestination 13139994931 2020-08-10:09:27:37 +02:00
\n
\nStandby database time lag (DAYS-HH:MI:SS): +00:01:43
\n
\nReport for Thread 1
\n-------------------
\nSOURCE
\nCurrent Sequence 52863
\nLast Archived Sequence 52862
\nLast Transferred Sequence 52862
\nLast Transferred Timestamp 2020-08-10 09:27:42
\n
\nDESTINATION
\nRecovery Sequence 52863
\n
\nTransfer Log Gap 0
\nApply Log Gap 0
\n
\n=============================================================
\ndbvctl ended on ODA-PRI: Mon Aug 10 09:29:25 2020
\n=============================================================<\/code><\/p>\n
\nTransfer Log Gap 0
\nApply Log Gap 0<\/code><\/p>\n
\noracle@ODA-PRI|STD:\/home\/oracle\/ [DB1] \/u01\/app\/dbvisit\/standby\/dbvctl -d DB1<\/strong><\/code><\/p>\n5- Stop the synchronization between the primary and the standby database<\/h3>\n
High availability with Data Guard<\/h4>\n
\nDGMGRL> disable fast_start failover;
\nDisabled.<\/code><\/p>\n
\nDGMGRL> edit configuration set protection mode as maxperformance;
\nSucceeded.<\/code><\/p>\n
\nDGMGRL> edit database DB1_RZB set state=apply-off;
\nSucceeded.<\/code><\/p>\n
\nDGMGRL> edit database DB1_RZA set state=transport-off;
\nSucceeded.<\/code><\/p>\nHigh availability with dbvisit<\/h4>\n
\n#00,10,20,30,40,50 * * * * \/u01\/app\/dbvisit\/standby\/dbvctl -d DB1 >\/tmp\/dbvisit_apply_logs_DB1.log 2>&1<\/code><\/p>\n
\n#05,15,25,35,45,55 * * * * \/u01\/app\/dbvisit\/standby\/dbvctl -d DB1 >\/tmp\/dbvisit_apply_logs_DB1.log 2>&1<\/code><\/p>\n6- Stop the standby database<\/h3>\n
oracle@ODA-STD:\/home\/oracle\/ [DB1] DB1<\/strong>
\n********* dbi services Ltd. *********
\nSTATUS : MOUNTED
\nDB_UNIQUE_NAME : DB1_RZB
\nOPEN_MODE : MOUNTED
\nLOG_MODE : ARCHIVELOG
\nDATABASE_ROLE : PHYSICAL STANDBY
\nFLASHBACK_ON : NO
\nFORCE_LOGGING : YES
\n*************************************
\n
\noracle@ODA-STD:\/home\/oracle\/ [DB1] srvctl stop database -d DB1_RZB<\/strong>
\n
\noracle@ODA-STD:\/home\/oracle\/ [DB1] DB1<\/strong>
\n********* dbi services Ltd. *********
\nSTATUS : STOPPED
\n*************************************
\noracle@ODA-STD:\/home\/oracle\/ [DB1]<\/code><\/p>\n7- Upgrade the primary database to 12.1.0.2<\/h3>\n
7a- Prerequirements<\/h4>\n
\nSQL> set lines 300<\/strong>
\n
\nSQL> col status format a20<\/strong>
\n
\nSQL> col comp_name format a40<\/strong>
\n
\nSQL> select comp_name, status from dba_registry;<\/strong>
\n
\nCOMP_NAME STATUS
\n---------------------------------------- --------------------
\nOracle Database Catalog Views VALID
\nOracle Database Packages and Types VALID
\nOracle Workspace Manager VALID
\n
\nSQL> SELECT count(*) FROM dba_invalid_objects;<\/strong>
\n
\n COUNT(*)
\n----------
\n 0<\/code><\/p>\n
\noracle@ODA-PRI:\/home\/oracle\/ [DB1] echo $ORACLE_SID<\/strong>
\nDB1
\n
\noracle@ODA-PRI:\/home\/oracle\/ [DB1] echo $ORACLE_HOME<\/strong>
\n\/u01\/app\/oracle\/product\/11.2.0.4\/dbhome_1
\n
\noracle@ODA-PRI:\/home\/oracle\/ [DB1] ls -lthr \/u01\/app\/oracle\/product\/12.1.0.2\/dbhome_1\/rdbms\/admin\/pre*<\/strong>
\n-rw-r--r-- 1 oracle oinstall 14K May 15 2014 \/u01\/app\/oracle\/product\/12.1.0.2\/dbhome_1\/rdbms\/admin\/preupgrd.sql
\n
\noracle@ODA-PRI:\/home\/oracle\/ [DB1] sqh<\/strong>
\n
\nSQL*Plus: Release 11.2.0.4.0 Production on Mon Aug 10 10:29:32 2020
\n
\nCopyright (c) 1982, 2013, Oracle. All rights reserved.
\n
\n
\nConnected to:
\nOracle Database 11g Release 11.2.0.4.0 - 64bit Production
\nWith the Real Application Clusters option
\n
\nSQL> @\/u01\/app\/oracle\/product\/12.1.0.2\/dbhome_1\/rdbms\/admin\/preupgrd.sql<\/strong>
\n...
\n...
\n...<\/code><\/p>\n
\noracle@ODA-PRI:\/home\/oracle\/ [DB1] more \/u01\/app\/oracle\/cfgtoollogs\/DB1_RZA\/preupgrade\/preupgrade.log<\/strong>
\nOracle Database Pre-Upgrade Information Tool 08-10-2020 10:29:46
\nScript Version: 12.1.0.2.0 Build: 015
\n**********************************************************************
\n Database Name: DB1
\n Container Name: Not Applicable in Pre-12.1 database
\n Container ID: Not Applicable in Pre-12.1 database
\n Version: 11.2.0.4.0
\n Compatible: 11.2.0
\n Blocksize: 8192
\n Platform: Linux x86 64-bit
\n Timezone file: V31
\nDatabase log mode: ARCHIVELOG
\n**********************************************************************
\n [Update parameters]
\n [No parameters to update]
\n...
\n...
\n...<\/code><\/p>\n
\nSQL> @\/u01\/app\/oracle\/cfgtoollogs\/DB1_RZA\/preupgrade\/preupgrade_fixups.sql<\/strong>
\nPre-Upgrade Fixup Script Generated on 2020-08-10 10:29:45 Version: 12.1.0.2 Build: 015
\nBeginning Pre-Upgrade Fixups...
\nExecuting in container DB1
\n
\n**********************************************************************
\nCheck Tag: NEW_TIME_ZONES_EXIST
\nCheck Summary: Check for use of newer timezone data file
\nFix Summary: Time zone data file must be updated in the new ORACLE_HOME.
\n**********************************************************************
\nFixup Returned Information:
\nERROR: --> New Timezone File in use
\n
\n Database is using a time zone file newer than version 18.
\n BEFORE upgrading the database, patch the new
\n ORACLE_HOME\/oracore\/zoneinfo\/ with a time zone data file of the
\n same version as the one used in the 11.2.0.4.0 release database.
\n**********************************************************************
\n
\n
\n**********************************************************************
\nCheck Tag: PURGE_RECYCLEBIN
\nCheck Summary: Check that recycle bin is empty prior to upgrade
\nFix Summary: The recycle bin will be purged.
\n**********************************************************************
\nFixup Succeeded
\n**********************************************************************
\n
\n
\n**********************************************************************
\n [Pre-Upgrade Recommendations]
\n**********************************************************************
\n
\n *****************************************
\n ********* Dictionary Statistics *********
\n *****************************************
\n
\nPlease gather dictionary statistics 24 hours prior to
\nupgrading the database.
\nTo gather dictionary statistics execute the following command
\nwhile connected as SYSDBA:
\n EXECUTE dbms_stats.gather_dictionary_stats;
\n
\n^^^ MANUAL ACTION SUGGESTED ^^^
\n
\n
\n *****************************************
\n *********** Hidden Parameters ***********
\n *****************************************
\n
\nPlease review and remove any unnecessary hidden\/underscore parameters prior
\nto upgrading. It is strongly recommended that these be removed before upgrade
\nunless your application vendors and\/or Oracle Support state differently.
\nChanges will need to be made in the init.ora or spfile.
\n
\n ******** Existing Hidden Parameters ********
\n
\n_datafile_write_errors_crash_instance = FALSE
\n_db_writer_coalesce_area_size = 16777216
\n_disable_interface_checking = TRUE
\n_enable_NUMA_support = FALSE
\n_file_size_increase_increment = 2143289344
\n_gc_policy_time = 0
\n_gc_undo_affinity = FALSE
\n_ktb_debug_flags = 8
\n
\n^^^ MANUAL ACTION SUGGESTED ^^^
\n
\n
\n *****************************************
\n ************ Existing Events ************
\n *****************************************
\n
\nPlease review and remove any unnecessary events prior to upgrading.
\nIt is strongly recommended that these be removed before upgrade unless
\nyour application vendors and\/or Oracle Support state differently.
\nChanges will need to be made in the init.ora or spfile.
\n
\n ******** Existing Events ********
\n
\n
\n
\n^^^ MANUAL ACTION SUGGESTED ^^^
\n
\n
\n **************************************************
\n ************* Fixup Summary ************
\n
\n 1 fixup routine was successful.
\n 0 fixup routines returned INFORMATIONAL text that should be reviewed.
\n 1 ERROR LEVEL check returned INFORMATION that must be acted on prior to upgrade.
\n
\n ************************************************************
\n ====>> USER ACTION REQUIRED <<====
\n ************************************************************
\n
\n 1) Check Tag: NEW_TIME_ZONES_EXIST failed.
\n Check Summary: Check for use of newer timezone data file
\n Fixup Summary:
\n "Time zone data file must be updated in the new ORACLE_HOME."
\n ^^^ MANUAL ACTION REQUIRED ^^^
\n
\n **************************************************
\n You MUST resolve the above error prior to upgrade
\n **************************************************
\n
\n
\n**************** Pre-Upgrade Fixup Script Complete *********************
\n
\nPL\/SQL procedure successfully completed.<\/code><\/p>\n