Picture of a Telescope

No new Add-On Features for Oracle Databases on Your Own Hardware

Besides the base functionality of the Oracle Database—which is steadily extended, of course—, Oracle offers add-of features against extra payment (options and management packs). Since release 12.2 no new add-on feature was added that can be used on your own hardware.

You can use the JavaScript snippet from below to check the availability of add-on features on third party hardware. Just open the respective license information page (see below) and copy the JavaScript snippet into the JavaScript console of your browser.

Find the license information of the latest releases here: 12.2, 18c, 19c.

var th = document.querySelectorAll('thead>tr');

var ownhardware = ['SE2', 'EE', 'PE'];

var available = 0, notavailable = 0;

for (var i = 0; i < th.length; i++) {
 if (th[i].children.item(0).textContent == 'Feature / Option / Pack') {
  var ownhardwareidx = [];
  for (var c = 0; c < th[i].children.length; c++) {
   if (ownhardware.includes(th[i].children.item(c).textContent)) {
    ownhardwareidx.push(c);
   }
  }
  var row = th[i].parentNode.parentNode.querySelectorAll('tbody>tr');

  for (var r = 0; r < row.length; r++) {
   // per Feature / Option / Pack
   var td = row[r].getElementsByTagName('td');

   var y = 0, n = 0;
   for (var t = 0; t < ownhardwareidx.length; t++) {
    if (td[ownhardwareidx[t]].innerText == 'N') {
     n++
    } else if (td[ownhardwareidx[t]].innerText == 'Y') {
     y++
    }
   }

   if (n == ownhardwareidx.length) {
    row[r].style.background = 'red';
    notavailable++;
   } else if (y > 0) {
    row[r].style.background = null;
    available++;
    // to output a list of features available on own hardware
    //console.log(td[0].innerText);
   }
  }
 }
}

console.log("Out of "
       + (available + notavailable)
       + " checked Features / Options / Packs, "
       + notavailable + " ("
       + (notavailable*100.0/(available + notavailable)).toFixed(1) + "%) are not in " 
       + ownhardware.join() + " (marked red)");

Connect with Markus Winand

Markus Winand on LinkedInMarkus Winand on XINGMarkus Winand on Twitter