Oracle 12C as CMS repository

[Former Member]

Hi Experts,

We are in the process of installing BI 4.1 SP5 using Oracle 12 C (64bit) as our CMS System Database

Can anyone with DBA exposure help me out with the following requisites and let me know if its acceptable for installation.

- Character sets used (Default AL32UTF8)
- Blocksize (Default 8k)
- Tablespaces
- Users and roles

Please share any information for the above points.

Regards,

Diego

[former_member182967 · Accepted solution]

Hello Diego,

Firstly, Oracle 12c is supported for BI 4.1 SP5 according to note 1980473 - Is Oracle 12c supported for XI3.1/ BO 4.0/4.1 ?

The default settings for character set and blocksize are OK.

Create two tablespaces for CMS and audit.

To be easier, I grant connect, resouce to the users used by BI platform. However, I suggest you grant the permission according to the installation guide.

Regards,

Ning TOng