{"id":2378,"date":"2012-01-06T10:05:09","date_gmt":"2012-01-06T18:05:09","guid":{"rendered":"http:\/\/www.technosolutions.com\/kb\/2378\/how-to-apply-fix-patch-on-oracle-database\/"},"modified":"2018-12-19T03:47:51","modified_gmt":"2018-12-19T11:47:51","slug":"how-to-apply-a-fix-patch-on-oracle-database","status":"publish","type":"post","link":"http:\/\/www.technosolutions.com\/kb\/2378\/how-to-apply-a-fix-patch-on-oracle-database\/","title":{"rendered":"How to apply a fix patch on Oracle Database"},"content":{"rendered":"

<\/p>\n

\n
\n

What is this article about?<\/h3>\n
\n

This article describes the procedure for applying a fix patch on Oracle Database<\/em>.<\/p>\n<\/div>\n<\/div>\n

\n

Who should read this?<\/h3>\n
\n
    \n
  • Top Team Administrators<\/li>\n
  • Database Administrators<\/li>\n<\/ul>\n<\/div>\n<\/div>\n
    \n

    Prerequisites<\/h3>\n
    \n
      \n
    • Ensure that all the users are disconnected from TopTeam Application Server<\/em>, while applying this upgrade fix patch.<\/li>\n
    • It is also recommended that you must take a backup of the database.<\/strong><\/li>\n<\/ul>\n<\/div>\n<\/div>\n
      \n

      Step 1. Download the fix patch utility from the link provided by TechnoSolutions Support<\/h3>\n
      <\/div>\n<\/div>\n
      \n

      Step 2. Extract the downloaded DB Schema upgrade patch<\/h3>\n
      \"wpid2369-media_1309952885920.png\"<\/div>\n
      \n

      Verify the structure of the extracted folder as shown in the above screen.<\/p>\n

      Double-click the Installer<\/em> to start the process.<\/p>\n<\/div>\n<\/div>\n

      \n

      Step 3. Welcome to the Oracle DB Schema Installer<\/h3>\n
      \"wpid2370-media_1309953555891.png\"<\/div>\n
      <\/div>\n<\/div>\n
      \n

      Step 4. Choose Apply patch to or upgrade existing database schema<\/h3>\n
      \"wpid2371-media_1309953665161.png\"<\/div>\n
      <\/div>\n<\/div>\n
      \n

      Step 5. Take a backup of the existing database schema<\/h3>\n
      \"wpid2372-media_1309953951018.png\"<\/div>\n
      \n

      It is highly recommended to take a backup of TopTeam Database Schema <\/em>before you apply the patch.<\/p>\n<\/div>\n<\/div>\n

      \n

      Step 6. Login to Repository Schema<\/h3>\n
      \"wpid2376-media_1325603676878.png\"<\/div>\n
      \n

      Enter the Username<\/em> and Password<\/em> for the Oracle Database Schema<\/em>. Select the Database Name<\/em> where the TopTeam Schema<\/em> exists.
      \nYou must have the proper permissions to proceed.
      \nThen, click Next<\/em>.<\/p>\n<\/div>\n<\/div>\n

      \n

      View Scripts Files (optional)<\/h3>\n
      \"wpid2373-media_1309956517410.png\"<\/div>\n
      <\/div>\n<\/div>\n
      \n

      Step 7. Apply the patch<\/h3>\n
      \"wpid2374-media_1309956560093.png\"<\/div>\n
      <\/div>\n<\/div>\n
      \n

      Step 8. Finish the wizard<\/h3>\n
      \"wpid2375-media_1309956661989.png\"<\/div>\n
      <\/div>\n<\/div>\n
      \n

      Step 9. Log File<\/h3>\n
      \"wpid2377-media_1325603793252.png\"<\/div>\n
      \n

      The log file is created in the following folder:
      \nC:\\\u2026\\My Documents\\TechnoSolutions\\DB Schema Installer<\/p>\n

      In case you face any difficulty in upgrading TopTeam Database<\/em>, TopTeam Support<\/em> will need this log file to analyze the problem.
      \nKeep a backup of this file for future reference.<\/p>\n<\/div>\n<\/div>\n

      \n
      \n

      Revised: September 7th, 2015<\/p>\n<\/div>\n<\/div>\n<\/div>\n

      <\/p>\n","protected":false},"excerpt":{"rendered":"

      What is this article about? This article describes the procedure for applying a fix patch on Oracle Database. Who should read this? Top Team Administrators Database Administrators Prerequisites Ensure that all the users are disconnected from TopTeam Application Server, while applying this upgrade fix patch. It is also recommended that you must take a backup of the database. Step 1. Download the fix patch utility from the link provided by TechnoSolutions Support Step 2. Extract the downloaded DB Schema upgrade patch Verify the structure of the extracted folder as shown in the above screen. Double-click the Installer to start the <\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[281,7],"class_list":["post-2378","post","type-post","status-publish","format-standard","hentry","category-database","tag-database","tag-oracle"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/paoaNA-Cm","_links":{"self":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2378","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/comments?post=2378"}],"version-history":[{"count":4,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2378\/revisions"}],"predecessor-version":[{"id":46673,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2378\/revisions\/46673"}],"wp:attachment":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/media?parent=2378"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/categories?post=2378"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/tags?post=2378"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}