Is there a way to clone Dimensions CM database to make an upgrade to 2009R2?

lwetzelcm's picture
lwetzelcm asked on March 13, 2012 - 2:12pm | Replies (2).

I work in a shop where cloning of databases, etc. is new.

The operations Mgr. wants to make a clone of the Dimensions CM database and application and have me test an upgrade (from 2009R1 to 2009R2) using these clones. I've been told that this upgrade is necessary so that Dimensions will be compatible with the Oracle 11g migration that is about to take place.

Has anyone had any experience with this? If so, what did it take to make it successful?

(I received info from Serena Support suggesting that we could use the clone of Dimensions but would need to export the base database and create a new base database on a clean Oracle instance but, that was shot down by my OPS area.)

2 Answers

bglangston's picture

I'm missing something.
It appears to me that the Serena folks are suggesting the mechanics of how to do it...not really an alternative way to do it.

How would you make a clone of the base database if not by exporting it (copy) the data into a new (clean) base database.

What is the objection of the OPS Mgr? How are you ging to test compatibility with 11g if you don't put it on an 11g machine? You said he was the one who wanted the clones created; so, there appears to be something missing from the information you have provided. So far it sounds like the guy who wanted to learn to swim without going into the water.

bglangston's picture

In the other thread you said:
"Sorry....the clones are created using VMWare. Does this help with some of the confusion?"

Not really.

Without knowing the OPS Mgr's objection to Serena's advice, it's difficult to address the problem.

I still don't see the difference between cloning both the app and BDB or cloning the app and exporting the BDB to it. You still end up with what is essentially two instances of the app and each contains the BDB. At the end of the road, wouldn't the clones or the clone and copy be erased.

According to your post, the Serena folks said to export the BDB into a new instance of Oracle. Was this new instance supposed to be Oracle 11g? If so, I can see one problem. If something goes wrong, how do you know whether its the upgraded app or the 11g conversion that caused the problem?

If the purpose is to test the app upgrade (to make sure you don't lose anything), then the reason for creating the new BDB in a clean instance of (old) Oracle might be to ensure that either of the apps (original or clone) doesn't get confused and try to access the wrong BDB. If you don't use a new instance of Oracle, then as far as Oracle is concerned, you might have two databases in the same instance, both with the same name and same characteristics. Also, and I'm guessing here, if you're testing the app upgrade, then obviously you would want to get the app and BDB cloned or exported before doing the app upgrade. (I suspect the reason for the testing is to ensure that nothing is lost because of the upgrade).

But again, without knowing what the objection is to exporting (vice cloning) the BDB, it's near impossible to address the issue.

CMCrossroads is a TechWell community.

Through conferences, training, consulting, and online resources, TechWell helps you develop and deliver great software every day.