Site icon ORACLEAGENT BLOG

autoupgrade_20210309_user.log

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

Exit mobile version