3/17/2017 Document 2119369.1
Oracle Big Data SQL Master Compatibility Matrix (Doc ID 2119369.1) In this Document
Purpose Scope Details
Big Data SQL Compatibility Matrix BDS BDA Database Versions and Patches Big Data SQL Compatibility Matrix BDS and BDA Software Versions and Patches Big Data SQL Compatibility Matrix BDS and Supported Hadoop Distributions
Big Data SQL Compatibility Matrix BDS and Supported Operating Systems
References
APPLIES TO:
Oracle Big Data SQL Version 1.0 and later Linux x8664
PURPOSE
To provide an Oracle Big Data SQL Compatibility Matrix
SCOPE
System administrators, Big Data Administrator
DETAILS
Big Data SQL Compatibility Matrix BDS BDA Database Versions and Patches
Big Data SQL version
Big Data Appliance software Version
Oracle Database Version + Proactive BP
version * Unless noted, BP listed below is the minimum required for the Big Data SQL version. More recent BPs are also supported for that version.
OneOff Database Patch Required?
OneOff Patch Details
3.1
BDA Only: 4.7, 4.6, 4.5, 4.4, 4.3
Oracle SuperCluster (SPARC, Solaris). 12.1.0.2.170117
(12.1.0.2 with Jan 2017 Proactive BP)
Yes
Patch # 25639263
3.1
4.7, 4.6, 4.5, 4.4, 4.3
Linux x8664
12.1.0.2.170117 #24968615 (12.1.0.2 with Jan 2017 Proactive BP)
Yes
Patch # 25256170
3.0.1
4.7, 4.6, 4.5, 4.3
Linux x8664
April 2016 DB Bundle patch
12.1.0.2.160419 Proactive DB Bundle patch or later
No
N/A
3.0.1
4.7, 4.6, 4.5, 4.3
Linux x8664
Jan 2016 DB Bundle patch
12.1.0.2.160119 Proactive DB Bundle patch
Yes
Patch# 22778199
3.0
4.4
Linux x8664
12.1.0.2.160419 #22899531 (12.1.0.2 with April 2016 Proactive BP
No
N/A
3.0
4.4
Linux x8664
12.1.0.2.160119
(12.1.0.2 with January 2016 Bundle Patch)
Yes
Patch# 22778199
https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrlstate=18syjlmj4_647&id=2119369.1 1/3
3/17/2017 Document 2119369.1
2.0
4.4, 4.3, 4.2
Linux x8664
12.1.0.2.160119
(12.1.0.2 with January 2016 Bundle Patch)
No
N/A
2.0
4.4, 4.3, 4.2
Linux x8664 12.1.0.2.13 (12.1.0.2 with BP13)
Yes
Patch# 21419192
2.0
4.4, 4.3, 4.2
Linux x8664 12.1.0.2.10 (12.1.0.2 with BP10)
Yes
Patch# 21419192
1.1
4.2, 4.1
Linux x8664
12.1.0.2.6 or later (12.1.0.2 with BP6 or later)
No
N/A
1.1
4.2, 4.1
Linux x8664 12.1.0.2.4 (12.1.0.2 with BP6)
Yes
Patch# 20310880
* To use Big Data SQL 3.1 on the Big Data Appliance, uninstall the Big Data SQL version supplied with the BDA release and then install Big Data SQL 3.1 using the common installer. See documentation for details.
* To use Big Data SQL, you need to apply the “Database Proactive Bundle Patch” as shown in the table above. The “Proactive Bundle Patch” is different than the “Patch Set Update”. The “Patch Set Update” is not sufficient. See Note:1962125.1 “Overview of Database Patch Delivery Methods” for information on Database Proactive Bundle Patches and Patch Set Updates.
Big Data SQL Compatibility Matrix BDS and BDA Software Versions and Patches
Big Data Appliance Software Version
Big Data SQL Version
4.6
3.0.1
Big Data SQL Compatibility Matrix BDS and Supported Hadoop Distributions
Oneoff BDA SW Patch Required?
No
OneOff Patch Details
4.7
3.0.1
No
No
N/A
4.5
3.0.1
No
N/A
4.4
3.0
Yes
Patch# 22911748 (OL6)
Patch# 22911768 (OL5)
4.4
2.0
No
N/A
4.3
3.0.1
Yes
Patch# 23185273 (OL6)
Patch# 23271792 (OL5)
4.3
2.0
No
N/A
4.2
2.0
Yes
Patch# 21434344 (OL6)
Patch# 21897232 (OL5)
4.2
1.1
No
N/A
4.1
1.1
Yes
Patch# 20541030 (OL6)
Patch# 20541033 (OL5)
https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrlstate=18syjlmj4_647&id=2119369.1 2/3
3/17/2017 Document 2119369.1
Big Data SQL Version
Hadoop Distribution
Hadoop Distribution Version
3.0, 3.0.1, 3.1
Cloudera CDH
3.0, 3.0.1,3.1
Hortonworks HDP
* Note: Big Data SQL with Oracle SuperCluster is available with BDA only
Big Data SQL Compatibility Matrix BDS and Supported Operating Systems
5.5 and later
2.3 and later
2.0
Cloudera CDH
5.0 and later
1.1
Cloudera CDH
5.0 and later
Big Data SQL Version |
Hadoop Hardware Platform |
Linux Distribution and Version |
3.0, 3.0.1, 3.1 |
Big Data Appliance |
Oracle Linux 5.11 |
3.0, 3.0.1, 3.1 |
Big Data Appliance |
Oracle Linux 6.7 |
3.0, 3.0.1, 3.1 |
General X86 Hardware |
Red Hat Enterprise Linux 6.4 and up |
Note: Currently neither RHEL 7 nor OL 7 are supported.
Big Data SQL Compatibility Matrix, Version: 1.0, Updated: 07March17
Didn’t find what you are looking for?
Note: Copy to Hadoop, a feature of Oracle Big Data SQL, works with Oracle Database 11.2.0.4 and above on any OS platform supported by the database.
https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrlstate=18syjlmj4_647&id=2119369.1 3/3