Installing the Analytic Workspace Manager
I've managed to install the AWM + requisite patches now, and it's converting a relational star schema as I speak. Some points to note (not all steps listed here BTW)
1. I first applied the 9.2.0.4 patch to an existing 9.2.0.1 database installation, which was installed alongside 9iAS R2, 9iDS, OWB9.2 and 9.0.4, and Express Server 6.3.4. The installer failed at an early stage with a 'resource bundle' error, and therefore I removed all Oracle software from my laptop, reinstalled just the Database 9.0.2.0.1, and started again from there.
2. Follow the steps in the readme to drop the XMLCONCAT function, shutdown the database, and stop all services (including the database) in the ORACLE_HOME. Make sure you exit out of SQL*Plus before moving on.
2. Run the 9.2.0.4 patch installer, install the new OUI, then install the 9.2.0.4 patch.
3. Find the init.ora file (in my case named init.ora.962003152553 and located in C:/9ir2/admin/markr/pfile), and amend the file setting java_pool_size and shared_pool_size > 150M. You may need to set sga_max_size to a figure that is greater than these two amounts to fit this in. The figures I used were;
sga_max_size=500000000
java_pool_size=160554432
large_pool_size=8388608
shared_pool_size=160331648
4. Startup the listener (lsnrct start), and the database (using 'startup migrate)
5. set spool on, then run catpatch.sql
6. run @ %ORACLE_HOME%/rdbms/admin/utlrp.sql
7. Unlock the OLAPSYS account, then connect as OLAPSYS, then run @ %ORACLE_HOME%/cwmlite/admin/postamd.sql. When I ran this script, I got an error saying that a column I tried to add ('IS_AGGREGATABLE') already existed, but the rest of the script ran ok.
8. I then unzipped the 9.2.0.4.1 patchset
9. Run the One-Off patch that comes with the 9.2.0.4.1 patchset (in the /oneoffs directory) before you install the main 9.2.0.4.1 patch
10. Once this has installed, start up the OUI that comes with Oracle 9i and select the products.jar file that comes with the patch. Install the patch as normal.
11. cd $ORACLE_HOME/olap/admin, then connect as sqlplus "/ as sysdba", then run @olapu92041.sql
12. Now the patches have all installed, unzip the awm920.zip file to a directory, run the installer, and the AWM will appear under the '%ORACLE_HOME%/Integrated Management Tools' start menu entry.
I'm now in the process of trying to create an analytic workspace. I've submitted the COST_CUBE from the SH schema that comes with 9iR2 for conversion, although from what I understand this will not convert properly, and it has to be replaced by the BIBDEMO schema that comes with the BI Beans 9.0.3 download (http://otn.oracle.com/software/products/bib/download.html). The conversion's at 55% at the moment, so i'll see how it goes, and report back.