{"id":13107,"date":"2019-09-27T18:03:29","date_gmt":"2019-09-27T18:03:29","guid":{"rendered":"https:\/\/dbtut.com\/?p=13107"},"modified":"2021-09-19T11:09:56","modified_gmt":"2021-09-19T11:09:56","slug":"apply-patch-on-oracle-db-home","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/09\/27\/apply-patch-on-oracle-db-home\/","title":{"rendered":"Apply Patch on Oracle DB Home"},"content":{"rendered":"<h2 style=\"text-align: left;\">Steps to Apply Patch on DB Home<\/h2>\n<p style=\"text-align: left;\">This document shows how to apply patch on Oracle home \/ databases.<\/p>\n<p style=\"text-align: left;\"><em><strong>July 2019 PSU for Oracle databases.<\/strong><\/em><br \/>\nBelow patches are only for oracle database home if you want to apply on GRID then GI patch is difference and steps are as well.<\/p>\n<h3 style=\"text-align: left;\">Patch ID details<\/h3>\n<p style=\"text-align: left;\">Patch <strong>29834717<\/strong> &#8211; Database Release Update <strong>19.4.0.0.190716 ==&gt; 19c<\/strong><br \/>\nPatch <strong>29757256<\/strong> &#8211; Database Release Update <strong>18.7.0.0.190716\u00a0==&gt; 18c<\/strong><br \/>\nPatch <strong>29757449<\/strong> &#8211; Database Release <strong>12.2.0.1.190716 ==&gt; 12.2.0.1<\/strong><br \/>\nPatch <strong>29494060<\/strong> &#8211; Database Patch Set Update <strong>12.1.0.2.190716 ==&gt; 12.1.0.2<\/strong><\/p>\n<p style=\"text-align: left;\"><em>The next four dates for Critical Patch Updates are:<\/em><br \/>\n<strong>October 15, 2019<\/strong><br \/>\n<strong>January 14, 2020<\/strong><br \/>\n<strong>April 14, 2020<\/strong><br \/>\n<strong>July 14, 2020<\/strong><\/p>\n<h3>Prerequisites<\/h3>\n<p><strong>1.<\/strong> Go to Patch location and make sure download \/ copy correct patch and unzip it which depends on OS platform type &amp; DB version.<\/p>\n<pre class=\"lang:default decode:true\">mkdir -p \/home\/oracle\/12.1.0.2_patch_jul2019\r\ncd \/home\/oracle\/12.1.0.2_patch_jul2019\/\r\nls -lrt<\/pre>\n<p><strong>2.<\/strong> Download patch as require and make sure you have downloaded correct patch version for specific OS type &amp; DB version. Here I am showing for Linux 64 Bit and database version is 12.2.0.1<\/p>\n<pre class=\"lang:default decode:true \">unzip 29757449_121020_Linux-x86-64.zip\r\nls -lrt\r\ncd 29757449\r\nls -lrt<\/pre>\n<p><strong>3.<\/strong> Capture information of running instances, listener, patch inventory, oratab\u00a0&amp; backup of associated ORACLE_HOME (In RAC Instances, execute on all available nodes)<\/p>\n<pre class=\"lang:default decode:true \">ps -ef |grep pmon &gt; \/home\/oracle\/12.1.0.2_patch_jul2019\/current_instance.txt\r\nps -ef |grep tns &gt; \/home\/oracle\/12.1.0.2_patch_jul2019\/current_tns.txt\r\ncat \/etc\/oratab &gt; \/home\/oracle\/12.1.0.2_patch_jul2019\/current_oratab.txt\u00a0 ==&gt; OS specific\r\n$ORACLE_HOME\/OPatch\/opatch lsinventory &gt; \/home\/oracle\/12.1.0.2_patch_jul2019\/before_current_lsinventory.txt\r\ntar -cvf oracle_home_19Jul2019.tar $ORACLE_HOME\r\n. oraenv\r\n\r\nexport PATH=$ORACLE_HOME\/OPatch:$PATH\r\nopatch version<\/pre>\n<p>Output of opatch version should be most latest version or similar, refer read me of patch ID document and according that it&#8217;s require to upgrade<\/p>\n<p><strong>4.<\/strong> Determine whether any currently installed interim patches conflict with the patch being installed.<\/p>\n<pre class=\"lang:default decode:true\">cd \/home\/oracle\/12.1.0.2_patch_jul2019\/29757449\r\n. oraenv\r\n\r\nexport PATH=$ORACLE_HOME\/OPatch:$PATH\r\nopatch prereq CheckConflictAgainstOHWithDetail -ph .\/<\/pre>\n<p>Make sure no patch conflict output in prerequisite, in case any conflict act according that.<\/p>\n<h2>Installation<\/h2>\n<p>To install the patch, follow these steps:<\/p>\n<p><strong>1.<\/strong> Set environment<\/p>\n<pre class=\"lang:default decode:true\">. oraenv\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\r\nexport PATH=$ORACLE_HOME\/OPatch:$PATH<\/pre>\n<p style=\"text-align: left;\"><strong>2.<\/strong> Ensure that you shut down all the services running from the Oracle home where you are performing patch activity. Shutdown DB and Listener running associated from same ORACLE HOME where we are applying patch<\/p>\n<p><strong>For HAS &amp; RAC Instances:<\/strong><\/p>\n<pre class=\"lang:default decode:true\">srvctl status database -d dev12c\r\nsrvctl stop database -d dev12c\r\nsrvctl stop listener -listener<\/pre>\n<p>In RAC environment if you don&#8217;t have down time then perform instance wise i.e stop services on one node at a time (Rolling fashion)<\/p>\n<p><strong>For Standalone DB:<\/strong><\/p>\n<pre class=\"lang:default decode:true \">sqlplus \/ as sysdba\r\nshutdown immediate\r\nlsnrctl stop<\/pre>\n<p><strong>3.<\/strong> Ensure no services \/ processes are running from target ORACLE HOME<\/p>\n<pre class=\"lang:default decode:true \">ps -eaf | grep pmon\r\nps -eaf | grep tns\r\nps -eaf | grep exp\r\nps -eaf | grep rman<\/pre>\n<p><strong>4.<\/strong> Set your current directory to the directory where the patch is located and then run the opatch utility by entering the following commands:<\/p>\n<pre class=\"lang:default decode:true\">cd \/home\/oracle\/12.1.0.2_patch_jul2019\/29757449\r\n$ opatch apply<\/pre>\n<p><strong>Note:<\/strong>\u00a0When using opatch you will be asked the following questions for each patch, reply as follows:<\/p>\n<p><em>Email address\/User Name:\u00a0\u00a0 <\/em><\/p>\n<p><em><strong>Leave Blank<\/strong><\/em><\/p>\n<p><em>Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:<\/em><br \/>\n<strong><em>Y<\/em><\/strong><br \/>\n<em>Is the local system ready for patching? [y|n]<\/em><br \/>\n<strong><em>y<\/em><\/strong><\/p>\n<p><strong>NOTE:\u00a0<\/strong>In RAC DB \/ Instance, it will prompt for next available node to patch after completion on executed node and if you want to instance wise use option \u2013local<\/p>\n<p><strong>6.<\/strong>Verify whether the patch has been successfully installed by running the following command:<\/p>\n<pre class=\"lang:default decode:true \">opatch lsinventory &gt; \/home\/oracle\/12.1.0.2_patch_jul2019\/after_current_lsinventory.txt<\/pre>\n<h2>Post patch installation<\/h2>\n<p><strong>1.<\/strong> Start the services from the Oracle home.<\/p>\n<pre class=\"lang:default decode:true \">sqlplus \/nolog\r\nconn \/ as sysdba\r\nstartup\r\nalter pluggable database all\u00a0open; ==&gt;\u00a0optional if Multitenant (CDB\/PDB) used\r\nquit<\/pre>\n<p><strong>2.<\/strong><\/p>\n<pre class=\"lang:default decode:true \">cd $ORACLE_HOME\/OPatch\r\n.\/datapatch -verbose<\/pre>\n<p><strong>3. <\/strong><em>Validate patch applied in database.<\/em><\/p>\n<pre class=\"lang:default decode:true \">sqlplus \/ as sysdba\r\nSET LINESIZE 400\r\nCOLUMN action_time FORMAT A20\r\nCOLUMN action FORMAT A10\r\nCOLUMN status FORMAT A10\r\nCOLUMN description FORMAT A40\r\nCOLUMN version FORMAT A10\r\nCOLUMN bundle_series FORMAT A10\r\nSELECT TO_CHAR(action_time, 'DD-MON-YYYY HH24:MI:SS') AS action_time,\r\naction,status,description,\u00a0version,patch_id,bundle_series\r\nFROM\u00a0\u00a0sys.dba_registry_sqlpatch ORDER by action_time;\r\nshutdown<\/pre>\n<p><strong>4<\/strong> <em>Startup database<\/em><\/p>\n<p><strong>For HAS \/ RAC DB \/ Instance startup:<\/strong><\/p>\n<pre class=\"lang:default decode:true \">srvctl start database -d dev12c\r\nsrvctl status database -d dev12c<\/pre>\n<p><strong>For Standalone DB startup:<\/strong><\/p>\n<pre class=\"lang:default decode:true \">sqlplus \/ as sysdba\r\nstartup\r\nps -eaf | grep pmon\r\nps -eaf | grep tns<\/pre>\n<p><strong>NOTE:<\/strong> Follow post installation step# 1 to 4 for all databases running from same ORACLE_HOME where we applied patch and in RAC environment only execute on one instance.<br \/>\nMake sure all services are up &amp; running from patched ORACLE HOME<br \/>\nThank you<\/p>\n<p><strong><em>**This document is only for learning purpose and always validate in LAB environment first before apply on LIVE environment.<\/em><br \/>\n<\/strong><\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_13107\" class=\"pvc_stats all  \" data-element-id=\"13107\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Steps to Apply Patch on DB Home This document shows how to apply patch on Oracle home \/ databases. July 2019 PSU for Oracle databases. Below patches are only for oracle database home if you want to apply on GRID then GI patch is difference and steps are as well. Patch ID details Patch 29834717 &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_13107\" class=\"pvc_stats all  \" data-element-id=\"13107\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":474,"featured_media":13151,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-13107","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Apply Patch on Oracle DB Home - Database Tutorials<\/title>\n<meta name=\"description\" content=\"This document shows how to apply patch on Oracle home \/ databases.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/09\/27\/apply-patch-on-oracle-db-home\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Apply Patch on Oracle DB Home - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"This document shows how to apply patch on Oracle home \/ databases.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/09\/27\/apply-patch-on-oracle-db-home\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-09-27T18:03:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-09-19T11:09:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/09\/Ads\u0131z-9.png\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"389\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Suman Gupta\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Suman Gupta\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/09\/27\/apply-patch-on-oracle-db-home\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/09\/27\/apply-patch-on-oracle-db-home\/\"},\"author\":{\"name\":\"Suman Gupta\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/bf1017d2e692d73bbb246c8eb2f46072\"},\"headline\":\"Apply Patch on Oracle DB Home\",\"datePublished\":\"2019-09-27T18:03:29+00:00\",\"dateModified\":\"2021-09-19T11:09:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/09\/27\/apply-patch-on-oracle-db-home\/\"},\"wordCount\":514,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/09\/27\/apply-patch-on-oracle-db-home\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/09\/Ads\u0131z-9.png\",\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/09\/27\/apply-patch-on-oracle-db-home\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/09\/27\/apply-patch-on-oracle-db-home\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/09\/27\/apply-patch-on-oracle-db-home\/\",\"name\":\"Apply Patch on Oracle DB Home - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/09\/27\/apply-patch-on-oracle-db-home\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/09\/27\/apply-patch-on-oracle-db-home\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/09\/Ads\u0131z-9.png\",\"datePublished\":\"2019-09-27T18:03:29+00:00\",\"dateModified\":\"2021-09-19T11:09:56+00:00\",\"description\":\"This document shows how to apply patch on Oracle home \/ databases.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/09\/27\/apply-patch-on-oracle-db-home\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/09\/27\/apply-patch-on-oracle-db-home\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/09\/27\/apply-patch-on-oracle-db-home\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/09\/Ads\u0131z-9.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/09\/Ads\u0131z-9.png\",\"width\":600,\"height\":389},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/09\/27\/apply-patch-on-oracle-db-home\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Apply Patch on Oracle DB Home\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/bf1017d2e692d73bbb246c8eb2f46072\",\"name\":\"Suman Gupta\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/92f0f52997f1aa29f5dfb09b19fb1f6b4f0064f2ef4364f649273ab4be74b57a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/92f0f52997f1aa29f5dfb09b19fb1f6b4f0064f2ef4364f649273ab4be74b57a?s=96&d=mm&r=g\",\"caption\":\"Suman Gupta\"},\"description\":\"Database Administrator with\u00a010+\u00a0years of diverse experience in database design and administration, data modeling, data warehousing, Enterprise Systems Architecture along with team management. Extensive technical skills and advanced understanding of Oracle (9i to 18c), Postgres EDB (10.8, 11.3) administration in sector Finance, Distribution, Energy &amp; Utilities Strong collaborator and team player with excellent communication skills and expertise in analytic problem-solving.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/suman-gupta-75247012\/\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/sumangupta\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Apply Patch on Oracle DB Home - Database Tutorials","description":"This document shows how to apply patch on Oracle home \/ databases.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2019\/09\/27\/apply-patch-on-oracle-db-home\/","og_locale":"en_US","og_type":"article","og_title":"Apply Patch on Oracle DB Home - Database Tutorials","og_description":"This document shows how to apply patch on Oracle home \/ databases.","og_url":"https:\/\/dbtut.com\/index.php\/2019\/09\/27\/apply-patch-on-oracle-db-home\/","og_site_name":"Database Tutorials","article_published_time":"2019-09-27T18:03:29+00:00","article_modified_time":"2021-09-19T11:09:56+00:00","og_image":[{"width":600,"height":389,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/09\/Ads\u0131z-9.png","type":"image\/png"}],"author":"Suman Gupta","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Suman Gupta","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/09\/27\/apply-patch-on-oracle-db-home\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/09\/27\/apply-patch-on-oracle-db-home\/"},"author":{"name":"Suman Gupta","@id":"https:\/\/dbtut.com\/#\/schema\/person\/bf1017d2e692d73bbb246c8eb2f46072"},"headline":"Apply Patch on Oracle DB Home","datePublished":"2019-09-27T18:03:29+00:00","dateModified":"2021-09-19T11:09:56+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/09\/27\/apply-patch-on-oracle-db-home\/"},"wordCount":514,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/09\/27\/apply-patch-on-oracle-db-home\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/09\/Ads\u0131z-9.png","articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/09\/27\/apply-patch-on-oracle-db-home\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/09\/27\/apply-patch-on-oracle-db-home\/","url":"https:\/\/dbtut.com\/index.php\/2019\/09\/27\/apply-patch-on-oracle-db-home\/","name":"Apply Patch on Oracle DB Home - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/09\/27\/apply-patch-on-oracle-db-home\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/09\/27\/apply-patch-on-oracle-db-home\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/09\/Ads\u0131z-9.png","datePublished":"2019-09-27T18:03:29+00:00","dateModified":"2021-09-19T11:09:56+00:00","description":"This document shows how to apply patch on Oracle home \/ databases.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/09\/27\/apply-patch-on-oracle-db-home\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/09\/27\/apply-patch-on-oracle-db-home\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/09\/27\/apply-patch-on-oracle-db-home\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/09\/Ads\u0131z-9.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/09\/Ads\u0131z-9.png","width":600,"height":389},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/09\/27\/apply-patch-on-oracle-db-home\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Apply Patch on Oracle DB Home"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/bf1017d2e692d73bbb246c8eb2f46072","name":"Suman Gupta","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/92f0f52997f1aa29f5dfb09b19fb1f6b4f0064f2ef4364f649273ab4be74b57a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/92f0f52997f1aa29f5dfb09b19fb1f6b4f0064f2ef4364f649273ab4be74b57a?s=96&d=mm&r=g","caption":"Suman Gupta"},"description":"Database Administrator with\u00a010+\u00a0years of diverse experience in database design and administration, data modeling, data warehousing, Enterprise Systems Architecture along with team management. Extensive technical skills and advanced understanding of Oracle (9i to 18c), Postgres EDB (10.8, 11.3) administration in sector Finance, Distribution, Energy &amp; Utilities Strong collaborator and team player with excellent communication skills and expertise in analytic problem-solving.","sameAs":["https:\/\/www.linkedin.com\/in\/suman-gupta-75247012\/"],"url":"https:\/\/dbtut.com\/index.php\/author\/sumangupta\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/13107","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/474"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=13107"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/13107\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/13151"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=13107"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=13107"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=13107"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}