3 Replies Latest reply on Jan 10, 2016 8:52 AM by Bashar.

    Is OLAP Catalog must for E-business Database ?

    muba_zak

      Dear All,

       

      I am upgrading e-business database from 11.2.0.3 to 12.1.0.2/sun sparc 64 bit 11.2         application upgrade from 12.1.3 to 12.2.5

      I upgraded database from 11.2.0.3 to 12.1.0.2, OLAP Catalog option  de-supported in 12c(expecting result). But is it necessary for e-business?

       

      olap_catalog.PNG

      after upgraded i m keep on getting below error in alerlog, how to get ride of this error appears.

       

      Errors in file /u01/app/oracle/diag/rdbms/prod/PROD/trace/PROD_j000_4008.trc:

      ORA-12012: error on auto execute of job "BGJOBUSER"."SYMON"

      ORA-04045: errors during recompilation/revalidation of ADMUSER.P6_RPT_CONTEXT

      ORA-01031: insufficient privileges

       

      could we remove it as below to get rid the error?

       

      ORACLE_HOME/olap/admin/catnoamd.sql

       

      Thanks & Regards,

      Muba