1 Reply Latest reply: Mar 26, 2013 9:35 AM by user804364 RSS

    Install OCDM in a database with OADM installed

    Allen Yang
      Hi everyone,

      I have tried to install OCDM in a database with OADM installed,a new OBIEE is well configured. but I got a lot of issued when installing such as tablespace exists, log start with:

      ***********************************************************************************************
      User altered.

      Elapsed: 00:00:00.02

      User altered.

      Elapsed: 00:00:00.01
      alter user owbsys_audit account unlock
      *
      ERROR at line 1:
      ORA-01918: user 'OWBSYS_AUDIT' does not exist


      Elapsed: 00:00:00.00

      User altered.

      Elapsed: 00:00:00.01
      grant owb_user to owb_owner
      *
      ERROR at line 1:
      ORA-01919: role 'OWB_USER' does not exist


      Elapsed: 00:00:00.00




      ....

      log end with:

      Import OCDM OLAP AW
      Build AW from template...
      begin
      *
      ERROR at line 1:
      ORA-37162: OLAP error
      ORA-33272: Analytic workspace OCDM_SYS.OCDM cannot be opened.
      ORA-37605: error during OLAP AW UPDATE
      ORA-03238: unable to extend LOB segment OCDM_SYS.SYS_LOB0000239855C00004$$
      subpartition SYS_LOB_SUBP59369 by 32 in tablespace TBS_OCDM
      XOQ-01600: OLAP DML error while executing DML "SYS.AWXML!R11_INITIALIZE_AW"
      ORA-06512: at "SYS.DBMS_CUBE", line 433
      ORA-06512: at "SYS.DBMS_CUBE", line 465
      ORA-06512: at "SYS.DBMS_CUBE", line 523
      ORA-06512: at "SYS.DBMS_CUBE", line 486
      ORA-06512: at "SYS.DBMS_CUBE", line 501
      ORA-06512: at "SYS.DBMS_CUBE", line 512
      ORA-06512: at line 4


      Elapsed: 00:01:58.76
      END Build of AW OCDM from Template
      Import addl objects...
      declare
      *
      ERROR at line 1:
      ORA-33262: Analytic workspace OCDM_SYS.OCDM does not exist.
      ORA-06512: at "SYS.DBMS_AW", line 93
      ORA-06512: at "SYS.DBMS_AW", line 122
      ORA-06512: at line 9


      Elapsed: 00:00:00.00

      User altered.


      User altered.

      *****************************************************************************************************************
      Anyone who has experience in this issue? or I should just install OCDM in a new OBIEE-configured database