BOBJ on Oracle Best Practices - Schema vs New DB
My company is installing Business Objects 4.1 as part of an overall (new) SAP project. I am the Oracle DB for the project and new to the SAP/Business Objects world.
My question is how do most people separate the different pieces of the overall Business Objects install on the database level? I was thinking we would have one database with different schemas for Audit, CMS, BODS and Information Steward. I've heard from our integrator that some companies will have a separate database for each.
Not knowing the system that well, adding separate databases seems unnecessary. Where I would have some additional hoops to jump through if a restore was needed for just one of the schemas, it seems better then adding the additional DBs.
Hopefully this makes sense.
I agree with Mani's suggestion as recommended approach. However, It would depend from org to org.
and if insisted to continue with one database then you would have to scale ORA DB accordingly considering trnsactional nature of each service highlighted (CMS, AUDIT, BODS)
Since, these are transactional you would need to customize database while setup (DB buffer, Undo segments, Shared pool)
I'm assuming you would be using 11g R2 on Linux Operating system(mostly preferred). Hence,
how is Oracle DB deployed(single instance architecture or RAC) on which you would create DB schemas for above services?
In either of the above case you should setup db user for BODS and CMS to conect to the ORA database in "Dedicated server connection" mode and not in "Shared server connection" mode. Hence, no latency provided the Server platform are in the same network or on same server. Audit could connect in "Shared server conection" mode.
In ORA RAC deployment i don't forsee any issues as your transactions could be benefited by "Streams" feature incase of ORA instance failure.
Starting in Oracle 11g Release you may be benefited from automatic PGA memory management can be implemented using
• PGA_AGGREGATE_TARGET initialization parameter for PGA
• MEMORY_TARGET initialization parameter combined total memory for SGA & PGA
I may go on and on. Hope i was able to put some light here. Please refer Performance Optimization in BODS for more information regarding BODS that might also assist you.