![]() 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ġ0. ![]() 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.Ĩ. Unlock the OLAPSYS account, then connect as OLAPSYS, then run %ORACLE_HOME%/cwmlite/admin/postamd.sql. run %ORACLE_HOME%/rdbms/admin/utlrp.sqlħ. Startup the listener (lsnrct start), and the database (using 'startup migrate)Ħ. You may need to set sga_max_size to a figure that is greater than these two amounts to fit this in. 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. Run the 9.2.0.4 patch installer, install the new OUI, then install the 9.2.0.4 patch.ģ. ![]() Make sure you exit out of SQL*Plus before moving on.Ģ. 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. 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.Ģ. ![]() 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. Some points to note (not all steps listed here BTW)ġ. I've managed to install the AWM + requisite patches now, and it's converting a relational star schema as I speak. ![]()
0 Comments
Leave a Reply. |