{"id":2064,"date":"2013-12-11T22:36:38","date_gmt":"2013-12-12T01:36:38","guid":{"rendered":"http:\/\/www.juniovitor.com\/?p=2064"},"modified":"2019-06-11T09:51:10","modified_gmt":"2019-06-11T12:51:10","slug":"consulta-versao-level-patch-oracle-nivel-de-patch-ambiente-oracle","status":"publish","type":"post","link":"https:\/\/www.juniovitor.com\/?p=2064","title":{"rendered":"Consulta Vers\u00e3o, N\u00edvel de Patch (Level Patch) Ambiente Oracle"},"content":{"rendered":"

Fala amigos, tudo bem?<\/p>\n

Quer saber vers\u00e3o, o n\u00edvel de patch (patch level) do Oracle EBS que est\u00e1 trabalhando, seguem algumas dicas:<\/p>\n

1) Consulta N\u00edvel de Patches (Patch LeveL)<\/strong> via SSH\/Unix:
\nopatch lsinventory<\/code><\/p>\n

2) Consulta dados de Patches<\/strong> via SQL:
\nselect * from registry$history;<\/code><\/p>\n

3) Consulta dados de Vers\u00e3o<\/strong> via SQL:
\nselect * from v$version;<\/code><\/p>\n

4) Consulta dados da Inst\u00e2ncia<\/strong> via SQL:
\nselect * from v$instance;<\/code><\/p>\n

5) Consulta Release<\/strong> Oracle EBS via SQL:
\nSelect release_name, applications_system_name, aru_release_name from FND_PRODUCT_GROUPS;
\n<\/code><\/p>\n

Tem alguma d\u00favida sobre a nomenclatura da vers\u00e3o? Para entender a nomenclatura de vers\u00e3o usada pelo Oracle, verifique o seguinte exemplo de um servidor Oracle Database “Release 10.1.0.1.0”:<\/p>\n

Versionamento Oracle<\/figcaption><\/figure>\n

> Major Database Release Number
\n – \u00c9 o primeiro d\u00edgito (Identificador geral da vers\u00e3o). Ele representa a vers\u00e3o principal do software, que cont\u00e9m novas funcionalidades significativas. <\/p>\n

> Database Maintenance Release Number
\n – Segundo d\u00edgito que representa um n\u00edvel de release de manuten\u00e7\u00e3o. Alguns novos recursos tamb\u00e9m podem ser inclu\u00eddos. <\/p>\n

> Application Server Release Number
\n – O terceiro d\u00edgito reflete o n\u00edvel de release do Oracle Application Server (OracleAS). <\/p>\n

> Component-Specific Release Number
\n – O quarto d\u00edgito identifica um n\u00edvel de libera\u00e7\u00e3o espec\u00edfico para um componente. Componentes diferentes podem ter n\u00fameros diferentes nessa posi\u00e7\u00e3o, dependendo, por exemplo, de conjuntos de patches de componentes ou vers\u00f5es intermedi\u00e1rias. <\/p>\n

> Platform-Specific Release Number
\n – Geralmente este \u00e9 um conjunto de patches. Quando diferentes plataformas exigem o conjunto de patches equivalente, esse d\u00edgito ser\u00e1 o mesmo entre as plataformas afetadas.<\/p>\n

Fonte: Oracle.com<\/em><\/p>\n

Abra\u00e7o,
\nJunio Vitor<\/p>\n","protected":false},"excerpt":{"rendered":"

Fala amigos, tudo bem? Quer saber vers\u00e3o, o n\u00edvel de patch (patch level) do Oracle EBS que est\u00e1 trabalhando, seguem algumas dicas: […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[840,843,836,837,622,841,842,838,844,839,845,835],"class_list":["post-2064","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-como-saber-a-versao-do-oracle","tag-consulta-versao-oracle","tag-level-patch","tag-nivel-de-patch-ambiente","tag-oracle","tag-oracle-level-patch","tag-oracle-patch-level","tag-oracle-version","tag-sql-oracle-version","tag-sql-versao-oracle","tag-ssh-oracle-version","tag-versao"],"_links":{"self":[{"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=\/wp\/v2\/posts\/2064"}],"collection":[{"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2064"}],"version-history":[{"count":12,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=\/wp\/v2\/posts\/2064\/revisions"}],"predecessor-version":[{"id":2077,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=\/wp\/v2\/posts\/2064\/revisions\/2077"}],"wp:attachment":[{"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2064"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2064"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2064"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}