Hello Ni TSOH I have try same method & it is completed successfully but i check invalid object present & timezone same as 26. I run manually @?/rdbms/admin/utlrp.sql & it is done same for doing timezone run script. If i add parameter on config file upg1.timezone_upg=yes,upg1.run_utlrp=yes so why it is not reflect after upgrade, why i need to do manually Thanks, Naresh
During post upgrade tasks, autoupgrade should recompile invalid objects as well as upgrade timezone if you indicated "yes" for those in the config file. Can you review your autoupgrade log to see if there were any errors during those executions?
@@bobsukki thank you for reply, as per your instruction i have checked complete autoupgrade.log but not find any ORA error. I have also checked post_upgrade.html it says for manual upgrade of timezone please check below CheckName: OLD_TIME_ZONES_EXIST FixUp Available: YES Severity: WARNING Stage: POSTCHECKS Upgrade the database time zone file using the DBMS_DST package. Oracle recommends upgrading to the desired (latest) version of the time zone file. For more information, refer to "Upgrading the Time Zone File and Timestamp with Time Zone Data" in the 19 Oracle Database Globalization Support Guide. The database is using time zone file version 26 and the target 19 release ships with time zone file version 32.
Very well explained , Keep it up and keep making such videos.
Thank you, I will 👍🏽
Nicely done !
Thank you! Cheers!
Ni Atsoh this is fantastic. Thank you for sharing your talent with others. 👏🏼👏🏼
Thank you Meggie! 🙏
Best teaching ever ... Keep it up with this amazing education to the oracle concept.
Thank you, I am glad you like it
Wayyyy to go ni Tsoh.
Thank you!
Yet another wonderful video with invaluable content.
Glad you enjoyed it
Full of bugs , a true hell
Did you get a bad experience? Please share so we can learn. I actually find this tool actually refreshing and it makes my upgrades a whole lot easier!
Hello Ni TSOH
I have try same method & it is completed successfully but i check invalid object present & timezone same as 26.
I run manually @?/rdbms/admin/utlrp.sql & it is done same for doing timezone run script. If i add parameter on config file upg1.timezone_upg=yes,upg1.run_utlrp=yes so why it is not reflect after upgrade, why i need to do manually
Thanks,
Naresh
During post upgrade tasks, autoupgrade should recompile invalid objects as well as upgrade timezone if you indicated "yes" for those in the config file. Can you review your autoupgrade log to see if there were any errors during those executions?
@@bobsukki thank you for reply, as per your instruction i have checked complete autoupgrade.log but not find any ORA error.
I have also checked post_upgrade.html it says for manual upgrade of timezone please check below
CheckName: OLD_TIME_ZONES_EXIST FixUp Available: YES Severity: WARNING Stage: POSTCHECKS
Upgrade the database time zone file using the DBMS_DST package.
Oracle recommends upgrading to the desired (latest) version of the time zone file. For more information, refer to "Upgrading the Time Zone File and Timestamp with Time Zone Data" in the 19 Oracle Database Globalization Support Guide.
The database is using time zone file version 26 and the target 19 release ships with time zone file version 32.