Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE : pre-create tablespace before the domain configuration when not using RCU

Received Response
2
Views
6
Comments
user5515638
user5515638 Rank 1 - Community Starter
edited Aug 13, 2024 5:23PM in Oracle Analytics Cloud and Server

We needed our tablespaces for the OBIEE schemas (eg BIPLATFORM etc) on TDE (Encrypted tablespace). Currently we configure domain without using RCU ( RCU did not work for us),  However we want to pre-build the tablespaces with encrypted feature. Will it work during - domain creation or will it fail with error that tablespaces already existis?

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    1.) Which *exact* version of OBI? Against which *exact* DB?

    2.) You can't install OBI without running the RCU or at least the RCU scripts.

    3.) What *exactly* are the steps done so far?

  • user5515638
    user5515638 Rank 1 - Community Starter

    See my response below and thanks for the prompt attention:

    1.) Which *exact* version of OBI? Against which *exact* DB?

    OBIEE  12.2.1.4.0

      DB  Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

    2.) You can't install OBI without running the RCU or at least the RCU scripts.

    using config.sh  (so yes scripts directly ) and works this is our nth domain

    3.) What *exactly* are the steps done so far

    The issue that we are trying to resolve is instead of creating tablespace using above , pre create tablespace with TDE and then run the config.sh. Currently after the domain creation we have to export/import to convert tablespaces to TDE.

  • Joel
    Joel Rank 8 - Analytics Strategist

    Do you know for a fact that OBIEE works with TDE table spaces? If you’re certain that TDE will work then see below:

    When you run the RCU, there is an option to set table spaces:

    imagepastedImage_0.gif

    You can change the default tablespace value to one that you’ve previously created.

  • user5515638
    user5515638 Rank 1 - Community Starter

    Joel,

    we will not be using RCU as above , it did not work in the past and Oracle suggested to use config.sh. But your answer still valid , we have other application on TDE so in that context should not be problem. Our question is if we pre-built the Tablespace , will the install halt since now tablespace already exist?

  • Joel
    Joel Rank 8 - Analytics Strategist

    I’m not sure why RCU doesn’t work for you. As I mentioned, in the RCU, you have the option to override/change the default tablespaces and you can select an existing tablespace if required.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    As Joel indicated, the RCU should be able to pick up your tablespaces in the wizard.