The Oracle Data Miner client must be compatible with the Oracle Data Miner repository in Oracle Database.
When the versions are incompatible, Oracle Data Miner displays an error message that provides information to assist you in upgrading either the client or the repository.
For example, if a newer client attempts to connect to an older repository, then the error shown in Figure A-1 is displayed.
Figure A-1 Older Oracle Data Miner Repository Error
If an older client attempts to connect to a new repository, then the error shown in Figure A-2 is displayed.
Figure A-2 Newer Oracle Data Miner Repository Error
When you evaluate how to address the errors shown in Figure A-1 and Figure A-2, you must take several version numbers into account. The version number combinations that are supported in each release are listed in Table A-1. The version numbers shown in the columns of the table are described as follows:
SQL Developer — This is the information that is displayed when you select the SQL Developer Help menu, in the About tab.
Oracle Data Miner Extension — This is the Oracle Data Miner version that is displayed when you select the SQL Developer Help menu, then the Extensions tab.
Figure A-4 About SQL Developer Extensions
Oracle Data Miner Repository Version — You can find the repository version by running the query shown in Determining the Status and Version of the Repository.
Oracle Data Miner XML Schema Version — This is the version of the XML schema used by the Oracle Data Miner workflows in the repository. This number is shown when you export or import workflows.
Note:
The Oracle SQL Developer version and the Oracle Data Miner Extension version uniquely identify the client. The Oracle Data Miner Repository Version uniquely identifies the repository.
Table A-1 SQL Developer Oracle Data Miner Extension and Oracle Data Miner Repository Compatibility
SQL Developer | Data Miner Extension | Data Miner Repository Version | Data Miner XML Schema Version | Release Type (Full or Path) | Limitations |
---|---|---|---|---|---|
SQL Developer 3.0 EA4 3.0.03 Build MAIN-03.97 |
11.2.0.1.9.96 |
11.2.0.1.9 |
11.2.0.1.9 |
EA4 (only EA release to include Data Miner) |
Does not work on 11.2.0.3 and later |
SQL Developer 3.0 RTM 3.0.04 Build MAIN-04.34 |
11.2.0.1.10.109 |
11.2.0.1.10 |
11.2.0.1.9 |
RTM (released 03/30/11) |
Does not work on 11.2.0.3 or later |
SQL Developer 3.0 |
11.2.0.2.04.38 |
11.2.0.1.12 |
112.0.1.9 |
Patch (Dev internal only) |
Does not work on 11.2.0.3 or later |
SQL Developer 3.0 |
11.2.0.2.04.39 |
11.2.0.1.13 |
11.2.0.1.9 |
Patch (internal) |
Does not work on 11.2.0.3 or later |
SQL Developer 3.0 |
11.2.0.2.04.40 |
11.2.0.1.13 |
11.2.0.1.9 |
Patch (external) link to patch |
Does not work on 11.2.0.3 or later |
SQL Developer 3.1 EA1 |
11.2.1.1.xx.xx |
11.2.1.1.1 |
11.2.1.1.1 |
EA1 candidate (not released) |
None |
SQL Developer 3.1 EA1 3.1.05 Build MAIN-05.97 |
11.2.1.1.05.97 |
11.2.1.1.2 |
11.2.1.1.1 |
EA1 (released 10/10/11) |
None |
SQL Developer 3.1 |
11.2.1.1.06.44 |
11.2.1.1.3 |
11.2.1.1.1 |
EA2 (released 11/15/11) |
None |
SQL Developer 3.1 |
11.2.1.06.82 |
11.2.1.1.4 |
11.2.1.1.1 |
EA3 (released 12/21/11) |
None |
SQL Developer 3.1 RTM 3.1.07 Build MAIN-07.42 |
11.2.1.1.07.42 |
11.2.1.1.5 |
11.2.1.1.1 |
RTM (released 02/07/12) |
None |
SQL Developer 3.2 RTM Version 3.2.09 Build MAIN-09-18 |
11.2.1.1.09.18 |
11.2.1.1.6 |
11.2.1.1.1 |
RTM (released 08/20/12) |
None |
SQL Developer 3.2.1 RTM Version 3.2.10.09 Build MAIN-09-57 |
11.2.1.1.09.57 |
11.2.1.1.6 |
11.2.1.1.1 |
RTM (released 09/24/12). For Data Miner, there no were changes made between 3.2 and 3.2.1. |
None |
SQL Developer 3.2.2 RTM Version 3.2.20.09 Build MAIN-09.87 |
11.2.1.1.09.87 |
11.2.1.6 |
11.2.1.1.1 |
RTM (released 11/01/12). For Data Miner, there were no changes made between 3.2 and 3.2.2. |
None |
SQL Developer 4.0 EA1 (was 3.3) Version 4.0.0.12 Build MAIN-12.27 |
11.2.2.1.12.27 |
11.2.2.1.1 |
11.2.2.1.1 |
EA1 (released 07/11/13) |
None |
SQL Developer 4.0 EA2 Version 4.0.0.12 Build MAIN-12.84 |
12.2.0.12.84 |
12.1.0.1.1 |
12.1.0.1.1 |
EA2 (released 09/13/13) |
None |
SQL Developer 4.0 EA3 Version 4.0.0.13 Build MAIN-13.30 |
12.2.0.13.30 |
12.1.0.1.2 |
12.1.0.1.2 |
EA3 (released 11/05/13) |
Migration from prior versions is broken. Workaround documented in OTN posting. |
SQL Developer 4.0 RTM Version 4.0.0.13 Build MAIN-13.80 |
12.2.0.13.80 |
12.1.0.1.3 |
12.1.0.1.3 |
RTM (12/12/13) |
None |
SQL Developer 4.0.1 RTM Version 4.0.1.14 Build MAIN14.48 |
12.2.0.14.48 |
12.1.0.1.4 |
12.1.0.1.4 |
RTM (02/25/14) |
Data Miner fixes and some minor enhancements |
SQL Developer 4.0.2 Version 4.0.2.15.21 Build 15.21 |
12.2.0.15.21 |
12.1.0.1.5 |
12.1.0.1.4 |
RTM (05/06/14) |
Only critical Data Miner fixes were back ported. There was a change to PL/SQL code, so the repository version is changed. The XMLschema was not changed, so the XML workflow version is unchanged. This will allow users to import workflows between 4.0.1 and 4.0.2 with no issues. |
SQL Developer 4.0.3 Version 4.0.3.16 Build MAIN-16.84 |
12.2.0.16.84 |
12.1.0.1.5 |
12.1.0.1.4 |
RTM (09/16/14) |
Changes have been made to Data Miner in the 4.0.3 release, but they do not require a server-side change, so the repository and workflow version numbers remain the same. |
SQL Developer 4.1 EA1 Version 4.1.0.17 Build MAIN-17.29 |
12.2.0.17.29 |
12.1.0.2.1 |
12.1.0.2.1 |
EA1 (12/09/14) |
None |
SQL Developer 4.1 EA2 Version 4.1.0.18 Build MAIN-18.37 |
12.2.0.18.37 |
12.1.0.2.2 |
12.1.0.2.2 |
EA2 (03/09/15) |
None |
SQL Developer 4.1 RTM Version 4.1.0.19 Build MAIN-19.07 |
12.2.0.19.07 |
12.1.0.2.3 |
12.1.0.2.3 |
RTM (05/04/15) |
Not allowed to be installed on Oracle Database 12.2. |
SQL Developer 4.1.1 RTM Version 4.1.1.19 Build MAIN-19.59 | 12.2.0.19.59 | 12.1.0.2.3 | 12.1.0.2.3 | RTM
(05/29/15) |
Patch Release included minor Data Miner UI bugs. No Repository upgrade required from 4.1 to 4.1.1. |
SQL Developer 4.1.2 RTM Version 4.1.2.20 Build MAIN-20.64 | 12.2.0.20.64 | 12.1.0.2.4 | 12.1.0.2.3 | RTM
(10/23/15) |
No changes in Oracle Data Miner since Oracle Data Miner 4.1.1 Extension Patch Release. |
SQL Developer 4.1.3 Version 4.1.3.20 Build MAIN-20.78 | 12.2.0.20.78 | 12.1.0.2.5 | 12.1.0.2.3 | RTM
(12/22/15) |
No changes in Oracle Data Miner since Oracle Data Miner Patch Release 4.1.2.20. |
SQL Developer 4.1.4 Version 4.1.4.21 Build Build MAIN-21.20 | 12.2.0.21.20 | 12.1.0.2.6 | 12.1.0.2.3 | RTM
(8/16) |
Bug fixes only. Repository upgrade required. Available only through the Oracle Database Installation and not through Oracle SQL Developer OTN site. |
SQL Developer 4.1.5 Version 4.1.5.21 Build MAIN-21.78 | 12.2.0.21.78 | 12.1.0.2.6 | 12.1.0.2.3 | RTM
(9/16/16) |
Bug fixes only. No repository upgrade required from Oracle Data Miner 4.1.4. But repository upgrade is required from Oracle Data Miner 4.1.3. |
SQL Developer 4.2 EA1 Version 14.2.0.16.260 Build 16.260.1303 | 12.2.1.16.260.1303 | 12.2.0.0.0 | 12.2.0.0.0 |
Released (9/17/16) |
Supports upcoming Oracle Database main release features. Repository upgrade required. |
SQL Developer 4.2 EA2 Version 4.2.0.16.356 Build 16.356.1154 | 12.2.1.16.356.1154 | 12.2.0.0.1 | 12.2.0.0.1 | Released
(12/21/16) |
Includes improved Data Mining Workflow Status Polling performance, and bug fixes pertaining to Oracle Data Miner 4.2 features. |
SQL Developer 4.2 RTM Version 4.2.0.17.089 Build 17.089.1709 | 12.2.1.17.089.1709 | 12.2.0.0.2 | 12.2.0.0.1 | RTM
(4/12/17) |
Supports Oracle Database 12.2 features. |
SQL Developer 17.2 RTM Version 17.2.0.178 Build 178.1847 | 17.2.0.178.1847 | 12.2.0.0.2 | 12.2.0.0.1 | RTM
(7/11) |
No migration required from prior release. Contains fix for demo data installation script. |
SQL Developer 17.3 RTX Version x Build x | 17.x.x.xxx.xxxx | 12.2.0.0.3 | 12.2.0.0.1 | RTM (9/30) | Contains fix for querying Database product version for 18.x. Requires Repository upgrade. |