#  Oracle OLAP patch 7497678 is intended for Linux 64 Bit Operating
#  Systems. This patch is to be applied to the 10.2.0.4.0 release only. 
#
#  NOTE:  This patch will interfer with the OLAP A patch, 7195088,
#         and therefore, OPatch will need to roll it back before applying
#         this patch.
#  This patch is a merge of 7195088 + 6742924 + 7513395.
#
#  WARNING: Failure to carefully read and understand these
#  requirements may result in your applying a patch that can cause
#  your Oracle Server to malfunction, including interruption of
#  service and/or loss of data.
#
#  NEW STARTING WITH 10.2.0.1
#  You will need to use the version of OPatch located in your Oracle_Home
#   directory.  
#
#  The patch set script will backup all relevant files and copy new
#  code files to your system.  There is a deinstallation procedure
#  should you need to back out the patch.
#
#
#  Requirements:
#
#  - Your system configuration (Oracle Server version and patch
#    level) must exactly match those in the bug database entry.
#    If you have any other patches applied to your 10g Oracle
#    product, check with Support to ensure that this patch will not
#    overwrite any previous patches.
#
#  - You must have Perl 5.00503 (5.6 or later recommended) installed
#    under the ORACLE_HOME, or elsewhere within the host environment.
#    Refer to the following link for details on Perl:
#    http://metalink.oracle.com/metalink/plsql/shodoc?db=NOT&id=189489.1
#
#  - The ORACLE_HOME environment variable must be set before running
#    the patch install or deinstall script.
#
#  - Make sure that all instances running under the ORACLE_HOME being
#    patched are cleanly shutdown before installing or deinstalling
#    this patch. Also ensure that the tool used to terminate the
#    instance(s) has been exited cleanly.
#
#
#  If you do NOT meet these requirements, or are not certain that you
#  meet these requirements, please log an iTAR requesting assistance
#  with this patch and Support will make a determination about whether
#  you should apply this patch.
#
#
#---------------------------------------------------------------------
#  Interim Patch : 7497678
#---------------------------------------------------------------------
#
#  DATE: October 26, 2008 
#  ---------------------------
#  Platform Patch for : Linux 64 Bit Operating Systems  
#  Product Version #  : 10.2.0.4.0
#  Product Patched    : OLAP
#
#  Bugs Fixed in this Patch:
#  -------------------------
#
#  Bug 6414616    DBMS_AW.ADVISE_SPARSITY yields ORA-1405
#  Bug 6195891    Error during AW update MULTI
#  Bug 6607486    Can't create AW using Data Vault
#  Bug 6372848    Compressed composite fixes
#  Bug 6822995    Slow query performance
#  Bug 6822672    Ampersand-subst expression is NA
#  Bug 6687129    Limitmap missing or not a string literal
#  Bug 6655657    Parallel refresh using DBMS_CUBE.BUILD fails
#  Bug 6355282    ORA-7445 [KGHFREMPTY()+133][Access Violation]
#  Bug 6489332    ORA-29532 JAVA.LANG.OUTOFMEMORYERR
#  Bug 6789923    JAVA.LANG.OUTOFMEMORYERR when attaching a modified AW
#  Bug 6454468    The full cube LOAD/AGGREGATION fails with ORA-0600
#  Bug 7005671    xsbaClose01 when importing a 4.5 eif file
#  Bug 7140644    SEGV in command parsing caused by reading past end of string
#  Bug 7039080    OUT OF MEMORY during DIMSHOW of a large compressed composite
#  Bug 6695247    DBMS_ODM.CREATEDIMOWB/DBMS_ODM.CREATEFACTOWB DO NOT HAVE ANY LINE BREAKS
#  added on 10/22
#  Bug 6742924    ORA-07445: EXCEPTION ENCOUNTERED: CORE DUMP [LNXNUCOPTG()+2929]
#
#
#  Patch Installation Instructions:
#  --------------------------------
#  To apply the patch, unzip the PSE container file:
#
#    > unzip pe7497678.zip
#
# 
#  Server Patch Instructions:
#  --------------------------------
#
#  Set the ORACLE_HOME environment variable to the oracle home in which
#  your Oracle Server is installed.
#
#  For example,
#
#          > setenv ORACLE_HOME /product/10.2.0/Db_1
#
#
#  Shut down all ORACLE Services, this ensures no one is connected to the instance
#   and could be accessing these files.
#
#
#  Set your current directory to the directory where the patch is
#  located:
#
#    > cd 7497678
#
#  Enter the following command:
#
#    > <path to Oracle_Home>/OPatch/opatch apply
#
#  Startup the Oracle Services.
#  > sqlplus '/ as sysdba'
#  > spool post_install.log
#  > @?/olap/admin/apsrelod.sql
#  > @?/olap/admin/xoqrelod.sql

#  Connect as olapsys user
#  > conn olapsys/<pw>
#  > @?/olap/admin/olapodm.plb
#  > spool off
# Check the spool file for errors.
#
#
#  Patch Deinstallation Instructions:
#  ----------------------------------
#  Make sure that all Oracle instances are cleanly shut down.
#
#  Set the ORACLE_HOME environment variable to the oracle home from which
#  you wish to rollback the patch.
#
#  Set your current directory to the directory where the patch is
#  located:
#
#    > cd 7497678
#
#  Enter the following command:
#
#    > <Path to Oracle_home>/OPatch/opatch rollback -id 7497678
#
#  Startup the ORACLE Services.
#  > sqlplus '/ as sysdba'
#  > spool rollback_olap.log 
#  > @?/olap/admin/apsrelod.sql
#  > @?/olap/admin/xoqrelod.sql
#  > spool off
#
#



















