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

user5515638

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?

[Deleted User]

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

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

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:

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

user5515638

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

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]

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