{"id":121,"date":"2009-04-30T10:31:00","date_gmt":"2009-04-30T08:31:00","guid":{"rendered":"http:\/\/antynet.pl\/index.php\/2009\/04\/30\/oracle-patch\/"},"modified":"2010-08-24T22:40:26","modified_gmt":"2010-08-24T20:40:26","slug":"oracle-patch","status":"publish","type":"post","link":"https:\/\/www.antynet.pl\/index.php\/2009\/04\/30\/oracle-patch\/","title":{"rendered":"ORACLE PATCH"},"content":{"rendered":"<div style=\"text-align: left;\"><\/div>\n<p><a href=\"https:\/\/support.oracle.com\/CSP\/main\/article?cmd=show&amp;type=NOT&amp;id=224346.1\" target=\"_blank\" rel=\"nofollow noopener\">download opatch<\/a><\/p>\n<ol>\n<li>download patch<\/li>\n<li>unpack<\/li>\n<li>shutdown instance<\/li>\n<li>read README file<\/li>\n<li>change directory to unpacked archive<\/li>\n<li>opatch apply<\/li>\n<li>run Post Installation Instructions<\/li>\n<\/ol>\n<p><\/p>\n<div><span style=\"font-weight: bold;\">check patches allready install:<\/span><\/p>\n<pre class=\"code\">opatch lsinventory<br \/>opatch lsinventory -detail<\/pre>\n<p><b>check patch:<\/b><\/p>\n<pre class=\"code\">opatch query -all \/[path_to_patch_directory]<\/pre>\n<p><b>check opatch options<\/b><\/p>\n<pre class=\"code\">opatch -help [option]<\/pre>\n<p><span style=\"font-weight: bold;\">logs:<\/span><br \/>[ORACLE_HOME]\/cfgtoollogs\/opatch<br \/>[ORACLE_HOME]\/cfgtoollogs\/opatch\/opatch_history.txt<br \/><span style=\"font-weight: bold;\">rollback:<\/span><\/p>\n<pre class=\"code\">opach rollback -id [nr_patcha]<\/pre>\n<p><span style=\"font-weight: bold;\">check invalid objects:<\/span><\/p>\n<pre class=\"code\">SELECT object_name FROM dba_objects WHERE status = 'INVALID';<\/pre>\n<p><span style=\"font-weight: bold;\">compile all invalid objects:<\/span><br \/>[ORACLE_HOME]\/rdbms\/admin\/utlrp.sql<br \/>which launch script [ORACLE_HOME]\/rdbms\/admin\/utlprp.sql z parametrem=0<br \/>&#8211; parametr=0 &#8211; run parallel with CPU_COUNT<br \/>&#8211; parametr=1 &#8211; run in one process<br \/>&#8211; parametr=N &#8211; number of parallel run<\/div>\n","protected":false},"excerpt":{"rendered":"<p>download opatch download patch unpack shutdown instance read README file change directory to unpacked archive opatch apply run Post Installation Instructions check patches allready install: opatch lsinventoryopatch lsinventory -detail check patch: opatch query -all \/[path_to_patch_directory] check opatch options opatch -help [option] logs:[ORACLE_HOME]\/cfgtoollogs\/opatch[ORACLE_HOME]\/cfgtoollogs\/opatch\/opatch_history.txtrollback: opach rollback -id [nr_patcha] check invalid objects: SELECT object_name FROM dba_objects WHERE status [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[80],"tags":[38],"class_list":["post-121","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-oracle-patch"],"_links":{"self":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/121","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/comments?post=121"}],"version-history":[{"count":1,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/121\/revisions"}],"predecessor-version":[{"id":192,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/121\/revisions\/192"}],"wp:attachment":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/media?parent=121"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/categories?post=121"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/tags?post=121"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}