{"id":209,"date":"2015-08-03T01:32:54","date_gmt":"2015-08-03T04:32:54","guid":{"rendered":"http:\/\/www.fernandosimon.com\/blog\/?p=209"},"modified":"2019-09-13T20:25:50","modified_gmt":"2019-09-13T23:25:50","slug":"aplicando-patch-no-exadata","status":"publish","type":"post","link":"https:\/\/www.fernandosimon.com\/blog\/aplicando-patch-no-exadata\/","title":{"rendered":"Aplicando Patch no Exadata"},"content":{"rendered":"<p style=\"text-align: justify;\">O appliance Oracle Exadata \u00e9 uma das tecnologias mais modernas para banco de dados Oracle, a uni\u00e3o de Hardware e Software. Mas este software precisa ser atualizado de tempos em tempos voc\u00ea precisa aplicar o patch.<\/p>\n<p style=\"text-align: justify;\">O time de Engineered Systems da Oracle disponibiliza os updates para serem aplicadas em toda a pilha: do Exadata Software aos bin\u00e1rios do banco de dados. \u00c9 tarefa do DMA acompanhar isso e deixar seu ambiente atualizado, muitas vezes (aqui no Brasil) estes updates s\u00e3o aplicados pelo time de ACS da Oracle, mas nada impede que voc\u00ea mesmo fa\u00e7a isso.<\/p>\n<p style=\"text-align: justify;\">Este \u00e9 o foco destes artigos, vou mostrar como proceder com um update completo do Oracle Exadata: Exadata Software, Infiniband, Linux, Update do Grid 11GR2 para 12C e Aplica\u00e7\u00e3o de BP nos bin\u00e1rios do banco. Eu j\u00e1 descrevi sobre isso no meu blog a uns 3 anos atr\u00e1s (<a href=\"http:\/\/www.fernandosimon.com\/blog\/atualizando-o-exadata-dbnode\/\" target=\"_blank\" rel=\"noopener noreferrer\">aqui<\/a> e <a href=\"http:\/\/www.fernandosimon.com\/blog\/atualizando-o-exadata-storage-node\/\" target=\"_blank\" rel=\"noopener noreferrer\">aqui<\/a>), mas muita coisa mudou desde aquela \u00e9poca.<\/p>\n<h4 style=\"text-align: justify;\"><strong>Planejamento<\/strong><\/h4>\n<p style=\"text-align: justify;\">De qualquer forma, antes de come\u00e7ar qualquer update (Oracle Exadata ou n\u00e3o) temos que planejar, verificar qual a vers\u00e3o que estamos e qual queremos aplicar.<\/p>\n<p style=\"text-align: justify;\">Para o Oracle Exadata temos uma nota que contempla tudo isso e que \u00e9 o in\u00edcio de qualquer update: <strong>Exadata Database Machine and Exadata Storage Server Supported Versions (Doc ID <\/strong><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocContentDisplay?id=888828.1\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>888828.1<\/strong><\/a><strong>)<\/strong>. Nesta nota est\u00e3o todas as informa\u00e7\u00f5es importantes como documenta\u00e7\u00e3o, as vers\u00f5es existentes, vers\u00f5es recomendadas e matriz de compatibilidade entre Exadata Software e bin\u00e1rios do banco.<\/p>\n<p style=\"text-align: justify;\">Ent\u00e3o, o primeiro passo \u00e9 o planejamento, ler e compreender esta nota, principalmente com as vers\u00f5es dispon\u00edveis e quais ser\u00e3o aplicadas. Outro ponto fundamental do planejamento \u00e9 conhecer o seu ambiente, no meu caso a imagem que tenho aqui \u00e9 a 11.2.3.3.0.<\/p>\n<p style=\"text-align: justify;\">No t\u00f3pico Exadata Storage Server 12c da nota identificamos que a \u00faltima vers\u00e3o e que ser\u00e1 aplicada aqui \u00e9 a 12.1.2.1.2 (image version 12.1.2.1.2.150617.1) e composta pelos seguintes patches e docs:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Patch 20748218 &#8211; Storage server e InfiniBand<\/li>\n<li>Patch 21151982 &#8211; Database server (para quem n\u00e3o utiliza OVM)<\/li>\n<li>Readme &#8211; Note 2014306.1<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Na mesma nota temos as vers\u00f5es do Grid Infrastructure e dos bancos de dados que s\u00e3o compat\u00edveis com as imagens do Exadata. Como o meu planejamento inclui atualizar tudo para a \u00faltima vers\u00e3o estes tamb\u00e9m ser\u00e3o atualizados.<\/p>\n<p style=\"text-align: justify;\">Atrav\u00e9s da nota os seguintes updates ser\u00e3o realizados (e demonstrados aqui nestes artigos):<\/p>\n<ul style=\"text-align: justify;\">\n<li>Update da imagem 11.2.3.3.0 para a 12.1.2.1.2 do Exadata (storage e bancos)<\/li>\n<li>Upgrade da vers\u00e3o 11.2.0.4 BP 6 do Grid para a vers\u00e3o 12.1.0.2 BP 9<\/li>\n<li>Update da vers\u00e3o 11.2.0.4 BP6 do banco de dados para a vers\u00e3o 11.2.0.4 BP 16<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Pensando no appliance Oracle Exadata e na rela\u00e7\u00e3o entre seus componentes o primeiro ponto a ser atualizado \u00e9 a pr\u00f3pria imagem do Exadata Storage Server (Linux, Exadata Software). Depois temos switchs Infiniband. Na sequ\u00eancia temos o update dos Database Servers e seus componentes (Grid e os bin\u00e1rios do banco de dados).<\/p>\n<p style=\"text-align: justify;\">Antes de iniciar o update precisamos montar o plano de atualiza\u00e7\u00e3o, qual a ordem de instala\u00e7\u00e3o dos patches. Isso s\u00f3 pode ser feito lendo todos os Readmes dos patches que vamos aplicar. Lendo o Readme do Patch 20748218 e Patch 21151982 descobrimos que existem dois m\u00e9todos poss\u00edveis para atualizar o Database Server.<\/p>\n<p style=\"text-align: justify;\">O primeiro \u00e9 atrav\u00e9s da imagem ISO que acompanha o Patch 21151982 e o segundo \u00e9 atrav\u00e9s da cria\u00e7\u00e3o do reposit\u00f3rio Exadata local. Este \u00faltimo m\u00e9todo \u00e9 o que utilizarei aqui, ele tem algumas vantagens que descreverei em detalhes depois mas \u00e9 importante entender como funciona. Basicamente voc\u00ea cria um reposit\u00f3rio local com os rpm\u2019s que ser\u00e3o aplicados (os mesmo presentes na ISO). Infelizmente esta cria\u00e7\u00e3o pode demorar um pouco e por isso ser\u00e1 o primeiro procedimento a ser realizado.<\/p>\n<p style=\"text-align: justify;\">Atrav\u00e9s da leitura de todas as notas do MOS envolvidas e de todos os Readmes dos patches aplicados o seguinte plano foi criado:<\/p>\n<ol style=\"text-align: justify;\">\n<li>Cria\u00e7\u00e3o do reposit\u00f3rio Exadata para Database Server<\/li>\n<li>Update do Storage Server e Switch Infiniband<\/li>\n<li>Update do Database Server<\/li>\n<li>Upgrade do GRID para 12C e Instala\u00e7\u00e3o dos bin\u00e1rios 12C<\/li>\n<li>Update dos bin\u00e1rios 11.2.0.4 para o BP16<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">Abaixo a descri\u00e7\u00e3o detalhas de cada uma destas etapas acima listadas.<\/p>\n<ul>\n<li style=\"text-align: justify;\"><strong><a href=\"http:\/\/www.fernandosimon.com\/blog\/repositorio-para-o-patch-do-exadata\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cria\u00e7\u00e3o do Reposit\u00f3rio Exadata para patch do Database Server<\/a><\/strong><\/li>\n<li style=\"text-align: justify;\"><strong><a href=\"http:\/\/www.fernandosimon.com\/blog\/patch-storage-server-e-ibs\/\" target=\"_blank\" rel=\"noopener noreferrer\">Patch&nbsp;do Storage Server e Swicth Infiniband<\/a><\/strong><\/li>\n<li style=\"text-align: justify;\"><strong>Patch&nbsp;do Database Server (artigo ainda n\u00e3o dispon\u00edvel)<\/strong><\/li>\n<li style=\"text-align: justify;\"><strong>Upgrade do GRID para 12C e Instala\u00e7\u00e3o dos bin\u00e1rios 12C <strong>(artigo ainda n\u00e3o dispon\u00edvel)<\/strong><\/strong><\/li>\n<li style=\"text-align: justify;\"><strong>Update dos bin\u00e1rios 11GR2 para BP16 <strong>(artigo ainda n\u00e3o dispon\u00edvel)<\/strong><\/strong><\/li>\n<\/ul>\n<p>A \u00faltima atualiza\u00e7\u00e3o deste artigo foi em 03\/08\/2015.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>O appliance Oracle Exadata \u00e9 uma das tecnologias mais modernas para banco de dados Oracle, a uni\u00e3o de Hardware e Software. Mas este software precisa ser atualizado de tempos em tempos voc\u00ea precisa aplicar o patch. O time de Engineered Systems da Oracle disponibiliza os updates para serem aplicadas em toda a pilha: do Exadata [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":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":"","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":[30,29,6,5,9,14,12],"tags":[],"class_list":["post-209","post","type-post","status-publish","format-standard","hentry","category-banco-de-dados","category-database","category-exadata","category-oracle","category-storage-server","category-update","category-upgrade"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Aplicando Patch no Exadata - Fernando Simon<\/title>\n<meta name=\"description\" content=\"Aplicando patch no Oracle Exadata, do Storage Server aos bin\u00e1rios do banco de dados.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.fernandosimon.com\/blog\/aplicando-patch-no-exadata\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Aplicando Patch no Exadata - Fernando Simon\" \/>\n<meta property=\"og:description\" content=\"Aplicando patch no Oracle Exadata, do Storage Server aos bin\u00e1rios do banco de dados.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fernandosimon.com\/blog\/aplicando-patch-no-exadata\/\" \/>\n<meta property=\"og:site_name\" content=\"Fernando Simon\" \/>\n<meta property=\"article:published_time\" content=\"2015-08-03T04:32:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-09-13T23:25:50+00:00\" \/>\n<meta name=\"author\" content=\"Simon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Simon\" \/>\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:\/\/www.fernandosimon.com\/blog\/aplicando-patch-no-exadata\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/aplicando-patch-no-exadata\/\"},\"author\":{\"name\":\"Simon\",\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9\"},\"headline\":\"Aplicando Patch no Exadata\",\"datePublished\":\"2015-08-03T04:32:54+00:00\",\"dateModified\":\"2019-09-13T23:25:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/aplicando-patch-no-exadata\/\"},\"wordCount\":772,\"commentCount\":3,\"articleSection\":[\"Banco de Dados\",\"Database\",\"Exadata\",\"Oracle\",\"Storage Server\",\"Update\",\"Upgrade\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.fernandosimon.com\/blog\/aplicando-patch-no-exadata\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/aplicando-patch-no-exadata\/\",\"url\":\"https:\/\/www.fernandosimon.com\/blog\/aplicando-patch-no-exadata\/\",\"name\":\"Aplicando Patch no Exadata - Fernando Simon\",\"isPartOf\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/#website\"},\"datePublished\":\"2015-08-03T04:32:54+00:00\",\"dateModified\":\"2019-09-13T23:25:50+00:00\",\"author\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9\"},\"description\":\"Aplicando patch no Oracle Exadata, do Storage Server aos bin\u00e1rios do banco de dados.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/aplicando-patch-no-exadata\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.fernandosimon.com\/blog\/aplicando-patch-no-exadata\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/aplicando-patch-no-exadata\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.fernandosimon.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Aplicando Patch no Exadata\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/#website\",\"url\":\"https:\/\/www.fernandosimon.com\/blog\/\",\"name\":\"Fernando Simon\",\"description\":\"Have you hugged your backup today?\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.fernandosimon.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9\",\"name\":\"Simon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a3dbc48de62fffb1829befb4a588d789ec6dc5e05977afabb3407a5f37a16482?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a3dbc48de62fffb1829befb4a588d789ec6dc5e05977afabb3407a5f37a16482?s=96&d=mm&r=g\",\"caption\":\"Simon\"},\"sameAs\":[\"http:\/\/www.fernandosimon.com\"],\"url\":\"https:\/\/www.fernandosimon.com\/blog\/author\/simon\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Aplicando Patch no Exadata - Fernando Simon","description":"Aplicando patch no Oracle Exadata, do Storage Server aos bin\u00e1rios do banco de dados.","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:\/\/www.fernandosimon.com\/blog\/aplicando-patch-no-exadata\/","og_locale":"en_US","og_type":"article","og_title":"Aplicando Patch no Exadata - Fernando Simon","og_description":"Aplicando patch no Oracle Exadata, do Storage Server aos bin\u00e1rios do banco de dados.","og_url":"https:\/\/www.fernandosimon.com\/blog\/aplicando-patch-no-exadata\/","og_site_name":"Fernando Simon","article_published_time":"2015-08-03T04:32:54+00:00","article_modified_time":"2019-09-13T23:25:50+00:00","author":"Simon","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Simon","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fernandosimon.com\/blog\/aplicando-patch-no-exadata\/#article","isPartOf":{"@id":"https:\/\/www.fernandosimon.com\/blog\/aplicando-patch-no-exadata\/"},"author":{"name":"Simon","@id":"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9"},"headline":"Aplicando Patch no Exadata","datePublished":"2015-08-03T04:32:54+00:00","dateModified":"2019-09-13T23:25:50+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fernandosimon.com\/blog\/aplicando-patch-no-exadata\/"},"wordCount":772,"commentCount":3,"articleSection":["Banco de Dados","Database","Exadata","Oracle","Storage Server","Update","Upgrade"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fernandosimon.com\/blog\/aplicando-patch-no-exadata\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fernandosimon.com\/blog\/aplicando-patch-no-exadata\/","url":"https:\/\/www.fernandosimon.com\/blog\/aplicando-patch-no-exadata\/","name":"Aplicando Patch no Exadata - Fernando Simon","isPartOf":{"@id":"https:\/\/www.fernandosimon.com\/blog\/#website"},"datePublished":"2015-08-03T04:32:54+00:00","dateModified":"2019-09-13T23:25:50+00:00","author":{"@id":"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9"},"description":"Aplicando patch no Oracle Exadata, do Storage Server aos bin\u00e1rios do banco de dados.","breadcrumb":{"@id":"https:\/\/www.fernandosimon.com\/blog\/aplicando-patch-no-exadata\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fernandosimon.com\/blog\/aplicando-patch-no-exadata\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.fernandosimon.com\/blog\/aplicando-patch-no-exadata\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fernandosimon.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Aplicando Patch no Exadata"}]},{"@type":"WebSite","@id":"https:\/\/www.fernandosimon.com\/blog\/#website","url":"https:\/\/www.fernandosimon.com\/blog\/","name":"Fernando Simon","description":"Have you hugged your backup today?","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.fernandosimon.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9","name":"Simon","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a3dbc48de62fffb1829befb4a588d789ec6dc5e05977afabb3407a5f37a16482?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a3dbc48de62fffb1829befb4a588d789ec6dc5e05977afabb3407a5f37a16482?s=96&d=mm&r=g","caption":"Simon"},"sameAs":["http:\/\/www.fernandosimon.com"],"url":"https:\/\/www.fernandosimon.com\/blog\/author\/simon\/"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5ofTp-3n","_links":{"self":[{"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/posts\/209","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/comments?post=209"}],"version-history":[{"count":0,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/posts\/209\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/media?parent=209"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/categories?post=209"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/tags?post=209"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}