10g Product Availability, and Recommended 9i Products For Discoverer Development

I had the following response to a recent posting on comp.databases.olap regarding Oracle 10g OLAP New Features;

"thanks for the links concerning Oracle 10g. Is the software for 10g already available (evaluation, beta ...)? I can't find downloads in technet. Do I need to have a "10g DB" or can I run a 10g Discoverer on 9i release 2 DB?

Additional question: If I want to install OWB, IAS on 9iR2 DB and would like to use the "olap engine" by querying with discoverer, what installations are required? Is IAS 902 Enterprise Edition the best way to "incorparate" discoverer or shall I install the discoverer in administrator version via Oracle9iDS Release 2 (9.0.2). Does it make sense to wait/search for 9.0.3 or 9.0.4?"

None of the 10g server software (database, app server) is publicly available yet. Beta copies of the database have been made available to Oracle Partners and ISVs, for Linux, Solaris and HP-UX, but there is no 'public beta' planned as far as I know. I don't know about 10g AS; but the lack of any mention of it on the newsgroups suggests it's not at this stage yet (although of course it could just turn out to be iAS 9.0.4 rebadged, which would suggest that the first release of 10gAS will not contain any significantly different versions of Disco, Reports etc - but we'll just have to wait and see). According to Oracle, the first full release of 10g Database will be later this year, although I would expect this to be a Unix-only release at this stage.

With regards to Discoverer; there's two parts to this here; the server side of things, and the developer tools. For the server side, you need 9i Enterprise Edition Database (for the ROLAP functionality, materialized views and so on) and 9iAS Enterprise Edition App Server (for Portal, OID, Discoverer). The database version you start with should be 9.0.2.0.1, patch it up to 9.0.2.0.4.1, and install the analytic workspace manager. The app server version should be 9.0.2, and patch it up to 9.0.3.

You then need 9iDS to give you Discoverer Administrator; you'll probably need to patch this to match the EUL version that you've reached when patching 9iAS. In addition, download separately OWB 9.2 and use this instead of the OWB version that comes with 9iDS. If you install this lot, you'll get;

  • 9i Database, with the 9.0.2.0.4.1 patchset, and Analytic Workspace Manager, to migrate relational OLAP cubes to analytic workspaces, and automatically create the SQL Views and Disco Business Areas.
  • 9iAS, with Disco patched up to the correct version
  • 9iDS, with Disco Admin patched up as above
  • OWB9.2, which can create ROLAP cubes, or MOLAP cubes now that you've patched the database up to 9.0.2.0.4.1

With regard to Discoverer 10g working against Oracle 9i - it's too early to tell. The product has only been recently announced by Oracle and they're careful not to call it 'Discoverer 10g' or give a release date. We'll have to wait and see what gets announced over the next few months.