{"id":1798,"date":"2018-08-15T09:55:38","date_gmt":"2018-08-15T07:55:38","guid":{"rendered":"http:\/\/www.ludovicocaldara.net\/dba\/?p=1798"},"modified":"2020-08-18T16:07:33","modified_gmt":"2020-08-18T14:07:33","slug":"oracle-database-18c-and-version-numbers","status":"publish","type":"post","link":"https:\/\/www.ludovicocaldara.net\/dba\/oracle-database-18c-and-version-numbers\/","title":{"rendered":"Oracle Database 18c and version numbers"},"content":{"rendered":"<p>The <strong>Oracle New Release Model<\/strong>\u00a0is very young, and thus suffers of some small inconsistencies in the release naming.<br \/>\nOracle already announced that 18c was a renaming of what was intended to be 12.2.0.2 in the original roadmap.<br \/>\nI though that 19c would have been 12.2.0.3, but now I have some doubts when looking at the local inventory contents.<\/p>\n<p>I am consistently using my functions lsoh and setoh, as described in my posts:<\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"FzFAkeo6Os\"><p><a href=\"https:\/\/www.ludovicocaldara.net\/dba\/getting-oracle-homes-from-orainventory\/\">Getting the Oracle Homes in a server from the oraInventory<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;Getting the Oracle Homes in a server from the oraInventory&#8221; &#8212; DBA survival BLOG\" src=\"https:\/\/www.ludovicocaldara.net\/dba\/getting-oracle-homes-from-orainventory\/embed\/#?secret=4gaa1dUw6n#?secret=FzFAkeo6Os\" data-secret=\"FzFAkeo6Os\" width=\"584\" height=\"329\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p>and:<\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"jbNCWMcbB8\"><p><a href=\"https:\/\/www.ludovicocaldara.net\/dba\/oh-mgmt-5\/\">Oracle Home Management &#8211; part 5: Oracle Home Inventory and Naming Conventions<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;Oracle Home Management &#8211; part 5: Oracle Home Inventory and Naming Conventions&#8221; &#8212; DBA survival BLOG\" src=\"https:\/\/www.ludovicocaldara.net\/dba\/oh-mgmt-5\/embed\/#?secret=BAQSePx0Za#?secret=jbNCWMcbB8\" data-secret=\"jbNCWMcbB8\" width=\"584\" height=\"329\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p>What I do, basically, is to get the list of attached Oracle Homes from the Central Inventory, and then get some details (like version and edition) from the local inventory of each Oracle Home.<\/p>\n<p>But now that Oracle 18.3 is out, my function shows release 18.0.0.0.0 when I try to get it in the previous way.<\/p>\n<pre class=\"lang:plsql highlight:0 decode:true\"># [ oracle@server1:\/u01\/app\/grid\/crs1830 [08:53:50] [18.0.0.0.0 [GRID] SID=+ASM1] 0 ] #\r\n# lsoh\r\n\r\nHOME                   LOCATION                           VERSION      EDITION\r\n---------------------- ---------------------------------- ------------ ---------\r\nOraGI18Home1           \/u01\/app\/grid\/crs1830              18.0.0.0.0   GRID<\/pre>\n<p>The fact is that prior to 18c, the component version was showing the actual version (without patches):<\/p>\n<pre class=\"lang:plsql highlight:0 decode:true \">&lt;COMP NAME=\"oracle.rdbms\" VER=\"12.1.0.2.0\"\u00a0 [...]\u00a0 \" ACT_INST_VER=\"12.1.0.2.0\"\u00a0 [...]&gt;<\/pre>\n<p>but now, it shows the &#8220;base release&#8221; 18.0.0.0.0, whereas the ACT_INST_VER property shows the &#8220;Active&#8221; version:<\/p>\n<pre class=\"lang:plsql highlight:0 decode:true \">&lt;COMP NAME=\"oracle.rdbms\" VER=\"18.0.0.0.0\" [...] ACT_INST_VER=\"12.2.0.4.0\"[...]&gt;\r\n<\/pre>\n<p>You can see that ACT_INST_VER is 12.2.0.4.0! does it indicate that 18.3 was planned to be 12.2.0.4?<\/p>\n<p>like &#8230;<\/p>\n<p>12.2.0.2 -&gt; 18.1<\/p>\n<p>12.2.0.3 -&gt; 18.2<\/p>\n<p>12.2.0.4 -&gt; 18.3<\/p>\n<p>?<\/p>\n<p>This is in contrast with MOS Doc ID 230.1 that states that 18c was a &#8220;sort of&#8221; 12.2.0.2, so probably I get it wrong.<\/p>\n<p>My first reflex has been to search, in the local inventory, where the string 18.3.0\u00a0 was written down, but with my surprise, it is just a description, not a &#8220;real value&#8221;:<\/p>\n<pre class=\"lang:plsql highlight:0 decode:true\">&lt;ONEOFF REF_ID=\"28090523\" UNIQ_ID=\"22329768\" ROLLBACK=\"T\" XML_INV_LOC=\"oneoffs\/28090523\/\" ACT_INST_VER=\"12.2.0.4.0\" INSTALL_TIME=\"2018.Jul.18 20:06:33 CEST\"&gt;\r\n &lt;DESC&gt;Database Release Update : 18.3.0.0.180717 (28090523)&lt;\/DESC&gt;\r\n\r\n[...]\r\n\r\n# grep '18\\.3\\.0' comps.xml\r\n   &lt;DESC&gt;Database Release Update : 18.3.0.0.180717 (28090523)&lt;\/DESC&gt;\r\n   &lt;DESC&gt;OCW RELEASE UPDATE 18.3.0.0.0 (28090553)&lt;\/DESC&gt;\r\n   &lt;DESC&gt;ACFS RELEASE UPDATE 18.3.0.0.0 (28090557)&lt;\/DESC&gt;\r\n   &lt;DESC&gt;DBWLM RELEASE UPDATE 18.3.0.0.0 (28090564)&lt;\/DESC&gt;\r\n   &lt;DESC&gt;TOMCAT RELEASE UPDATE 18.3.0.0.0 (28256701)&lt;\/DESC&gt;\r\n   &lt;DESC&gt;OJVM RELEASE UPDATE: 18.3.0.0.180717 (27923415)&lt;\/DESC&gt;\r\n<\/pre>\n<p>Again, the ACT_INST_VER property reports 12.2.0.4.0.<\/p>\n<p>So, where can we extract the version we would expect (18.3.0.0.0)?<\/p>\n<p>Oracle 18c provides a new binary\u00a0<strong>oraversion<\/strong> that gives us this information:<\/p>\n<pre class=\"lang:plsql highlight:0 decode:true\"># oraversion\r\nThis program prints release version information.\r\nThese are its possible arguments:\r\n-compositeVersion: Print the full version number: a.b.c.d.e.\r\n-baseVersion: Print the base version number: a.0.0.0.0.\r\n-majorVersion: Print the major version number: a.\r\n-buildStamp: Print the date\/time associated with the build.\r\n-buildDescription: Print a description of the build.\r\n-help: Print this message.\r\n\r\n# oraversion -compositeVersion\r\n18.3.0.0.0<\/pre>\n<p>Note that 18.3.0.0.0 differs from the description:<\/p>\n<pre class=\"lang:plsql highlight:0 decode:true\">Database Release Update : 18.3.0.0.180717<\/pre>\n<p>which is, as far as I understand, just a bad way to use the old notation to give the idea of the release date of such release update.<\/p>\n<p>Also note that baseVersion has always the format &lt;MAJOR&gt;.0.0.0.0.<\/p>\n<p>In the future I expect that ACT_INST_VER will be consistent with the compositeVersion, but I cannot be sure.<\/p>\n<p>&#8212;<\/p>\n<p>Ludo<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Oracle New Release Model\u00a0is very young, and thus suffers of some small inconsistencies in the release naming. Oracle already announced that 18c was a renaming of what was intended to be 12.2.0.2 in the original roadmap. I though that &hellip; <a href=\"https:\/\/www.ludovicocaldara.net\/dba\/oracle-database-18c-and-version-numbers\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[321,326,3,308,330],"tags":[],"class_list":["post-1798","post","type-post","status-publish","format-standard","hentry","category-aced","category-oracle","category-oracledb","category-oracle-database-18c","category-oracle-inst-upg"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts\/1798","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/comments?post=1798"}],"version-history":[{"count":1,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts\/1798\/revisions"}],"predecessor-version":[{"id":1799,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts\/1798\/revisions\/1799"}],"wp:attachment":[{"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/media?parent=1798"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/categories?post=1798"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/tags?post=1798"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}