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.