2021-03-09 02:51:44.448 INFO build.hash:e84c9c2 build.version:19.10.0 build.date:2020/10/23 10:36:46 build.max_target_version:19 build.supported_target_versions:12.2,18,19 build.type:production build.label:HEAD 2021-03-09 02:51:45.998 INFO Guarantee Restore Point (GRP) successfully removed [HONGKONG][AUTOUPGRADE_9212_HONGKONG122010] 2021-03-09 02:51:46.163 INFO Guarantee Restore Point (GRP) successfully created [HONGKONG][AUTOUPGRADE_9212_HONGKONG122010] 2021-03-09 02:51:49.305 INFO Analyzing hongkong, 79 checks will run using 2 threads 2021-03-09 02:51:56.295 INFO Using /home/oracle/u03/app/oracle/autoupgrade/hongkong/hongkong/102/prechecks/hongkong_checklist.cfg to identify required fixups 2021-03-09 02:51:56.298 INFO Content of the checklist /home/oracle/u03/app/oracle/autoupgrade/hongkong/hongkong/102/prechecks/hongkong_checklist.cfg is: [SID] [hongkong] ========================================== [container] [hongkong] ========================================== [checkname] POST_DICTIONARY [stage] POSTCHECKS [fixup_available] YES [runfix] YES [severity] RECOMMEND ---------------------------------------------------- [checkname] POST_FIXED_OBJECTS [stage] POSTCHECKS [fixup_available] NO [runfix] N/A [severity] RECOMMEND ---------------------------------------------------- [checkname] OLD_TIME_ZONES_EXIST [stage] POSTCHECKS [fixup_available] YES [runfix] YES [severity] WARNING ---------------------------------------------------- [checkname] RMAN_RECOVERY_VERSION [stage] PRECHECKS [fixup_available] NO [runfix] N/A [severity] INFO ---------------------------------------------------- [checkname] TABLESPACES_INFO [stage] PRECHECKS [fixup_available] NO [runfix] N/A [severity] INFO ---------------------------------------------------- [checkname] INFORM_DROP_GRP [stage] POSTCHECKS [fixup_available] NO [runfix] N/A [severity] INFO ---------------------------------------------------- [checkname] ORDIM_INFO_DESUPPORT [stage] PRECHECKS [fixup_available] NO [runfix] N/A [severity] INFO ---------------------------------------------------- [checkname] TIMESTAMP_MISMATCH [stage] POSTCHECKS [fixup_available] YES [runfix] YES [severity] WARNING ---------------------------------------------------- 2021-03-09 02:51:56.331 INFO Adding fixup PURGE_RECYCLEBIN PRECHECKS YES true ERROR to execution queue of hongkong 2021-03-09 02:52:01.691 INFO Analyzing hongkong, 79 checks will run using 2 threads 2021-03-09 02:52:05.187 INFO Generating Context text file list /home/oracle/u03/app/oracle/autoupgrade/hongkong/hongkong/temp/ctx_move_text_file_list_hongkong 2021-03-09 02:52:25.461 INFO Copying password file from /home/oracle/u03/app/oracle/product/12.2.0/db_1/dbs/orapwhongkong to /u01/app/oracle/product/19.0.0/dbhome_1/dbs/orapwhongkong 2021-03-09 02:52:25.463 INFO Copying password file completed with success 2021-03-09 02:52:44.769 INFO Total Number of upgrade phases is 108 2021-03-09 02:52:44.777 INFO Begin Upgrade on Database [hongkong] 2021-03-09 02:52:54.097 INFO [Upgrading] is [0%] completed for [hongkong] +---------+------------+ |CONTAINER| PERCENTAGE| +---------+------------+ | hongkong|UPGRADE [0%]| +---------+------------+ 2021-03-09 02:55:56.301 INFO [Upgrading] is [3%] completed for [hongkong] +---------+------------+ |CONTAINER| PERCENTAGE| +---------+------------+ | hongkong|UPGRADE [3%]| +---------+------------+ 2021-03-09 02:58:59.331 INFO [Upgrading] is [8%] completed for [hongkong] +---------+------------+ |CONTAINER| PERCENTAGE| +---------+------------+ | hongkong|UPGRADE [8%]| +---------+------------+ 2021-03-09 03:02:01.522 INFO [Upgrading] is [10%] completed for [hongkong] +---------+-------------+ |CONTAINER| PERCENTAGE| +---------+-------------+ | hongkong|UPGRADE [10%]| +---------+-------------+ 2021-03-09 03:05:03.875 INFO [Upgrading] is [21%] completed for [hongkong] +---------+-------------+ |CONTAINER| PERCENTAGE| +---------+-------------+ | hongkong|UPGRADE [21%]| +---------+-------------+ 2021-03-09 03:08:06.175 INFO [Upgrading] is [23%] completed for [hongkong] +---------+-------------+ |CONTAINER| PERCENTAGE| +---------+-------------+ | hongkong|UPGRADE [23%]| +---------+-------------+ 2021-03-09 03:11:08.694 INFO [Upgrading] is [39%] completed for [hongkong] +---------+-------------+ |CONTAINER| PERCENTAGE| +---------+-------------+ | hongkong|UPGRADE [39%]| +---------+-------------+ 2021-03-09 03:14:11.295 INFO [Upgrading] is [49%] completed for [hongkong] +---------+-------------+ |CONTAINER| PERCENTAGE| +---------+-------------+ | hongkong|UPGRADE [49%]| +---------+-------------+ 2021-03-09 03:17:13.800 INFO [Upgrading] is [49%] completed for [hongkong] +---------+-------------+ |CONTAINER| PERCENTAGE| +---------+-------------+ | hongkong|UPGRADE [49%]| +---------+-------------+ 2021-03-09 03:20:16.050 INFO [Upgrading] is [70%] completed for [hongkong] +---------+-------------+ |CONTAINER| PERCENTAGE| +---------+-------------+ | hongkong|UPGRADE [70%]| +---------+-------------+ 2021-03-09 03:23:18.919 INFO [Upgrading] is [77%] completed for [hongkong] +---------+-------------+ |CONTAINER| PERCENTAGE| +---------+-------------+ | hongkong|UPGRADE [77%]| +---------+-------------+ 2021-03-09 03:26:21.318 INFO [Upgrading] is [91%] completed for [hongkong] +---------+-------------+ |CONTAINER| PERCENTAGE| +---------+-------------+ | hongkong|UPGRADE [91%]| +---------+-------------+ 2021-03-09 03:29:24.474 INFO [Upgrading] is [91%] completed for [hongkong] +---------+-------------+ |CONTAINER| PERCENTAGE| +---------+-------------+ | hongkong|UPGRADE [91%]| +---------+-------------+ 2021-03-09 03:32:22.447 INFO SUCCESSFULLY UPGRADED [hongkong] 2021-03-09 03:32:22.447 INFO End Upgrade on Database [hongkong] 2021-03-09 03:32:35.131 INFO [Compiling] is [0%] completed for [hongkong] objects remaining is [2558] +---------+------------+ |CONTAINER| PERCENTAGE| +---------+------------+ | hongkong|COMPILE [0%]| +---------+------------+ 2021-03-09 03:32:36.457 INFO Begin Compiling Invalid Objects on Database [hongkong] 2021-03-09 03:35:39.174 INFO [Compiling] is [98%] completed for [hongkong] objects remaining is [51] +---------+-------------+ |CONTAINER| PERCENTAGE| +---------+-------------+ | hongkong|COMPILE [98%]| +---------+-------------+ 2021-03-09 03:38:37.742 INFO End Compiling Invalid Objects on Database [hongkong] 2021-03-09 03:38:37.743 INFO SUCCESSFULLY COMPILED [hongkong] 2021-03-09 03:38:39.366 INFO [Upgrading] is [100%] completed for [hongkong] +---------+--------------------------------+ |CONTAINER| PERCENTAGE| +---------+--------------------------------+ | hongkong|SUCCESSFULLY UPGRADED [hongkong]| +---------+--------------------------------+ 2021-03-09 03:38:39.493 INFO Error opening file [/u01/app/oracle/product/19.0.0/dbhome_1/dbs/inithongkong.ora] for reading 2021-03-09 03:38:40.554 INFO Creating spfile completed with success 2021-03-09 03:38:40.554 INFO SUCCESSFULLY UPGRADED [hongkong] 2021-03-09 03:38:40.692 INFO hongkong Return status is SUCCESS 2021-03-09 03:40:32.231 INFO Analyzing hongkong, 12 checks will run using 2 threads 2021-03-09 03:40:41.230 INFO Using /home/oracle/u03/app/oracle/autoupgrade/hongkong/hongkong/102/prechecks/hongkong_checklist.cfg to identify required fixups 2021-03-09 03:40:41.265 INFO Content of the checklist /home/oracle/u03/app/oracle/autoupgrade/hongkong/hongkong/102/prechecks/hongkong_checklist.cfg is: [SID] [hongkong] ========================================== [container] [hongkong] ========================================== [checkname] POST_DICTIONARY [stage] POSTCHECKS [fixup_available] YES [runfix] YES [severity] RECOMMEND ---------------------------------------------------- [checkname] POST_FIXED_OBJECTS [stage] POSTCHECKS [fixup_available] NO [runfix] N/A [severity] RECOMMEND ---------------------------------------------------- [checkname] OLD_TIME_ZONES_EXIST [stage] POSTCHECKS [fixup_available] YES [runfix] YES [severity] WARNING ---------------------------------------------------- [checkname] RMAN_RECOVERY_VERSION [stage] PRECHECKS [fixup_available] NO [runfix] N/A [severity] INFO ---------------------------------------------------- [checkname] TABLESPACES_INFO [stage] PRECHECKS [fixup_available] NO [runfix] N/A [severity] INFO ---------------------------------------------------- [checkname] INFORM_DROP_GRP [stage] POSTCHECKS [fixup_available] NO [runfix] N/A [severity] INFO ---------------------------------------------------- [checkname] ORDIM_INFO_DESUPPORT [stage] PRECHECKS [fixup_available] NO [runfix] N/A [severity] INFO ---------------------------------------------------- [checkname] TIMESTAMP_MISMATCH [stage] POSTCHECKS [fixup_available] YES [runfix] YES [severity] WARNING ---------------------------------------------------- 2021-03-09 03:41:48.837 INFO TimeZone upgrade log files will be located under /home/oracle/u03/app/oracle/autoupgrade/hongkong/hongkong/temp/hongkong/TimeZone 2021-03-09 03:41:48.861 INFO Processing hongkong 2021-03-09 03:41:48.877 INFO Executing [/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/sqlsessstart.sql][hongkong] 2021-03-09 03:41:49.878 INFO Complete [/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/sqlsessstart.sql][hongkong] 2021-03-09 03:41:49.878 INFO Looking for errors in log file after /u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/sqlsessstart.sql execution on [hongkong] 2021-03-09 03:41:49.878 INFO Executing [/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/utltz_upg_check.sql][hongkong] 2021-03-09 03:41:52.880 INFO Complete [/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/utltz_upg_check.sql][hongkong] 2021-03-09 03:41:52.880 INFO Looking for errors in log file after /u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/utltz_upg_check.sql execution on [hongkong] 2021-03-09 03:41:52.881 INFO Executing [/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/utltz_upg_apply.sql][hongkong] 2021-03-09 03:43:46.088 INFO Complete [/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/utltz_upg_apply.sql][hongkong] 2021-03-09 03:43:46.088 INFO Looking for errors in log file after /u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/utltz_upg_apply.sql execution on [hongkong] 2021-03-09 03:43:46.088 INFO Executing [/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/sqlsessend.sql][hongkong] 2021-03-09 03:43:48.593 INFO Complete [/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/sqlsessend.sql][hongkong] 2021-03-09 03:43:48.593 INFO Looking for errors in log file after /u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/sqlsessend.sql execution on [hongkong] 2021-03-09 03:43:48.593 INFO Closing sqlplus with exitValue 0 [hongkong] 2021-03-09 03:43:48.594 INFO The Timezone upgrade has finished for [hongkong] 2021-03-09 03:44:24.789 INFO Analyzing hongkong, 12 checks will run using 2 threads 2021-03-09 03:44:30.531 INFO Updating oratab file /etc/oratab completed with success 2021-03-09 03:44:30.538 INFO Copying/merging file oranfstab ended 2021-03-09 03:44:30.538 INFO Copying/merging file listener.ora ended 2021-03-09 03:44:30.539 INFO Copying/merging file ldap.ora ended 2021-03-09 03:44:30.566 INFO Creating temporary IFile /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/tnsnames.ora.tmp 2021-03-09 03:44:30.567 INFO IFILE /home/oracle/u03/app/oracle/product/12.2.0/db_1/network/admin/tnsnames.ora not found, skipping... 2021-03-09 03:44:30.611 INFO Merging files /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/tnsnames.ora.tmp and /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/tnsnames.ora to /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/tnsnames.ora 2021-03-09 03:44:30.611 INFO No Oracle Home value found in file /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/tnsnames.ora 2021-03-09 03:44:30.611 INFO Copying/merging file /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/tnsnames.ora.tmp ended 2021-03-09 03:44:30.612 INFO Copying/merging file sqlnet.ora ended 2021-03-09 03:44:30.773 INFO File [/u01/app/oracle/product/19.0.0/dbhome_1/ctx/data/delx/drde.dct] already exists 2021-03-09 03:44:30.775 INFO File [/u01/app/oracle/product/19.0.0/dbhome_1/ctx/data/kolx/drk2udic.dat] already exists 2021-03-09 03:44:30.775 INFO File [/u01/app/oracle/product/19.0.0/dbhome_1/ctx/data/kolx/drk2gram.dat] already exists 2021-03-09 03:44:30.776 INFO File [/u01/app/oracle/product/19.0.0/dbhome_1/ctx/data/kolx/drk2xdic.dat] already exists 2021-03-09 03:44:30.776 INFO File [/u01/app/oracle/product/19.0.0/dbhome_1/ctx/data/kolx/drk2sdic.dat] already exists 2021-03-09 03:44:30.794 INFO File [/u01/app/oracle/product/19.0.0/dbhome_1/ctx/config/drmailfl.txt] already exists 2021-03-09 03:44:58.959 INFO Error opening file [/u01/app/oracle/product/19.0.0/dbhome_1/dbs/inithongkong.ora] for reading 2021-03-09 03:45:00.105 INFO Creating spfile completed with success 2021-03-09 03:45:15.344 INFO Database hongkong was successfully restarted 2021-03-09 03:45:15.358 INFO Return status is SUCCESS 2021-03-09 03:45:15.384 INFO Update of oratab [hongkong] [/etc/oratab] [SUCCESS] [None] Network Files [hongkong] [/u01/app/oracle/product/19.0.0/dbhome_1/network/admin/tnsnames.ora] [SUCCESS] [None] [/u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora] [SUCCESS] [None] [/u01/app/oracle/product/19.0.0/dbhome_1/network/admin/sqlnet.ora] [SUCCESS] [None] Context text Files [hongkong] [SUCCESS] [None] Database State Resetting the database's state: [SUCCESS] [None] Drop GRP [hongkong] [SUCCESS] [None] Creation of SPFILE for database [hongkong] [SUCCESS] [None] Restart of database [hongkong] [SUCCESS] [None]
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter : https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8