oracle big data sql compatibility matrix




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 x86­64

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.

One­Off Database Patch Required?

One­Off 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 x86­64
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 x86­64
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 x86­64
Jan 2016 DB Bundle patch
12.1.0.2.160119 Proactive DB Bundle patch

Yes

Patch# 22778199

3.0

4.4

Linux x86­64
12.1.0.2.160419 #22899531 (12.1.0.2 with April 2016 Proactive BP

No

N/A

3.0

4.4

Linux x86­64
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.ctrl­state=18syjlmj4_647&id=2119369.1 1/3

3/17/2017 Document 2119369.1

2.0

4.4, 4.3, 4.2

Linux x86­64
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 x86­64 12.1.0.2.13 (12.1.0.2 with BP13)

Yes

Patch# 21419192

2.0

4.4, 4.3, 4.2

Linux x86­64 12.1.0.2.10 (12.1.0.2 with BP10)

Yes

Patch# 21419192

1.1

4.2, 4.1

Linux x86­64
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 x86­64 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

One­off BDA SW Patch Required?

No

One­Off 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.ctrl­state=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
Oracle Linux 6.4 and up with UEK 2

Note: Currently neither RHEL 7 nor OL 7 are supported.

Big Data SQL Compatibility Matrix, Version: 1.0, Updated: 07­March­17

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.ctrl­state=18syjlmj4_647&id=2119369.1 3/3

Author: admin