Hi, i am going to upgrade from BOE XI R2 to BOE XI 3.1. When doing the upgrade, can i point the CMS and Audit to the same database (CMS database)?
I want the Audit tables to be in the CMS table. Is there any prolem if i done so?
Thanks!
ylai20 
(BOB member since 2008-05-21)
Nope.
I am eager to find the reason behind this.
zack 
(BOB member since 2007-08-02)
it is technicaly possible and I already saw it but I don’t advise you to do such thing. In fact, audit database can increase quickly and, in the other hand, if you perform heavy queries on audit database you run the risk to break the tablespace. it is not a big deal on a dedicated audit database but if your cms and audit database are hosted on the same schema, your bo platform will be out of order…
bernard timbal 
(BOB member since 2003-05-26)
As im going to upgrade BOE XI R2 to BOE XI 3.1, my management is decided to put the CMS and Audit into one database as what we are currently practice.
Understand from management if need to have another database for audit, we need to pay for it as we are using oracle database.
ylai20 
(BOB member since 2008-05-21)
Depending on how important these reporting information and audit information are to the company, your management might be shooting themselves in the foot by going cheap on Oracle licenses. It is a very bad idea to commingle the system database and audit database.
You can assign different tablespaces for the system database and audit database to avoid the resource conflict. But I can guarantee you to run into a lot of problem down the road.
substring (BOB member since 2004-01-16)
Ask your dba and he will become crazy. Audit database must be setup (parameters) to store transactional data whereas the CMS database must be setup to store BLOB data …
Agreed, plus I would imagine your non-standard way of doing things would invalidate your support contract, as well as make BOXI perform badly - food for thought?
Mak 1 
(BOB member since 2005-01-06)
any easy way to split the two into seperate databases if they were originally installed to the same db?
Chris Pohl 
(BOB member since 2002-06-18)
Chris, maybe I’m simplifiying things here, but wouldn’t it be as simple as moving the audit tables, to the new database, then repointing the connection on the server, then changing the path in the CMC?
Mak 1 
(BOB member since 2005-01-06)
Sounds right … Alternately, i think you can keep both in the same database … but use different tablespaces after the install
Chris Pohl (BOB member since 2002-06-18)
Possibly, but I think that for performance reasons you would be better splitting them out…:).
Mak 1 (BOB member since 2005-01-06)