{"id":2051,"date":"2015-10-30T17:00:30","date_gmt":"2015-10-30T16:00:30","guid":{"rendered":"http:\/\/www.oradba.ch\/?p=2051"},"modified":"2015-10-30T16:20:16","modified_gmt":"2015-10-30T15:20:16","slug":"opatch-silent-and-unattended","status":"publish","type":"post","link":"https:\/\/www.oradba.ch\/wordpress\/2015\/10\/opatch-silent-and-unattended\/","title":{"rendered":"OPatch silent and unattended"},"content":{"rendered":"<p>In general I use Oracle OPatch interactively in command line mode to install patch set updates. But recently I did patch a system cloud based system, with a confusing network timeout. As expected I did get a broken pipe while executing OPatch. Ok, the system is also damn slow, which is not exactly helpful. Never mind, this was the time to look around for a stable alternative. eg. OPatch should survive potential network \/ connection lost. <\/p>\n<p>A possible solution would be using screen. Unfortunately screen is not available on the HP-UX system, which I use for this particular Critical Patch Update tests. Therefore I&#8217;ve searched in MOS and found two helpful notes about using <code class=\"EnlighterJSRAW\" data-enlighter-language=\"bash\">opatch<\/code> in silent mode. <\/p>\n<p>First step is to create a response file for OCM to make sure you do not get ask about security updates:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"bash\">\r\noracle@hpux01:~\/ [CPU11204] $cdh\/OPatch\/ocm\/bin\/emocmrsp -no_banner -output $cdl\/oradba\/rsp\/ocm_opatch.rsp\r\nProvide your email address to be informed of security issues, install and\r\ninitiate Oracle Configuration Manager. Easier for you if you use your My\r\nOracle Support Email address\/User Name.\r\nVisit http:\/\/www.oracle.com\/support\/policies.html for details.\r\nEmail address\/User Name: \r\n\r\nYou have not provided an email address for notification of security issues.\r\nDo you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:  y\r\nThe OCM configuration response file (\/u00\/app\/oracle\/local\/dba\/..\/oradba\/rsp\/ocm_opatch.rsp) was successfully created.\r\n<\/pre>\n<p>Second step is to run <code class=\"EnlighterJSRAW\" data-enlighter-language=\"bash\">opatch<\/code> in silent mode with the response file for the OCM.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"bash\">\r\noracle@hpux01:~\/ [CPU11204] cd \/u00\/app\/oracle\/software\/ora\/CPU_2015_10\/21352635\/\r\noracle@hpux01:\/u00\/app\/oracle\/software\/ora\/CPU_2015_10\/21352635\/ [CPU11204] $cdh\/OPatch\/opatch apply -silent -ocmrf $cdl\/oradba\/rsp\/ocm_opatch.rsp\r\n\r\n<\/pre>\n<p>Alternatively run <code class=\"EnlighterJSRAW\" data-enlighter-language=\"bash\">opatch apply<\/code> with nohup. <\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"bash\">\r\noracle@hpux01:~\/ [CPU11204] cd \/u00\/app\/oracle\/software\/ora\/CPU_2015_10\/21352635\/\r\noracle@hpux01:\/u00\/app\/oracle\/software\/ora\/CPU_2015_10\/21352635\/ [CPU11204] nohup $cdh\/OPatch\/opatch apply -silent -ocmrf $cdl\/oradba\/rsp\/ocm_opatch.rsp &amp;\r\n\r\noracle@hpux01:\/u00\/app\/oracle\/software\/ora\/CPU_2015_10\/21352635\/ [CPU11204] tail -f nohup.out \r\n\r\nOracle Home       : \/u00\/app\/oracle\/product\/11.2.0.4\r\nCentral Inventory : \/u00\/app\/oraInventory\r\n   from           : \/u00\/app\/oracle\/product\/11.2.0.4\/oraInst.loc\r\nOPatch version    : 11.2.0.3.12\r\nOUI version       : 11.2.0.4.0\r\nLog file location : \/u00\/app\/oracle\/product\/11.2.0.4\/cfgtoollogs\/opatch\/opatch2015-10-30_08-51-15AM_1.log\r\n\r\nVerifying environment and performing prerequisite checks...\r\n\r\n<\/pre>\n<p>At the time of analog and ISDN connections I was used to network interruptions. But today, where one is everywhere online&#8230; I guess I must use <code class=\"EnlighterJSRAW\" data-enlighter-language=\"bash\">nohup<\/code> and <code class=\"EnlighterJSRAW\" data-enlighter-language=\"bash\">screen<\/code> more often again. \ud83d\ude42<\/p>\n<h3>References<\/h3>\n<ul>\n<li><a href=\"https:\/\/kb.iu.edu\/d\/acuy\">In Unix, what is screen, and how do I use it?<\/a><\/li>\n<li>How To Run OPatch In Silent Mode? [<em><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?id=749787.1\" target=\"_blank\">749787.1<\/a><\/em>]<\/li>\n<li>How to Create an OCM Response file to Apply a Patch in Silent Mode &#8211; opatch silent [<em><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?id=966023.1\" target=\"_blank\">966023.1<\/a><\/em>]<\/li>\n<li>Master Note For OPatch [<em><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?id=293369.1\" target=\"_blank\">293369.1<\/a><\/em>]<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>In general I use Oracle OPatch interactively in command line mode to install patch set updates. But recently I did patch a system cloud based system, with a confusing network timeout. As expected I did get a broken pipe while executing OPatch. Ok, the system is also damn slow, which is not exactly helpful. Never [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"OPatch silent and unattended #trivadis","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[46,114,116],"tags":[151,143],"class_list":["post-2051","post","type-post","status-publish","format-standard","hentry","category-cpu","category-psu-2","category-spu","tag-opatch","tag-personal-notes"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p1aErb-x5","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":1418,"url":"https:\/\/www.oradba.ch\/wordpress\/2013\/09\/update-ora-00600-kpdbmodadminpasswdinroot-not-cdb-when-changing-password-of-default-account\/","url_meta":{"origin":2051,"position":0},"title":"Update: ORA-00600 [kpdbModAdminPasswdInRoot: not CDB] when changing password of default account","author":"Stefan","date":"9. September 2013","format":false,"excerpt":"As discussed in my post ORA-00600 [kpdbModAdminPasswdInRoot: not CDB] when changing password of default account There is an unpublished bug 16901482 which cause an ORA-00600 when trying to set a new password for an Oracle default account like DBSNMP, DIP or OUTLN. On september 4th Oracle released the one-off patch\u2026","rel":"","context":"In &quot;12cR1&quot;","block_context":{"text":"12cR1","link":"https:\/\/www.oradba.ch\/wordpress\/category\/oracle-database\/12cr1\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1367,"url":"https:\/\/www.oradba.ch\/wordpress\/2013\/08\/how-to-find-latest-oracle-database-patchset\/","url_meta":{"origin":2051,"position":1},"title":"How to find latest oracle database patchset","author":"Stefan","date":"5. August 2013","format":false,"excerpt":"It is sometimes a bit of a hassle, to have the latest patch name or number on hand, when you need them. Ok, you may search on My Oracle Support and save it as custom search. But it may happen that the search is inaccurate and the required patch is\u2026","rel":"","context":"In &quot;11gR2&quot;","block_context":{"text":"11gR2","link":"https:\/\/www.oradba.ch\/wordpress\/category\/oracle-database\/11gr2\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":13118,"url":"https:\/\/www.oradba.ch\/wordpress\/2023\/04\/great-i-found-my-audit-policies-again\/","url_meta":{"origin":2051,"position":2},"title":"Great, I found my Audit Policies again","author":"Stefan","date":"4. April 2023","format":false,"excerpt":"A while ago I wrote a blog post about issues with some Oracle Unified Audit Policies see Help I lost my brand new Unified Audit Policy? In the meantime, the whole thing no longer looks so tragic. The problem is an official bug for which Oracle has already released a\u2026","rel":"","context":"In &quot;Audit&quot;","block_context":{"text":"Audit","link":"https:\/\/www.oradba.ch\/wordpress\/category\/audit\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1255,"url":"https:\/\/www.oradba.ch\/wordpress\/2013\/07\/oracle-released-cpu-psu-july-2013\/","url_meta":{"origin":2051,"position":3},"title":"Oracle released CPU \/ PSU July 2013","author":"Stefan","date":"23. July 2013","format":false,"excerpt":"About a week ago Oracle has released the July Critical Patch Updates. Overall this CPU contains 89 new security fixes across several Oracle products like Database Server, MySQL Server, Sun Product Suite, WebLogic Server etc. For Oracle Database Server it does contain 6 fixes, but none of them is for\u2026","rel":"","context":"In &quot;10gR2&quot;","block_context":{"text":"10gR2","link":"https:\/\/www.oradba.ch\/wordpress\/category\/oracle-database\/10gr2\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":11271,"url":"https:\/\/www.oradba.ch\/wordpress\/2022\/08\/easily-mitigate-log4j-vulnerability-in-oracle-unified-directory\/","url_meta":{"origin":2051,"position":4},"title":"Easily mitigate log4j vulnerability in Oracle Unified Directory","author":"Stefan","date":"26. August 2022","format":false,"excerpt":"In December 2021, the critical vulnerability in Apache Log4j (CVE-2021-44228) was disclosed. With a CVSS rating of 10 out of 10, this vulnerability was or is extremely critical. Especially since Log4j is used relatively widely. Despite a great effort, many applications could only be corrected with a delay. Thus, it\u2026","rel":"","context":"In &quot;Bundle Patch&quot;","block_context":{"text":"Bundle Patch","link":"https:\/\/www.oradba.ch\/wordpress\/category\/patches\/bp\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/Screenshot-2022-08-25-at-09.00.17.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/Screenshot-2022-08-25-at-09.00.17.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/Screenshot-2022-08-25-at-09.00.17.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/Screenshot-2022-08-25-at-09.00.17.png?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/Screenshot-2022-08-25-at-09.00.17.png?resize=1050%2C600&ssl=1 3x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/Screenshot-2022-08-25-at-09.00.17.png?resize=1400%2C800&ssl=1 4x"},"classes":[]},{"id":14785,"url":"https:\/\/www.oradba.ch\/wordpress\/2024\/01\/latest-critical-patch-updates-from-oracle-january-2024\/","url_meta":{"origin":2051,"position":5},"title":"Latest Critical Patch Updates from Oracle &#8211; January 2024","author":"Stefan","date":"18. January 2024","format":false,"excerpt":"On January 18, Oracle unveiled its first quarterly Critical Patch Update Advisory of the year. This advisory, a pivotal resource for Oracle users, details an array of 389 new security patches across various Oracle product families. This update includes several high-severity vulnerabilities, notably those that can be exploited remotely over\u2026","rel":"","context":"In &quot;19c&quot;","block_context":{"text":"19c","link":"https:\/\/www.oradba.ch\/wordpress\/category\/oracle-database\/19c\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/CPU-Patch-Jan-2024.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/CPU-Patch-Jan-2024.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/CPU-Patch-Jan-2024.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/CPU-Patch-Jan-2024.png?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/www.oradba.ch\/wordpress\/wp-content\/uploads\/CPU-Patch-Jan-2024.png?resize=1050%2C600&ssl=1 3x"},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/posts\/2051","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/comments?post=2051"}],"version-history":[{"count":2,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/posts\/2051\/revisions"}],"predecessor-version":[{"id":2056,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/posts\/2051\/revisions\/2056"}],"wp:attachment":[{"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/media?parent=2051"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/categories?post=2051"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oradba.ch\/wordpress\/wp-json\/wp\/v2\/tags?post=2051"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}