cancel
Showing results for 
Search instead for 
Did you mean: 

BOBI 4.1 SP2 installation with oracle database

former_member552170
Participant
0 Kudos

HI,

   In our landscape, we have installed installed oracle 11g and we have installed BOBI 4.1 with oracle system user ID for both CMS and Audit. We havent create any separate schema for CMS and Audit database. It was runninf fine but recently we are facing lot of DB issues. Can anyone please help me to conclude whether we have to create separate schema for CMS and Audit or  we can user oracle system user ID for both CMS and Audit. Anyone help is highly appreciated. And also please suggest if we use the oracle system ID, whether we will face any issues in future or impacts.....

Thanking you in anticipation.

Obinna

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Hi,

technically it works with the System schemas. But this is far away from Best Practices!

The standart is to create a own User/Schema for the CMS DB and the Audit DB. The User gets full privileges on his Schema and you are fine.

Regards

-Seb.

former_member552170
Participant
0 Kudos

Hi Sebastian,

  Thanks for your inputs...

Obinna

former_member552170
Participant
0 Kudos

Hi Sebastian,

   I just wanna clarify one more thing. If i use system ID for both CMS and Audit.. What kind of impacts willl be there.. Please give your valuable inputs in this..

Thanking you in anticipation

Obinna

Answers (0)