<\/p>\n\n\n\n
Plan and Execute an Oracle Database Upgrade<\/strong><\/span><\/p>\n\n\n\n Why should we update a Database system, even if it is working with good performance?<\/span><\/p>\n\n\n\n Oracle is responsible to manage the end of life support of the Oracle Software;<\/span> Prepare Oracle Database Upgrade:<\/span><\/strong><\/p>\n\n\n\n 1 – Before starting the database upgrade, evaluate if the applications running in the database are certified to be executed under a more recent Oracle Database Version;<\/span> After Database Upgrade, what needs to be done?<\/span><\/strong><\/p>\n\n\n\n We at Crossjoin have a team of valuable experts with a large experience in configuring and managing complex and high performance Oracle Database systems in Telecom and Bank industry.<\/span> <\/p>\n","protected":false},"excerpt":{"rendered":" by Pedro Coimbra \/ Infrastructure Delivery Manager Plan and Execute an Oracle Database Upgrade Why should we update a Database system, even if it is [\u2026]<\/span><\/p>\n","protected":false},"author":2,"featured_media":6001,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"rs_blank_template":"","rs_page_bg_color":"","slide_template_v7":"","footnotes":""},"categories":[74,53],"tags":[76,77,58,78],"class_list":["post-5998","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-articles","category-crossjoin","tag-5g","tag-6g","tag-crossjoin","tag-iot"],"acf":[],"_links":{"self":[{"href":"https:\/\/crossjoin.com\/en\/wp-json\/wp\/v2\/posts\/5998","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/crossjoin.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/crossjoin.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/crossjoin.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/crossjoin.com\/en\/wp-json\/wp\/v2\/comments?post=5998"}],"version-history":[{"count":7,"href":"https:\/\/crossjoin.com\/en\/wp-json\/wp\/v2\/posts\/5998\/revisions"}],"predecessor-version":[{"id":27643,"href":"https:\/\/crossjoin.com\/en\/wp-json\/wp\/v2\/posts\/5998\/revisions\/27643"}],"wp:attachment":[{"href":"https:\/\/crossjoin.com\/en\/wp-json\/wp\/v2\/media?parent=5998"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/crossjoin.com\/en\/wp-json\/wp\/v2\/categories?post=5998"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/crossjoin.com\/en\/wp-json\/wp\/v2\/tags?post=5998"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Even in a system stable and working fine, the client should always take into account the end of the extended support of the database version;<\/span>
Ensure the Security patches, new features and more reliable versions;<\/span>
Ensure the availability of future upgrades for the databases.<\/span><\/p>\n\n\n\n
2 – Include in the plan the upgrade of the database in the DEV and Integration environments, assure that functional and performance tests are executed.<\/span>
3 – Include in the Plan the best upgrade strategy in order to reduce the downtime of the systems;<\/span>
4 – Choose an upgrade method for Oracle database, using the DBUA Gui or a manual command line method;<\/span>
5 – If you are using Oracle ASM and Cluster, ensure that the Oracle Asm version is higher or equal to Oracle Database version running;<\/span>
6 – Before starting the upgrade, ensure that the database has at least one valid backup available;<\/span>
7 – Evaluate if the actual Operating system version supports the new version of the Oracle Software;<\/span>
8 – Choose and prepare a new Oracle Home installation location;<\/span>
9 – Analyze the database using the Pre-Upgrade Information Tool, and validate if the database is ready to be upgraded.<\/span><\/p>\n\n\n\n\n
We can help planning and executing the database Upgrades, in order to assure a smooth migration with a minimal impact on the applications.<\/span><\/p>\n\n\n\n